void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select State_M.State_Id 'State_Id',State_Name 'State_Name' from State_M");
gf.fill_grid(ds, grdstate_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Plane_M.Plane_Id,Plane_Name,Business_Seat,Economy_Seat from Plane_M");
gf.fill_grid(ds, grdplane_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Payment_T.Reservation_Id,Payment_Type,Payment_Date,Amount,BankName from Payment_T,Customer_Travel_T where Customer_Travel_T.Reservation_Id=Payment_T.Reservation_Id and Payment_T.reservation_id in(select reservation_id from reservation_M where customer_id = (select customer_id from customer_M where email='" + Session["Email"].ToString() + "'))");
gf.fill_grid(ds, grdpayment_t);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Customer_Travel_T.Reservation_Id,NumberOfSeats,Travel_DateTime,TourFrom,TourTo,Tpid from Customer_Travel_T where reservation_id in(select reservation_id from reservation_M where customer_id = (select customer_id from customer_M where email='" + Session["Email"].ToString() + "'))");
gf.fill_grid(ds, grdcustomertravelt);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Package_M.Package_Id,Package_Name,Price,No_Of_Days,City_Id,Type,Travel_Mode,Hotel_id from Package_M");
gf.fill_grid(ds, grdpackage_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select TravelPackage_M.Tpid,Package_Id,Bus_Id,Train_Id,Plane_Id,car_id,RatePerSeat from TravelPackage_M");
gf.fill_grid(ds, grdtravelpackage_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Reservation_T.Reservation_Id,First_Name,Middle_Name,Last_Name,BirthDate,AadharNo,Gender from Reservation_T,Reservation_M where Reservation_T.Reservation_id=Reservation_M.Reservation_id and customer_id=(select customer_id from customer_M where email='" + Session["Email"].ToString() + "' )");
gf.fill_grid(ds, grdreservation_t);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Car_M.Car_Id ,Car_Details,Fuel_Type,Car_Name,Car_Registrationnumber from Car_M");
gf.fill_grid(ds, grdcar_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Bus_M.Bus_Id,Bus_Details ,Fuel_Type , Bus_Name ,Registration_No ,Seats_Appears from Bus_M");
gf.fill_grid(ds, grdbus_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select * from Reservation_M where customer_id=(select customer_id from customer_M where email='" + Session["Email"].ToString() + "' )");
gf.fill_grid(ds, grdreservation_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select City_M.City_Id 'City Id',City_Name 'City Name', State_Name 'State Name' from City_M,State_M where City_M.State_Id=State_M.State_Id");
gf.fill_grid(ds, grdcity_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Train_M.Train_Id,Train_Type,Train_Time,Train_No from Train_M");
gf.fill_grid(ds, grdtrain_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Hotel_M.Hotel_Id ,Hotel_Name ,Star,Address_Line1,Address_Line2,Address_Line3,City,Pincode,ContactNumber1,ContactNumber2,Email from Hotel_M");
gf.fill_grid(ds, grdhotel_m);
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count(*) from account_type_master where account_type_name= '" + cblaccounttype.SelectedValue + "'";
ds = cn.select(str);
{
str = "insert into account_type_master(account_type_name) values ('" + cblaccounttype.SelectedValue + "')";
cn.modify(str);
Response.Write("<script>alert('inserted')</script>");
}
viewaccount_type();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from payback_master where vouchar_name='" + txtvoucharname.Text + "' and payback_detail='" + txtpaybackdetail.Text + "' and payback_amount=" + txtpaybackamount.Text + "";
ds = cn.select(str);
{
str = "insert into payback_master(vouchar_name,payback_detail,payback_amount) values ('" + txtvoucharname.Text + "','" + txtpaybackdetail.Text + "'," + txtpaybackamount.Text + ")";
cn.modify(str);
Response.Write("<script>alert('Payback inserted')</script>");
}
viewpayback();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from feedback_master where account_no=" + drpaccountno.SelectedValue + " and datetime='" + txtdatetime.Text + "' and feedback='" + txtfeedback.Text + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into feedback_master(account_no,datetime,feedback) values (" + drpaccountno.SelectedValue + ",'" + txtdatetime.Text + "','" + txtfeedback.Text + "')";
cn.modify(str);
Response.Write("<script>alert('Feedback inserted..')</script>");
}
viewfeedback();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count (*) from card_transaction where account_no=" + txtaccountno.Text + "and card_type='" + rblcardtype.SelectedValue + "'and card_no=" + txtcardno.Text + "and apply_date='" + txtapplydate.Text + "'and issue_date='" + txtissuedate.Text + "'and status=" + rblstatus.SelectedValue + "and emp_id=" + drpempid.SelectedValue + "";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into card_transaction (account_no,card_type,card_no,apply_date,issue_date,status,emp_id) values (" + txtaccountno.Text + ",'" + rblcardtype.SelectedValue + "'," + txtcardno.Text + ",'" + txtapplydate.Text + "','" + txtissuedate.Text + "','" + rblstatus.SelectedValue + "'," + drpempid.SelectedValue + ")";
cn.modify(str);
Response.Write("<script>alert('card transaction Detali inserted')</script>");
}
viewcardtransaction();
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from login where email_id='" + txtemail_id.Text + "' and password='******' and sec_q_id=" + drpaecqid.SelectedValue + " and sec_q_ans='" + txtsec_q_ans.Text + "' and user_type='" + rbluser_type.SelectedValue + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into login (email_id,password,sec_q_id,sec_q_ans,user_type) values ('" + txtemail_id.Text + "','" + txtpassword.Text + "'," + drpaecqid.SelectedValue + ",'" + txtsec_q_ans.Text + "','" + rbluser_type.SelectedValue + "')";
cn.modify(str);
Response.Write("<script>alert('Welcome :)')</script>");
}
viewlogin();
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select feedback.email,Feedback_description,date from feedback");
gf.fill_grid(ds, grdfeedback);
}
protected void btnsave_click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from city_master where city_name='" + txtcityname.Text + "'and state_id=" + drpstate.SelectedValue + "";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into city_master(city_name,state_id) values ('" + txtcityname.Text + "'," + drpstate.SelectedValue + ")";
cn.modify(str);
Response.Write("<script>alert('City inserted..')</script>");
}
else
{
Response.Write("<script>alert('City duplicate')</script>");
}
viewcity();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count (*) from loan_penalty where account_no=" + drpaccountno.SelectedValue + " and loan_id=" + drploanid.SelectedValue + " and amount=" + txtamount.Text + " and description='" + txtdescription.Text + "' and date='" + txtdate.Text + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into loan_penalty (account_no,loan_id,amount,description,date) values (" + drpaccountno.SelectedValue + "," + drploanid.SelectedValue + "," + txtamount.Text + ",'" + txtdescription.Text + "','" + txtdate.Text + "')";
cn.modify(str);
Response.Write("<script>alert('loan_penalty Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('loan_penalty Detali Duplicate')</script>");
}
viewpenalty();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from account_nominee where account_no=" + drpaccountno.SelectedValue + " and nominee_id=" + drpnomineeid.SelectedValue + "and date='" + txtdate.Text + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into account_nominee(account_no,nominee_id,date) values (" + drpaccountno.SelectedValue + "," + drpnomineeid.SelectedValue + ",'" + txtdate.Text + "')";
cn.modify(str);
Response.Write("<script>alert('account nominee Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('account nominee Detali duplicate')</script>");
}
viewaccountnominee();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from state_master where state_name='" + txtstatename.Text + "'and country_id=" + drpcountry.SelectedValue;
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into state_master(state_name,country_id) values ('" + txtstatename.Text + "'," + drpcountry.SelectedValue + ")";
cn.modify(str);
Response.Write("<script>alert('inserted')</script>");
}
else
{
Response.Write("<script>alert('duplicate')</script>");
}
viewstate();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select *from chequebook_transaction where account_no=" + drpaccount.SelectedValue + " and issue_date='" + txtissuedate.Text + "' and start_number=" + txtstartnumber.Text + " and end_number=" + txtendnumber.Text + " and apply_date='" + txtapplydate.Text + "'and emp_id=" + drpempid.SelectedValue + "";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into chequebook_transaction (account_no,issue_date,start_number,end_number,apply_date,emp_id) values (" + drpaccount.SelectedValue + ",'" + txtissuedate.Text + "'," + txtstartnumber.Text + "," + txtendnumber.Text + ",'" + txtapplydate.Text + "'," + drpempid.SelectedValue + ")";
cn.modify(str);
Response.Write("<script>alert('chequebook_transaction Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('chequebook_transaction Detali duplicate')</script>");
}
viewcheque();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select *from account_transaction where account_no=" + drpaccountno.SelectedValue + "and amount=" + txtamount.Text + " and transaction_datetime='" + txttransaction_datetime.Text + "' and description='" + txtdescription.Text + "' and charges_id='" + drpcharges_id.SelectedValue + "' and transaction_type='" + rbltransaction_type.SelectedValue + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into account_transaction (account_no,amount,transaction_datetime,description,charges_id,transaction_type) values (" + drpaccountno.SelectedValue + "," + txtamount.Text + ",'" + txttransaction_datetime.Text + "' ,'" + txtdescription.Text + "','" + drpcharges_id.SelectedValue + "','" + rbltransaction_type.SelectedValue + "')";
cn.modify(str);
Response.Write("<script>alert('account_transaction Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('account_transaction Detali duplicate')</script>");
}
viewaccount();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select * from country_master where country_name ='" + txtcountryname.Text + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows.Count == 0)
{
str = "insert into country_master(country_name) values('" + txtcountryname.Text + "')";
cn.modify(str);
Response.Write("<script>alert('Country Record inserted')</script>");
}
else
{
Response.Write("<script>alert('Country Record duplicate')</script>");
}
viewcountry();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count (*) from nominee_master where nominee_f_name='" + txtfname.Text + "'and nominee_m_name='" + txtmname.Text + "'and nominee_l_name='" + txtlname.Text + "'and account_no=" + txtaccountno.Text + " and address1='" + txtaddress1.Text + "' and address2='" + txtaddress2.Text + "' and address3='" + txtaddress3.Text + "'and relationshipwith='" + txtrelationshipwith.Text + "'and nominee_dateofbirth='" + txtdateofbirth.Text + "'";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into nominee_master (nominee_f_name,nominee_m_name,nominee_l_name,account_no,address1,address2,address3,relationshipwith,nominee_dateofbirth) values ('" + txtfname.Text + "','" + txtmname.Text + "','" + txtlname.Text + "'," + txtaccountno.Text + ",'" + txtaddress1.Text + "','" + txtaddress2.Text + "','" + txtaddress3.Text + "','" + txtrelationshipwith.Text + "','" + txtdateofbirth.Text + "')";
cn.modify(str);
Response.Write("<script>alert('nominee Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('nominee Detali Duplicate')</script>");
}
viewnominee();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count(*) from loan_repayment where account_no=" + drpaccountno.SelectedValue + " and loan_id=" + drploanid.SelectedValue + " and date='" + txtdate.Text + "' and amount=" + txtamount.Text + " and payby='" + txtpayby.Text + "' and cheque_no=" + txtchequeno.Text + " and card_no=" + txtcardno.Text + " and description='" + txtdescription.Text + "' ";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into loan_repayment (account_no,loan_id,date,amount,payby,cheque_no,card_no,description) values (" + drpaccountno.SelectedValue + "," + drploanid.SelectedValue + ",'" + txtdate.Text + "'," + txtamount.Text + ",'" + txtpayby.Text + "'," + txtchequeno.Text + "," + txtcardno.Text + ",'" + txtdescription.Text + "')";
cn.modify(str);
Response.Write("<script>alert('Loanrepayment detail inserted')</script>");
}
else
{
Response.Write("<script>alert('Loanrepayment duplicate')</script>");
}
viewloanrepayment();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count(*) from loan_master where loan_type='" + txtloan_type.Text + "' and max_loan=" + txtmax_loan.Text + " and min_loan=" + txtmin_loan.Text + " and interest_rate=" + txtinterest_rate.Text + "";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into loan_master (loan_type,max_loan,min_loan,interest_rate) values ('" + txtloan_type.Text + "'," + txtmax_loan.Text + "," + txtmin_loan.Text + "," + txtinterest_rate.Text + ")";
cn.modify(str);
Response.Write("<script>alert('Loan inserted')</script>");
}
else
{
Response.Write("<script>alert('Loan duplicate')</script>");
}
viewloan_master();
}
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = "select count (*) from customer where f_name='" + txtf_name.Text + "'and m_name='" + txtm_name.Text + "'and l_name='" + txtl_name.Text + "'and email_id='" + txtemail_id.Text + "'and address1='" + txtaddress1.Text + "'and address2='" + txtaddress2.Text + "'and address3='" + txtaddress3.Text + "'and pincode=" + txtpincode.Text + "and city_id=" + drpcity_id.SelectedValue + " and adhar_no=" + txtadhar_no.Text + "and branch_id=" + drpbranch_id.SelectedValue + " and gender='" + rblgender.SelectedValue + "'and birth_date='" + txtbirth_date.Text + "'and contact_no=" + txtcontact_no.Text + "";
ds = cn.select(str);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{
str = "insert into customer (f_name,m_name,l_name,email_id,address1,address2,address3,pincode,city_id,adhar_no,branch_id,gender,birth_date,contact_no) values ('" + txtf_name.Text + "','" + txtm_name.Text + "','" + txtl_name.Text + "','" + txtemail_id.Text + "','" + txtaddress1.Text + "','" + txtaddress2.Text + "','" + txtaddress3.Text + "'," + txtpincode.Text + "," + drpcity_id.SelectedValue + "," + txtadhar_no.Text + "," + drpbranch_id.SelectedValue + ",'" + rblgender.SelectedValue + "','" + txtbirth_date.Text + "'," + txtcontact_no.Text + ")";
cn.modify(str);
Response.Write("<script>alert('Customer Detali inserted')</script>");
}
else
{
Response.Write("<script>alert('Customer Detali Duplicate')</script>");
}
viewcustomer();
}