Click here to Skip to main content
15,909,518 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
if (Conversion.Val(txtSubTotal.Text) < Conversion.Val(txtAdvance.Text) || Conversion.Val(txtSubTotal.Text) == Conversion.Val(txtAdvance.Text))
                    {
                        Interaction.MsgBox("Guest Successfully Checkin! " + "Change: N " + Conversion.Val(System.Convert.ToInt32(Conversion.Val(txtAdvance.Text) - Conversion.Val(txtSubTotal.Text))).ToString("00.00"), Constants.vbInformation, "Check In");
                        string change = System.Convert.ToString(Interaction.MsgBox("Return change to customer?", (int)Constants.vbQuestion + Constants.vbYesNo, "Change"));
                        if (change == Constants.vbYes.ToString())
                        {
                            OleDbCommand update_trans = new OleDbCommand("UPDATE tblTransaction SET AdvancePayment = " + Conversion.Val(txtSubTotal.Text) + " WHERE TransID = " + trans_ID.ToString() + "", Module1.con);
                            update_trans.ExecuteNonQuery();
                        }
                    }
                    else
                    {
                        Interaction.MsgBox("Guest Successfully Checkin!", Constants.vbInformation, "Check In");
                    }

                    clear_text();
                    Module1.con.Close();
                    transID();
                    display_checkin();


Urgent help needed
Posted
Comments
Prasad Avunoori 18-Aug-14 7:13am    
I think you are trying to convert a Non-integer value to integer. Put a break point and review your code.

Try
OleDbCommand update_trans = new OleDbCommand("UPDATE tblTransaction SET AdvancePayment = " + Conversion.Val(txtSubTotal.Text) + " WHERE TransID = '" + trans_ID.ToString() + "'", Module1.con);
 
Share this answer
 
Comments
Member 11019269 18-Aug-14 7:22am    
Stil didnt get it to work..

here is the complete code

