protected void btnSaveDriver_Click(object sender, EventArgs e) { try { string msg = "Driver information has been saved."; TblDriver obj = new TblDriver(); obj.IsNew = true; if (!string.IsNullOrEmpty(hdndriverID.Value)) { obj = new TblDriver(hdndriverID.Value); obj.IsNew = false; msg = "Driver information has been updated."; } obj.DName = txtDName.Text; obj.DMobile = txtDMobile.Text; obj.DCnic = txtDCnic.Text; obj.DAddress = txtDAddress.Text; obj.BusID = Convert.ToInt32(hdnBusID.Value); obj.Save(); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(Page.Controls); hdnBusID.Value = null; } catch (Exception ex) { msgDiv.Visible = true; lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, ex.ToString(), "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o"); lblmsg.Text = ex.ToString(); } loadRptBus(); }
protected void btnDriver_Click(object sender, EventArgs e) { try { LinkButton btn = (LinkButton)sender; TblBu bus = new TblBu(btn.CommandName); txtBusNo1.Text = bus.BusNo.ToString(); hdnBusID.Value = bus.BusID.ToString(); lblDriverPopupHeader.Text = "Add Driver Information"; if (!string.IsNullOrEmpty(btn.CommandArgument)) { TblDriver obj = new TblDriver(btn.CommandArgument); txtDName.Text = obj.DName.ToString(); txtDMobile.Text = obj.DMobile.ToString(); txtDCnic.Text = obj.DCnic.ToString(); txtDAddress.Text = obj.DAddress.ToString(); hdndriverID.Value = obj.Did.ToString(); lblDriverPopupHeader.Text = "Update Driver Information"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModalDriver();", true); } catch (Exception ex) { msgDiv.Visible = true; lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, ex.ToString(), "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o"); lblmsg.Text = ex.ToString(); } }
private static void UpdateProduct(int id) { dri = db.TblDrivers.Find(id); var result = db.TblDrivers.ToList(); //prints the table data foreach (var item in result) { Console.WriteLine("Name:" + item.Name + "PHONE:" + item.Phone + "STATUS:" + item.Status); } dri = AcceptData(); db.Update(dri); db.SaveChanges(); }
public static void DeleteData(int id) { dri = db.TblDrivers.Find(id); if (dri == null) { Console.WriteLine("no such employee exists"); } else { db.TblDrivers.Remove(dri); db.SaveChanges(); Console.WriteLine("the employee is deleted "); } }
public TblDriver UpdateTblDriverToDataBase(int DriverID, TblDriver uDriver) { try { var dbDriver = this.Context.TblDriver.Find(DriverID); if (dbDriver != null) { uDriver.CreateDate = dbDriver.CreateDate; uDriver.ModifyDate = this.DateOfServer; uDriver.Modifyer = uDriver.Modifyer ?? "someone"; if (uDriver.CarId == 0) { uDriver.CarId = null; } if (uDriver.TrailerId == 0) { uDriver.TrailerId = null; } if (!string.IsNullOrEmpty(uDriver.EmployeeDriveCode)) { uDriver.EmployeeDriveCode = this.Context.VEmployee.Find(uDriver.EmployeeDriveCode)?.EmpCode ?? ""; } this.Context.Entry(dbDriver).CurrentValues.SetValues(uDriver); return(this.Context.SaveChanges() > 0 ? this.GetTblDriverWithKey(DriverID) : null); } } catch (Exception ex) { Debug.WriteLine("Has error " + ex.ToString()); } return(null); }
public TblDriver InsertTblDriverToDataBase(TblDriver nDriver) { try { if (nDriver != null) { nDriver.CreateDate = this.DateOfServer; nDriver.Creator = nDriver.Creator ?? "someone"; if (!string.IsNullOrEmpty(nDriver.EmployeeDriveCode)) { nDriver.EmployeeDriveCode = this.Context.VEmployee.Find(nDriver.EmployeeDriveCode)?.EmpCode ?? ""; } this.Context.TblDriver.Add(nDriver); return(this.Context.SaveChanges() > 0 ? this.GetTblDriverWithKey(nDriver.EmployeeDriveId) : null); } } catch (Exception ex) { Debug.WriteLine("Has error " + ex.ToString()); } return(null); }
private static void InsertData(TblDriver d1) { db.TblDrivers.Add(d1); db.SaveChanges(); }