protected void btnsubmit_Click(object sender, EventArgs e) { Handler hdnpartycode=new Handler(); DataTable dtpartycode = hdnpartycode.GetTable("SELECT VEHICLEID FROM VEHICLEMASTER VM WHERE TRANSPORTERID=" + ddltransporter.SelectedValue.ToString().Trim() + " AND VEHICLENO='" + txtvehicleno.Text.Trim().ToString() + "'"); if (dtpartycode.Rows.Count == 0) { vehiclemaster objvehiclemaster = new vehiclemaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objvehiclemaster.vehiclemaster_VEHICLEID = -1; objvehiclemaster.vehiclemaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.ToString().Trim()); objvehiclemaster.vehiclemaster_STATUS = 0; objvehiclemaster.vehiclemaster_CAPACITY = ddlcapacity.SelectedItem.Text.Trim(); objvehiclemaster.vehiclemaster_VEHICLENO = txtvehicleno.Text.Trim().ToString(); objvehiclemaster.vehiclemaster_VEHICLENAME = txtvehiclename.Text.Trim().ToString(); if (objvehiclemaster.Insert(true, "vehiclemaster")) { MessageBox("Vehicle Added Successfully"); ddltransporter.SelectedIndex = 0; ddlcapacity.SelectedIndex = 0; txtvehicleno.Text = string.Empty; txtvehiclename.Text = string.Empty; FillVehicle(); } } else { MessageBox("Vehicle Already Present"); } }
protected void btnsubmit_Click(object sender, EventArgs e) { vehiclemaster objvehiclemaster = new vehiclemaster(HttpContext.Current.Server.MapPath("~/XML/database.xml")); objvehiclemaster.vehiclemaster_VEHICLEID = -1; objvehiclemaster.vehiclemaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.ToString().Trim()); objvehiclemaster.vehiclemaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.ToString().Trim()); objvehiclemaster.vehiclemaster_CAPACITY = ddlcapacity.SelectedItem.Text.Trim(); objvehiclemaster.vehiclemaster_VEHICLENO = txtvehicleno.Text.Trim().ToString(); objvehiclemaster.vehiclemaster_VEHICLENAME = txtvehiclename.Text.Trim().ToString(); string condition = "VEHICLEID=" + ViewState["VEHICLEID"].ToString(); if (objvehiclemaster.Insert(false, "vehiclemaster", condition)) { MessageBox("Vehicle Updated Successfully"); Response.Redirect("addvehicle.aspx"); } }