public DataTable FetchChallanDetail(string ConString, int yearid) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[2]; objSqlPara[0] = new SqlParameter("@Action", "SelectChlnDet"); objSqlPara[1] = new SqlParameter("@YearIdno", yearid); DataSet objDsTemp = SqlHelper.ExecuteDataset(ConString, CommandType.StoredProcedure, "spChlnConfirm", objSqlPara); DataTable objDtTemp = new DataTable(); if (objDsTemp.Tables.Count > 0) { if (objDsTemp.Tables[0].Rows.Count > 0) { objDtTemp = objDsTemp.Tables[0]; } } return(objDtTemp); } }
public bool IsPartyExists(Int64 lorryIdno, Int64 AcntIdno, DateTime date) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblLorryPrtyDetl objLorryMast = new tblLorryPrtyDetl(); objLorryMast = (from mast in db.tblLorryPrtyDetls where mast.Acnt_Idno == AcntIdno && mast.Lorry_Idno == lorryIdno && mast.Valid_From == date select mast).FirstOrDefault(); if (objLorryMast != null) { return(true); } else { return(false); } } }
public IList SelectForSearch(string PostionName) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from CT in db.tblPositionMasts select new { PositIdno = CT.Position_id, PositName = CT.Position_name, Status = CT.IsActive, }).ToList(); if (PostionName != "") { lst = (from I in lst where I.PositName.ToLower().Contains(PostionName.ToLower()) select I).ToList(); } return(lst); } }
public IList SelectDetlByItemIdno(Int64 YearIdno, Int64 LocIdno, Int64 itemIdno, Int64 tyresizeIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var Lst = (from mast in db.Stckdetls join PM in db.tblItemMastPurs on mast.ItemIdno equals PM.Item_Idno join L in db.tblCityMasters on mast.Loc_Idno equals L.City_Idno join TS in db.TyreSizeMasters on mast.TyresizeIdno equals TS.TyreSize_Idno into temptyre from TS in temptyre.DefaultIfEmpty() where mast.Item_from == "O" select new { Item_Name = PM.Item_Name, YearIdno = mast.yearId, Item_Idno = mast.ItemIdno, Loc_Idno = mast.Loc_Idno, Loc_Name = L.City_Name, SerialNo = mast.SerialNo, SerialIdno = mast.SerlDetl_id, CompName = mast.CompName, ItemType = mast.Type, PurFrom = mast.PurFrom, OpenRate = mast.OpenRate, tyresizeidno = mast.TyresizeIdno, tyresize = TS.TyreSize }).ToList(); if (YearIdno > 0) { Lst = Lst.Where(r => r.YearIdno == YearIdno).ToList(); } if (LocIdno > 0) { Lst = Lst.Where(r => r.Loc_Idno == LocIdno).ToList(); } if (itemIdno > 0) { Lst = Lst.Where(r => r.Item_Idno == itemIdno).ToList(); } return(Lst); } }
/// <summary> /// /// </summary> /// <param name="intUOMIdno"></param> /// <param name="strItemName"></param> /// <returns></returns> public IList SelectForSearch(int intItemTypeIdno, string strItemName, Int64 itemtype) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from mast in db.tblItemMastPurs join ig in db.tblIGrpMasts on mast.IGrp_Idno equals ig.IGrp_Idno join IM in db.tblItemTypeMasts on mast.ItemType equals IM.ItemTpye_Idno join u in db.UOMMasts on mast.Unit_Idno equals u.UOM_Idno select new { ItemIdno = mast.Item_Idno, ItemName = mast.Item_Name, IgrpName = ig.IGrp_Name, UOMName = u.UOM_Name, ItemDesc = mast.Item_Desc, PurRate = mast.Pur_Rate, VATTaxPer = mast.VATTax_Per, CSTTaxPer = mast.CSTTax_Per, Status = mast.Status, IGrp_Idno = ig.IGrp_Idno, Item_TypeID = mast.ItemType, TypeName = IM.ItemType_Name, SGST = mast.SGST, CGST = mast.CGST, IGST = mast.IGST }).ToList(); if (strItemName != "") { lst = (from I in lst where I.ItemName.ToLower().Contains(strItemName.ToLower()) select I).ToList(); } if (intItemTypeIdno > 0) { lst = (from I in lst where I.IGrp_Idno == intItemTypeIdno select I).ToList(); } if (itemtype > 0) { lst = (from I in lst where I.Item_TypeID == itemtype select I).ToList(); } return(lst); } }
public IList SelectForSearch(string strPPumpName, Int32 intStateIdno, Int32 intCityIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from CT in db.PetrolPumpMasters join sm in db.tblStateMasters on CT.PPump_State equals sm.State_Idno join cm in db.tblCityMasters on CT.PPump_City equals cm.City_Idno join com in db.tblPCompanyMasters on CT.PComp_Idno equals com.PComp_Idno select new { PPumpIdno = CT.PPump_Idno, PPumpName = CT.PPump_Name, PCompIdno = com.PComp_Idno, PCompName = com.PComp_Name, PPumpPersonName = CT.PPumpPerson_Name, PPumpPersonDesignation = CT.PPumpPerson_Designation, PPumpLadlineCode = CT.PPump_LadlineCode, PPumpLadlineno = CT.PPump_Ladlineno, PPumpMobileno = CT.PPump_Mobileno, PPumpAddress1 = CT.PPump_Address1, PPumpAddress2 = CT.PPump_Address2, PPumpStateIdno = sm.State_Idno, PPumpCityIdno = cm.City_Idno, PPumpState = sm.State_Name, PPumpCity = cm.City_Name, Status = CT.Status, }).ToList(); if (intStateIdno > 0) { lst = (from l in lst where l.PPumpStateIdno == intStateIdno select l).ToList(); } if (intCityIdno > 0) { lst = (from l in lst where l.PPumpCityIdno == intCityIdno select l).ToList(); } if (strPPumpName != "") { lst = (from l in lst where l.PPumpName.ToLower().Contains(strPPumpName.ToLower()) select l).ToList(); } return(lst); } }
public DataTable SelectPayDet(string ConString, int id) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[2]; objSqlPara[0] = new SqlParameter("@Action", "SelectPayDet"); objSqlPara[1] = new SqlParameter("@Id", id); DataSet objDsTemp = SqlHelper.ExecuteDataset(ConString, CommandType.StoredProcedure, "spPayRecAgChlnBk", objSqlPara); DataTable objDtTemp = new DataTable(); if (objDsTemp.Tables.Count > 0) { if (objDsTemp.Tables[0].Rows.Count > 0) { objDtTemp = objDsTemp.Tables[0]; } } return(objDtTemp); } }
public DataTable SelecthireDetail(Int64 hireIDNO, string con) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[2]; objSqlPara[0] = new SqlParameter("@Action", "SelectHireDetail"); objSqlPara[1] = new SqlParameter("@Id", hireIDNO); DataSet objDsTemp = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spHireLorryDetl", objSqlPara); DataTable objDtTemp = new DataTable(); if (objDsTemp.Tables.Count > 0) { if (objDsTemp.Tables[0].Rows.Count > 0) { objDtTemp = objDsTemp.Tables[0]; } } return(objDtTemp); } }
public Int64 Count(Int64 YearIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from SM in db.StckMasts join IM in db.tblItemMastPurs on SM.Item_Idno equals IM.Item_Idno join CM in db.tblCityMasters on SM.Loc_Idno equals CM.City_Idno where SM.Year_Idno == YearIdno && IM.ItemType == 2 select new { YearIdno = SM.Year_Idno, LocIdno = SM.Loc_Idno, LocName = CM.City_Name, Qty = (from S in db.StckMasts where S.Loc_Idno == SM.Loc_Idno select S.Open_Qty).Sum() }).Distinct().Count()); } }
public DataTable selectInvoiceReportDetails(string strAction, Int32 Inv_Idno, string con) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[2]; objSqlPara[0] = new SqlParameter("@Action", strAction); objSqlPara[1] = new SqlParameter("@InvoiceNo", Inv_Idno); DataSet objDsTemp = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spInvoiceReport", objSqlPara); DataTable objDtTemp = new DataTable(); if (objDsTemp.Tables.Count > 0) { if (objDsTemp.Tables[0].Rows.Count > 0) { objDtTemp = objDsTemp.Tables[0]; } } return(objDtTemp); } }
/// <summary> /// /// </summary> /// <param name="intUOMIdno"></param> /// <param name="strUOMName"></param> /// <returns></returns> public IList SelectForSearch(string strUOMName) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from mast in db.UOMMasts select new { UOMIdno = mast.UOM_Idno, UOMName = mast.UOM_Name, UOMDesc = mast.UOM_Desc, Status = mast.Status }).ToList(); if (strUOMName != "") { lst = (from I in lst where I.UOMName.ToLower().Contains(strUOMName.ToLower()) select I).ToList(); } return(lst); } }
/// <summary> /// Update records in ItemMast /// </summary> /// <param name="strUOMName"></param> /// <param name="strUOMDesc"></param> /// <param name="bStatus"></param> /// <param name="intUOMIdno"></param> /// <returns></returns> public Int64 Update(tblFreightMemo obj, Int64 HeadIdno) { Int64 intValue = 0; //Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblFreightMemo objItemMast = (from mast in db.tblFreightMemoes where mast.FMemo_Idno == HeadIdno select mast).FirstOrDefault(); if (objItemMast != null) { objItemMast.Rcpt_Date = obj.Rcpt_Date; objItemMast.Rcpt_No = obj.Rcpt_No; objItemMast.Gr_No = obj.Gr_No; objItemMast.ToCity_Idno = obj.ToCity_Idno; objItemMast.Receiver_Idno = obj.Receiver_Idno; objItemMast.Tot_Qty = obj.Tot_Qty; objItemMast.Tot_Weight = obj.Tot_Weight; objItemMast.Freight_Amnt = obj.Freight_Amnt; objItemMast.Service_Amnt = obj.Service_Amnt; objItemMast.Labour_Amnt = obj.Labour_Amnt; objItemMast.Delivery_Amnt = obj.Delivery_Amnt; objItemMast.Octrai_Amnt = obj.Octrai_Amnt; objItemMast.Damage_Amnt = obj.Damage_Amnt; objItemMast.Net_Amnt = obj.Net_Amnt; objItemMast.GR_Idno = obj.GR_Idno; objItemMast.Year_Idno = obj.Year_Idno; objItemMast.Remarks = obj.Remarks; db.SaveChanges(); intValue = objItemMast.FMemo_Idno; // } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
public Int64 Insert(string CompName, string OwnerName, string LastName, string EmailId, string OwnPhoneNum, string OwnMobileNum, string Ipaddress, Boolean Status) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities()) { if (IsExists(EmailId) == true) { intValue = -1; } else { tblNewReg objtblRegister = new tblNewReg(); objtblRegister.Comp_Name = CompName; objtblRegister.Name = OwnerName; objtblRegister.LastName = LastName; //objtblRegister.NewReg_Addr2 = Address2; //objtblRegister.City_Idno = CityIdno; //objtblRegister.State_Idno = StateIdno; //objtblRegister.Pin_No = PinNo; objtblRegister.Email_Id = EmailId; //objtblRegister.Phone_No = OwnPhoneNum; objtblRegister.Mobile_No = OwnMobileNum; objtblRegister.Date_Addedd = System.DateTime.Now; objtblRegister.Ipaddress = Ipaddress; objtblRegister.Status = Status; db.AddTotblNewRegs(objtblRegister); db.SaveChanges(); intValue = objtblRegister.NewReg_Idno; } } } catch (Exception ex) { } return(intValue); }
public IList SelectMatDetail(int matIDNO) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from GD in db.MatIssDetls join IM in db.tblItemMastPurs on GD.Iteam_Idno equals IM.Item_Idno join TS in db.TyreSizeMasters on GD.TyresizeIdno equals TS.TyreSize_Idno into temptyre join TP in db.tblPositionMasts on GD.Tyreposition_Idno equals TP.Position_id into temptyreP from TS in temptyre.DefaultIfEmpty() from TP in temptyreP.DefaultIfEmpty() where GD.MatIssHead_Idno == matIDNO select new { GD.Item_Qty, GD.Item_Weght, GD.Item_Amnt, GD.MatIssHead_Idno, GD.Iteam_Idno, GD.Item_Rate, GD.Remark, IM.Item_Name, SerialNo = (from n in db.Stckdetls join MT in db.MatIssIdDetls on GD.MatIssHead_Idno equals MT.DocIdno where n.SerlDetl_id == MT.StckIdno && MT.MtrlDetlIdno == GD.MatIssDet_Idno select n.SerialNo).FirstOrDefault(), SerialId = (from n in db.Stckdetls join MT in db.MatIssIdDetls on GD.MatIssHead_Idno equals MT.DocIdno where n.SerlDetl_id == MT.StckIdno && MT.MtrlDetlIdno == GD.MatIssDet_Idno select n.SerlDetl_id).FirstOrDefault(), NSD = GD.NSD, PSI = GD.PSI, TType = GD.TType, RSerial_No = GD.RSerial_No, RSerial_Idno = GD.RSerial_Idno, RNSD = GD.RNSD, RPSI = GD.RPSI, RTType = GD.RTType, PrevAlignDate = GD.Prev_AlignDate, Align = GD.Align, AlignDate = GD.AlignDate, RPrice = GD.RPrice, GD.TyresizeIdno, TS.TyreSize, TP.Position_name, GD.Tyreposition_Idno }).ToList(); return(lst); } }
public IList Search(DateTime?DtFrom, DateTime?DtTo, Int32 RcptNo, Int32 ToCity, Int32 YearIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from obj in db.tblFreightMemoes join CM in db.tblCityMasters on obj.ToCity_Idno equals CM.City_Idno select new { obj.Rcpt_Date, obj.Rcpt_No, obj.ToCity_Idno, obj.Year_Idno, CM.City_Name, obj.FMemo_Idno, obj.Net_Amnt } ).ToList(); if (DtFrom != null) { lst = (from l in lst where l.Rcpt_Date >= DtFrom select l).ToList(); } if (DtTo != null) { lst = (from l in lst where l.Rcpt_Date <= DtTo select l).ToList(); } if (ToCity > 0) { lst = (from l in lst where l.ToCity_Idno == ToCity select l).ToList(); } if (RcptNo > 0) { lst = (from l in lst where l.Rcpt_No == RcptNo select l).ToList(); } if (YearIdno > 0) { lst = (from l in lst where l.Year_Idno == YearIdno select l).ToList(); } return(lst); } }
/// <summary> /// Insert records in ItemMast /// </summary> /// <param name="strUOMName"></param> /// <param name="strItemDesc"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 Insert(tblFreightMemo obj) { Int64 intValue = 0; try { tblFreightMemo CHead = new tblFreightMemo(); using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.tblFreightMemoes.AddObject(obj); db.SaveChanges(); intValue = obj.FMemo_Idno; } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
public Int32 UpdateStatus(Int32 Emp_ID, bool bStatus) { Int32 intValue = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblEmpSalary objSal = (from mast in db.tblEmpSalaries where mast.EmpSal_ID == Emp_ID select mast).FirstOrDefault(); if (objSal != null) { objSal.EmpSal_Status = bStatus; db.SaveChanges(); intValue = Emp_ID; } } return(intValue); }
public int Delete(int LaneId) { int Value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { LaneMaster tbl = db.LaneMasters.Where(t => t.Lane_Idno == LaneId).FirstOrDefault(); db.LaneMasters.DeleteObject(tbl); db.SaveChanges(); Value = 1; } } catch (Exception ex) { Value = 0; } return(Value); }
public ItemDetailForGrid GetItemByItemId(Int64 ItemId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from item in db.ItemMasts join uom in db.UOMMasts on item.Unit_Idno equals uom.UOM_Idno where item.Item_Idno == ItemId select new { item.Item_Name, item.Item_Idno, Uom = uom.UOM_Name, item.Unit_Idno } ).FirstOrDefault(); ItemDetailForGrid idg = new ItemDetailForGrid(); if (lst != null) { idg.ItemId = lst.Item_Idno; idg.ItemName = lst.Item_Name; idg.Uom = lst.Uom; idg.UomId = Convert.ToInt64(lst.Unit_Idno); } return(idg); } }
public Int64 UpdateLogDetails(Int64 LogId, bool LoginStatus) { Int64 value = 0; Int32 intCompIdno = 1; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblLogDetail objtblLogDetail = (from mast in db.tblLogDetails where mast.Id == LogId select mast).FirstOrDefault(); if (objtblLogDetail != null) { objtblLogDetail.Logout_DateTime = System.DateTime.Now; objtblLogDetail.Login_Status = LoginStatus; db.SaveChanges(); value = LogId; } } return(value); }
/// <summary> /// Fill Grid /// </summary> /// <returns></returns> public IList SelectAll(string strCategoryName) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from mast in db.tblCategoryMasts orderby mast.Category_Name ascending select new { // Item_Name = loc.Item_Name, Cat_Name = mast.Category_Name, Cat_Idno = mast.Category_Idno, Status = mast.Status }).ToList(); if (strCategoryName != "") { lst = (from I in lst where I.Cat_Name.ToLower().Contains(strCategoryName.ToLower()) select I).ToList(); } return(lst); } }
public IList Select_ClaimDetl(Int64 ClaimHead_Idno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var Ilst = (from TCD in db.tblClaimDetls join SD in db.Stckdetls on TCD.StckDetl_Idno equals SD.SerlDetl_id join CM in db.tblCityMasters on SD.Loc_Idno equals CM.City_Idno join IM in db.tblItemMastPurs on SD.ItemIdno equals IM.Item_Idno join TSB in db.tblSBillHeads on TCD.SBillHead_Idno equals TSB.SBillHead_Idno join AM in db.AcntMasts on TSB.Prty_Idno equals AM.Acnt_Idno where TCD.ClaimHead_Idno == ClaimHead_Idno select new { SD.SerlDetl_id, SD.SerialNo, }).ToList(); return(Ilst); } }
public Int64 UpdateAdminApproval(Int32 InvIdno, bool AdminApproval) { Int64 value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblInvGenHead objTblInvHead = (from obj1 in db.tblInvGenHeads where obj1.Inv_Idno == InvIdno select obj1).FirstOrDefault(); objTblInvHead.Admin_Approval = AdminApproval; db.SaveChanges(); value = Convert.ToInt64(objTblInvHead.Inv_Idno); } } catch (Exception Ex) { value = 0; } return(value); }
public IList SelectForSearch(string strPCompName) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from CT in db.tblPCompanyMasters //join sm in db.tblStateMasters on CT.PComp_Idno equals sm.intPCompIdno select new { PCompIdno = CT.PComp_Idno, PCompName = CT.PComp_Name, Status = CT.Status, //StateName = sm.State_Name }).ToList(); if (strPCompName != "") { lst = (from l in lst where l.PCompName.ToLower().Contains(strPCompName.ToLower()) select l).ToList(); } return(lst); } }
public IList CheckItemGrpExistInGRPrep(Int64 ConSizeIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.TblGrHeads where obj.GRContanr_Size == ConSizeIdno select new { ItemGrp = obj.GRContanr_Size } ).ToList() .Union (from obj1 in db.tblAdvGrOrders where obj1.Contanr_Size == ConSizeIdno select new { ItemGrp = obj1.Contanr_Size }).ToList()); } }
public Int64 Insert(tblRcptGoodHead rcptGoodHead, List <tblRcptGoodDetl> rcptGoodDetl) { Int64 RcptGoodHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblRcptGoodHead RH = db.tblRcptGoodHeads.Where(rh => rh.RcptGoodHead_No == rcptGoodHead.RcptGoodHead_No && rh.FromCity_Idno == rcptGoodHead.FromCity_Idno && rh.Year_Idno == rcptGoodHead.Year_Idno).FirstOrDefault(); if (RH != null) { RcptGoodHeadId = -1; } else { db.tblRcptGoodHeads.AddObject(rcptGoodHead); db.SaveChanges(); RcptGoodHeadId = rcptGoodHead.RcptGoodHead_Idno; if (rcptGoodDetl.Count > 0) { foreach (tblRcptGoodDetl rgd in rcptGoodDetl) { rgd.RcptGoodHead_Idno = RcptGoodHeadId; db.tblRcptGoodDetls.AddObject(rgd); db.SaveChanges(); } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(RcptGoodHeadId); }
public Int64 Insert(tblChlnBookHead ChallanBookHead, List <tblChlnBookDetl> ChallanBookDetl) { Int64 ChallanBookHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == ChallanBookHead.Chln_No).FirstOrDefault(); if (RH != null) { ChallanBookHeadId = -1; } else { db.tblChlnBookHeads.AddObject(ChallanBookHead); db.SaveChanges(); ChallanBookHeadId = ChallanBookHead.Chln_Idno; if (ChallanBookDetl.Count > 0) { foreach (tblChlnBookDetl rgd in ChallanBookDetl) { rgd.ChlnBookHead_Idno = ChallanBookHeadId; db.tblChlnBookDetls.AddObject(rgd); db.SaveChanges(); } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(ChallanBookHeadId); }
public Int64 Insert(tblQuatationHead QtnHead, List <tblQuatationDetl> QtnDetl) { Int64 QtnHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblQuatationHead QH = db.tblQuatationHeads.Where(qh => qh.QuHead_No == QtnHead.QuHead_No && qh.Year_Idno == QtnHead.Year_Idno).FirstOrDefault(); if (QH != null) { QtnHeadId = -1; } else { db.tblQuatationHeads.AddObject(QtnHead); db.SaveChanges(); QtnHeadId = QtnHead.QuHead_Idno; if (QtnDetl.Count > 0) { foreach (tblQuatationDetl qtd in QtnDetl) { qtd.QuHead_Idno = QtnHeadId; db.tblQuatationDetls.AddObject(qtd); db.SaveChanges(); } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(QtnHeadId); }
public Int64 Update(DataTable ChallanBookDetl, Int32 Chlnidno) { Int64 ChallanBookHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { List <tblChlnBookDetl> rcptdetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == Chlnidno).ToList(); //foreach (tblChlnBookDetl rgd in rcptdetl) //{ // db.tblChlnBookDetls.DeleteObject(rgd); // db.SaveChanges(); //} tblChlnBookDetl obj = new tblChlnBookDetl(); foreach (DataRow rgd in ChallanBookDetl.Rows) { if (Convert.ToBoolean(rgd["Delivered"]) == true) { obj.Delivered = Convert.ToBoolean(rgd["Delivered"]); obj.Delvry_Date = Convert.ToDateTime((rgd["Delvry_Date"])); obj.Shrtg = Convert.ToBoolean(rgd["Shrtg"]); obj.remark = Convert.ToString(rgd["remark"]); db.SaveChanges(); } } dbTran.Commit(); } catch { dbTran.Rollback(); } } return(ChallanBookHeadId); } }
public Int64 InsertDocHolderDetails(DataTable dt, Int64 intLorryIdno, Int32 empIdno) { Int64 intValue = 0; Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { if (dt != null && dt.Rows.Count > 0) { tblDocHolder objDocHolderDelete = (from mast in db.tblDocHolders where mast.Lorry_Idno == intLorryIdno select mast).FirstOrDefault(); if (objDocHolderDelete != null) { db.tblDocHolders.DeleteObject(objDocHolderDelete); db.SaveChanges(); } for (int i = 0; i < dt.Rows.Count; i++) { tblDocHolder objDocHolderInsert = new tblDocHolder(); objDocHolderInsert.Doc_Name = dt.Rows[i]["DocName"].ToString(); objDocHolderInsert.Doc_Remark = dt.Rows[i]["Remark"].ToString(); objDocHolderInsert.Doc_Image = dt.Rows[i]["Image"].ToString(); objDocHolderInsert.Emp_Idno = empIdno; objDocHolderInsert.Lorry_Idno = intLorryIdno; objDocHolderInsert.Date_Added = System.DateTime.Now; db.tblDocHolders.AddObject(objDocHolderInsert); db.SaveChanges(); } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }