public int Insert() { int inserted = 0; Boolean flag = false; String query = "insert into tbluserrecord values('" + Email + "','" + Name + "','" + Address + "','" + Mobile + "','" + Password + "','" + UserImage + "','" + Feedback + "')"; String query1 = "select Email from tbluserrecord where Email='" + Email + "'"; flag = dbobj.CheckDuplicate(query1); if (flag == false) { inserted = dbobj.InsertUpdateDelete(query); } return(inserted); }
public int Insert() { int inserted = 0; Boolean flag = false; String query = "insert into tblcar values('" + CarNo + "','" + CarName + "','" + CarType + "','" + FuelType + "','" + Description + "','" + CarImage + "'," + HrlyRate + "," + MinHrs + ",'" + CarCatName + "','" + "NO" + "')"; String query1 = "select CarNo from tblcar where CarNo='" + CarNo + "'"; flag = dbobj.CheckDuplicate(query1); if (flag == false) { inserted = dbobj.InsertUpdateDelete(query); } return(inserted); }
protected void btnSubmitCat_Click(object sender, EventArgs e) { int c = 0; ob.CarCatName = txtCarCatName.Text; Boolean flag = false; String query = "insert into tblcarcat values('" + ob.CarCatName + "','" + txtSeater.Text + "')"; String query1 = "select CarCatName from tblcarcat where CarCatName='" + ob.CarCatName + "'"; try { flag = dbobj.CheckDuplicate(query1); if (flag == false) { c = dbobj.InsertUpdateDelete(query); } if (c == 1) { lblmsg.Text = "Car Inserted Successfully"; } else { lblmsg.Text = "Car Category Already Exists"; } txtCarCatName.Text = ""; txtSeater.Text = ""; } catch (Exception err) { lblmsg.Text = err.Message; } }
public int Delete() { int deleted = 0; Boolean flag = false; String query = "delete from tblbooking where BookingID='" + BookingID + "'"; String query1 = "select Email from tblbooking where BookingID='" + BookingID + "'"; flag = dbobj.CheckDuplicate(query1); if (flag == true) { deleted = dbobj.InsertUpdateDelete(query); } return(deleted); }