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