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!"); } } }