public void bttnCheckIn_Click_1(System.Object sender, System.EventArgs e)
{
int children = (int)(Conversion.Val(txtChildren.Text));
int adult = (int)(Conversion.Val(txtAdults.Text));
int advance = (int)(Conversion.Val(txtAdvance.Text));
int discount = (int)(Conversion.Val(lblDiscountID.Text));
string reserve = "0";
string remarks = "Checkin";
string stat = "Active";

if (lblGuestID.Text == "GuestID" || lblGuestID.Text == null || txtRoomNumber.Text == null || Conversion.Val(System.Convert.ToString(children + adult)) == null || advance == null || discount == null)
{
Interaction.MsgBox("Please Fill All Fields", Constants.vbInformation, "Note");
}
else
{
if (Conversion.Val(System.Convert.ToString(Conversion.Val(txtSubTotal.Text) * 0.5)) > Conversion.Val(txtAdvance.Text))
{
MessageBox.Show("Ops");
return;
}
string a = System.Convert.ToString(Interaction.MsgBox("Confirm Checkin Transaction?", (int)Constants.vbQuestion + Constants.vbYesNo, "Check In"));
if (a == Constants.vbYes.ToString())
{
Module1.con.Open();
OleDbCommand checkin = new OleDbCommand("INSERT INTO tblTransaction(GuestID,RoomNum,CheckInDate,CheckOutDate,NoOfChild,NoOfAdult,AdvancePayment,DiscountID,Remarks,Status) values (\'" +
lblGuestID.Text + "\',\'" +
txtRoomNumber.Text + "\',\'" +
txtCheckInDate.Text + "\',\'" +
dtCheckOutDate.Text + "\',\'" +
txtChildren.Text + "\',\'" +
txtAdults.Text + "\',\'" +
txtAdvance.Text + "\',\'" +
lblDiscountID.Text + "\',\'" +
remarks + "\',\'" +
stat + "\')", Module1.con);
checkin.ExecuteNonQuery();

OleDbCommand update_guest = new OleDbCommand("UPDATE tblGuest SET Remarks = \'Checkin\' WHERE ID = " + lblGuestID.Text + "", Module1.con);
update_guest.ExecuteNonQuery();

OleDbCommand update_room = new OleDbCommand("UPDATE tblRoom SET Status = \'Occupied\' WHERE RoomNumber = " + txtRoomNumber.Text + "", Module1.con);
update_room.ExecuteNonQuery();

if (Conversion.Val(txtSubTotal.Text) < Conversion.Val(txtAdvance.Text) || Conversion.Val(txtSubTotal.Text) == Conversion.Val(txtAdvance.Text))
{
Interaction.MsgBox("Guest Successfully Checkin! " + "Change: N " + Conversion.Val(System.Convert.ToString(Conversion.Val(txtAdvance.Text) - Conversion.Val(txtSubTotal.Text))).ToString("00.00"), Constants.vbInformation, "Check In");
string change = System.Convert.ToString(Interaction.MsgBox("Return change to customer?", (int)Constants.vbQuestion + Constants.vbYesNo, "Change"));
if (change == Constants.vbYes.ToString())
{
OleDbCommand update_trans = new OleDbCommand("UPDATE tblTransaction SET AdvancePayment = " + Conversion.Val(txtSubTotal.Text) + " WHERE TransID = '" + trans_ID.ToString() + "'", Module1.con);
update_trans.ExecuteNonQuery();
}
}
else
{
Interaction.MsgBox("Guest Successfully Checkin!", Constants.vbInformation, "Check In");
}

clear_text();
Module1.con.Close();
transID();
display_checkin();
}
}
}
C#
public void bttnCheckIn_Click_1(System.Object sender, System.EventArgs e)
        {
            int children = (int)(Conversion.Val(txtChildren.Text));
            int adult = (int)(Conversion.Val(txtAdults.Text));
            int advance = (int)(Conversion.Val(txtAdvance.Text));
            int discount = (int)(Conversion.Val(lblDiscountID.Text));
            string reserve = "0";
            string remarks = "Checkin";
            string stat = "Active";

            if (lblGuestID.Text == "GuestID" || lblGuestID.Text == null || txtRoomNumber.Text == null || Conversion.Val(System.Convert.ToString(children + adult)) == null || advance == null || discount == null)
            {
                Interaction.MsgBox("Please Fill All Fields", Constants.vbInformation, "Note");
            }
            else
            {
                if (Conversion.Val(System.Convert.ToString(Conversion.Val(txtSubTotal.Text) * 0.5)) > Conversion.Val(txtAdvance.Text))
                {
                    MessageBox.Show("Ops");
                    return;
                }
                string a = System.Convert.ToString(Interaction.MsgBox("Confirm Checkin Transaction?", (int)Constants.vbQuestion + Constants.vbYesNo, "Check In"));
                if (a == Constants.vbYes.ToString())
                {
                    Module1.con.Open();
                    OleDbCommand checkin = new OleDbCommand("INSERT INTO tblTransaction(GuestID,RoomNum,CheckInDate,CheckOutDate,NoOfChild,NoOfAdult,AdvancePayment,DiscountID,Remarks,Status) values (\'" +
                    lblGuestID.Text + "\',\'" +
                    txtRoomNumber.Text + "\',\'" +
                    txtCheckInDate.Text + "\',\'" +
                    dtCheckOutDate.Text + "\',\'" +
                    txtChildren.Text + "\',\'" +
                    txtAdults.Text + "\',\'" +
                    txtAdvance.Text + "\',\'" +
                    lblDiscountID.Text + "\',\'" +
                    remarks + "\',\'" +
                    stat + "\')", Module1.con);
                    checkin.ExecuteNonQuery();

                    OleDbCommand update_guest = new OleDbCommand("UPDATE tblGuest SET Remarks = \'Checkin\' WHERE ID = " + lblGuestID.Text + "", Module1.con);
                    update_guest.ExecuteNonQuery();

                    OleDbCommand update_room = new OleDbCommand("UPDATE tblRoom SET Status = \'Occupied\' WHERE RoomNumber = " + txtRoomNumber.Text + "", Module1.con);
                    update_room.ExecuteNonQuery();

                    if (Conversion.Val(txtSubTotal.Text) < Conversion.Val(txtAdvance.Text) || Conversion.Val(txtSubTotal.Text) == Conversion.Val(txtAdvance.Text))
                    {
                        Interaction.MsgBox("Guest Successfully Checkin! " + "Change: N " + Conversion.Val(System.Convert.ToString(Conversion.Val(txtAdvance.Text) - Conversion.Val(txtSubTotal.Text))).ToString("00.00"), Constants.vbInformation, "Check In");
                        string change = System.Convert.ToString(Interaction.MsgBox("Return change to customer?", (int)Constants.vbQuestion + Constants.vbYesNo, "Change"));
                        if (change == Constants.vbYes.ToString())
                        {
                            OleDbCommand update_trans = new OleDbCommand("UPDATE tblTransaction SET AdvancePayment = " + Conversion.Val(txtSubTotal.Text) + " WHERE TransID = '" + trans_ID.ToString() + "'", Module1.con);
                            update_trans.ExecuteNonQuery();
                        }
                    }
                    else
                    {
                        Interaction.MsgBox("Guest Successfully Checkin!", Constants.vbInformation, "Check In");
                    }

                    clear_text();
                    Module1.con.Close();
                    transID();
                    display_checkin();
                }
            }
        }
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900