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);
}
