public int UpdatePartyItemRate(tblPartyRateMast objParty, Int64 PRateID, bool IsWeight)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
if (IsWeight == false)
{
if (IsExistPartyItemRate(objParty.Rate_Date, objParty.Loc_Idno, objParty.Party_Idno, objParty.Item_Idno, objParty.FrmCity_Idno, objParty.ToCity_Idno, PRateID) == 0)
{
tblPartyRateMast obj = (from PRM in db.tblPartyRateMasts where PRM.PRate_Idno == PRateID select PRM).SingleOrDefault();
obj.Party_Idno = objParty.Party_Idno;
obj.Item_Idno = objParty.Item_Idno;
obj.Loc_Idno = objParty.Loc_Idno;
obj.Item_Rate = objParty.Item_Rate;
obj.Date_Modified = objParty.Date_Modified;
obj.FrmCity_Idno = objParty.FrmCity_Idno;
obj.ToCity_Idno = objParty.ToCity_Idno;
obj.Emp_Idno = objParty.Emp_Idno;
obj.Rate_Date = objParty.Rate_Date;
db.SaveChanges();
return(1);
}
else
{
return(2);
}
}
else
{
if (IsExistPartyItemRate(objParty.Rate_Date, objParty.Loc_Idno, objParty.Party_Idno, objParty.Item_Idno, objParty.FrmCity_Idno, objParty.ToCity_Idno, PRateID, objParty.Item_Weight) == 0)
{
tblPartyRateMast obj = (from PRM in db.tblPartyRateMasts where PRM.PRate_Idno == PRateID select PRM).SingleOrDefault();
obj.Party_Idno = objParty.Party_Idno;
obj.Item_Idno = objParty.Item_Idno;
obj.Loc_Idno = objParty.Loc_Idno;
obj.Item_Rate = objParty.Item_Rate;
obj.Date_Modified = objParty.Date_Modified;
obj.FrmCity_Idno = objParty.FrmCity_Idno;
obj.ToCity_Idno = objParty.ToCity_Idno;
obj.Emp_Idno = objParty.Emp_Idno;
obj.Rate_Date = objParty.Rate_Date;
obj.Item_Weight = objParty.Item_Weight;
db.SaveChanges();
return(1);
}
else
{
return(2);
}
}
}
catch (Exception e)
{
return(0);
}
}
}
//For Weight wise rate update
public Int64 IsExistPartyItemRate(DateTime?date, Int64 Loc_id, Int64 PartyId, Int64 Item_id, Int64 FromCity, Int64 ToCity, Int64 PRateId, Decimal?Weight)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPartyRateMast obj = new tblPartyRateMast();
var lst = (from PRM in db.tblPartyRateMasts where PRM.Item_Idno == Item_id && PRM.Loc_Idno == Loc_id && PRM.Party_Idno == PartyId && PRM.Rate_Date == date && PRM.ToCity_Idno == ToCity && PRM.FrmCity_Idno == FromCity && PRM.Party_Idno != PRateId && PRM.Item_Weight == Weight select PRM).SingleOrDefault();
if (lst == null)
{
return(0);
}
else
{
return(PRateId);
}
}
}
public int DeletePartyItemRate(Int64 PRateID)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblPartyRateMast obj = (from PRM in db.tblPartyRateMasts where PRM.PRate_Idno == PRateID select PRM).SingleOrDefault();
db.tblPartyRateMasts.DeleteObject(obj);
db.SaveChanges();
return(1);
}
catch (Exception e)
{
return(0);
}
}
}
public int InsertPartyItemRate(tblPartyRateMast objParty, bool IsWeight)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
if (IsWeight == false)
{
if (IsExistPartyItemRate(objParty.Rate_Date, objParty.Loc_Idno, objParty.Party_Idno, objParty.Item_Idno, objParty.FrmCity_Idno, objParty.ToCity_Idno) == 0)
{
db.tblPartyRateMasts.AddObject(objParty);
db.SaveChanges();
return(1);
}
else
{
return(2);
}
}
else
{
if (IsExistPartyItemRate(objParty.Rate_Date, objParty.Loc_Idno, objParty.Party_Idno, objParty.Item_Idno, objParty.FrmCity_Idno, objParty.ToCity_Idno, objParty.Item_Weight) == 0)
{
db.tblPartyRateMasts.AddObject(objParty);
db.SaveChanges();
return(1);
}
else
{
return(2);
}
}
}
catch (Exception e)
{
return(0);
}
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
if (drpBaseCity.SelectedValue == "0")
{
ShowMessageErr("Please Select Location!");
return;
}
if (ddlPartyName.SelectedValue == "0")
{
ShowMessageErr("Please Select Party!");
return;
}
if (ddlItemName.SelectedValue == "0")
{
ShowMessageErr("Please Select Item!");
return;
}
if (ddlCityVia.SelectedValue == "0")
{
ShowMessageErr("Please Select To Via City!");
return;
}
if (ddlCity.SelectedValue == "0")
{
ShowMessageErr("Please Select To City!");
return;
}
if (Convert.ToDouble(txt_Weight.Text) <= 0.00 && IsWeight == true)
{
ShowMessageErr("Please Enter Weight More than 0!");
return;
}
Int64 empIdno = Convert.ToInt64((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
tblPartyRateMast obj = new tblPartyRateMast();
obj.Loc_Idno = Convert.ToInt64(drpBaseCity.SelectedValue);
obj.Party_Idno = Convert.ToInt64(ddlPartyName.SelectedValue);
obj.Item_Idno = Convert.ToInt64(ddlItemName.SelectedValue);
obj.Rate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text.Trim()).ToString());
obj.FrmCity_Idno = Convert.ToInt64(ddlCityVia.SelectedValue);
obj.ToCity_Idno = Convert.ToInt64(ddlCity.SelectedValue);
obj.Item_Rate = Convert.ToDecimal(txtItemRate.Text.Trim());
obj.Emp_Idno = empIdno;
obj.Date_Added = Convert.ToDateTime(DateTime.Now);
obj.Date_Modified = Convert.ToDateTime(DateTime.Now);
obj.Status = true;
obj.Year_idno = Convert.ToInt32(ddlDateRange.SelectedValue);
RateMasterDAL RM = new RateMasterDAL();
if (IsWeight == false)
{// For Without Weight Wise
obj.Item_Weight = 0;
obj.IsWeight = false;
}
else
{
obj.Item_Weight = Convert.ToDecimal(txt_Weight.Text);
obj.IsWeight = true;
}
if ((hidSaveType.Value != "") && (Convert.ToInt64(hidSaveType.Value)) > 0)
{
int value = RM.UpdatePartyItemRate(obj, Convert.ToInt64(Convert.ToInt64(hidSaveType.Value)), IsWeight);
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Updated Successfully");
}
else if (value == 2)
{
BindGrid();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
ShowMessageErr("Record Not Updated!");
}
}
else
{
int value = RM.InsertPartyItemRate(obj, IsWeight);
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Inserted Successfully");
}
else if (value == 2)
{
BindGrid();
Clear();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
Clear();
ShowMessageErr("Record Not Inserted!");
}
}
}
