public Int64 Update(tblFuelRateMaster Master, Int32 id)
{
Int64 Idno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblFuelRateMaster objtbl = (from obj in db.tblFuelRateMasters
where obj.FuelRate_Idno == id
select obj).SingleOrDefault();
if (objtbl != null)
{
objtbl.FuelRate_Date = Master.FuelRate_Date;
objtbl.Acnt_Idno = Master.Acnt_Idno;
objtbl.Fuel_Rate = Master.Fuel_Rate;
objtbl.Status = Master.Status;
objtbl.ItemIdno = Master.ItemIdno;
objtbl.Year_Idno = Master.Year_Idno;
objtbl.Date_Modified = System.DateTime.Now;
db.SaveChanges();
Idno = Convert.ToInt32(objtbl.FuelRate_Idno);
}
}
}
catch (Exception ex)
{
Idno = 0;
}
return(Idno);
}
public Int64 Insert(tblFuelRateMaster Master)
{
Int64 Idno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var objtbl = (from obj in db.tblFuelRateMasters where obj.Acnt_Idno == Master.Acnt_Idno && obj.FuelRate_Date == Master.FuelRate_Date && obj.ItemIdno != null && obj.ItemIdno == Master.ItemIdno select obj).ToList();
if (objtbl.Count == 0)
{
db.AddTotblFuelRateMasters(Master);
db.SaveChanges();
Idno = Convert.ToInt32(Master.FuelRate_Idno);
}
else
{
Idno = -1;
}
}
}
catch (Exception ex)
{
}
return(Idno);
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtFuelRate.Text.Trim()) == true || Convert.ToDouble(txtFuelRate.Text.Trim()) <= 0)
{
this.ShowMessageErr("Rate Should be greater than Zero."); return;
}
if (drpFuel.SelectedValue == "0")
{
this.ShowMessageErr("Please select fuel."); drpFuel.Focus(); return;
}
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string smsg = string.Empty;
Int64 FuelIdno = 0;
FuelRateMasterDAL objDAL = new FuelRateMasterDAL();
tblFuelRateMaster tblobj = new tblFuelRateMaster();
tblobj.FuelRate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim()));
tblobj.Acnt_Idno = Convert.ToInt32(drpPump.SelectedValue);
tblobj.Fuel_Rate = Convert.ToDouble(txtFuelRate.Text.Trim());
tblobj.Comp_Idno = Convert.ToInt32(cOMPiD);
tblobj.ItemIdno = Convert.ToInt32(drpFuel.SelectedValue);
tblobj.Status = true;
tblobj.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue);
tblobj.Date_Added = System.DateTime.Now;
if (string.IsNullOrEmpty(hidIdno.Value) == true)
{
FuelIdno = objDAL.Insert(tblobj);
}
else
{
FuelIdno = objDAL.Update(tblobj, Convert.ToInt32(hidIdno.Value));
}
if (FuelIdno == 0)
{
ShowMessageErr("Record Not Saved ");
this.ClearControls();
}
else if (FuelIdno < 0)
{
ShowMessageErr("Record already exists.");
this.ClearControls();
}
else if (FuelIdno > 0)
{
if (string.IsNullOrEmpty(hidIdno.Value) == true)
{
ShowMessage("Record Saved Successfully");
this.ClearControls();
}
else
{
ShowMessage("Record Updated Successfully.");
this.ClearControls();
}
this.BindGrid();
this.ClearControls();
}
}
private void Populate(int Idno)
{
lnkbtnNew.Visible = true;
FuelRateMasterDAL objDAL = new FuelRateMasterDAL();
tblFuelRateMaster tblMast = objDAL.SelectByID(Idno);
objDAL = null;
if (tblMast != null)
{
ddlDateRange.SelectedValue = Convert.ToString(tblMast.Year_Idno);
txtDate.Text = Convert.ToString(Convert.ToDateTime(tblMast.FuelRate_Date).ToString("dd-MM-yyyy"));
drpPump.SelectedValue = Convert.ToString(tblMast.Acnt_Idno);
txtDate.Enabled = drpPump.Enabled = false;
drpFuel.SelectedValue = Convert.ToString(tblMast.ItemIdno ?? 0);
txtFuelRate.Text = Convert.ToString(tblMast.Fuel_Rate);
hidIdno.Value = tblMast.FuelRate_Idno.ToString();
}
}
public int Delete(int Idno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblFuelRateMaster TaxMast = (from Obj in db.tblFuelRateMasters
where Obj.FuelRate_Idno == Idno
select Obj).SingleOrDefault();
if (TaxMast != null)
{
db.tblFuelRateMasters.DeleteObject(TaxMast);
db.SaveChanges();
value = 1;
}
}
}
catch
{
}
return(value);
}
