public DalExpBillOfLading() { _context = new BLC_DEVEntities(); _msg = new ValidationMsg(); _unit = new UnitOfWork(); _mode = new int(); }
public DalLcmBillOfLading() { _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _validationMsg = new ValidationMsg(); _save = 0; }
public List <PrqSupplierBillItem> GetItemListForChallan(string challanID) { using (var Context = new BLC_DEVEntities()) { var ItemList = (from c in Context.Prq_PurchaseChallanItem.AsEnumerable() where (c.ChallanID).ToString(CultureInfo.InvariantCulture) == challanID //select new PrqPurchaseChallanItem select new PrqSupplierBillItem { //ChallanItemID = c.ChallanItemID, //ChallanID = c.ChallanID, ItemTypeID = c.ItemTypeID, ItemTypeName = _context.Sys_ItemType.Where(m => m.ItemTypeID == c.ItemTypeID).FirstOrDefault().ItemTypeName, ItemSizeID = c.ItemSizeID, ItemSizeName = _context.Sys_Size.Where(m => m.SizeID == c.ItemSizeID).FirstOrDefault().SizeName, AreaUnit = c.UnitID, AreaUnitName = _context.Sys_Unit.Where(m => m.UnitID == c.UnitID).FirstOrDefault().UnitName, //Description = c.Description, ItemQty = c.ChallanQty //, //ReceiveQty = c.ReceiveQty, //Remark = c.Remark }); return(ItemList.ToList()); } }
public FinishedLeatherIssueFromStoreController() { _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _validationMsg = new ValidationMsg(); _dalInvFinishedLeatherIssueFromStore = new DalInvFinishedLeatherIssueFromStore(); }
public DalInvCrustedLeatherIssueFromStore() { _vmMsg = new ValidationMsg(); _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _connString = StrConnection.GetConnectionString(); }
public DalPrqChemLocalPurcBillEnt() { _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); _mode = 0; _context = new BLC_DEVEntities(); }
public static string GetPreDefineNextCodeByUrl(string pageUrl) { try { if (string.IsNullOrEmpty(pageUrl)) { return(null); } string scode; string pdvGroupId; using (var context = new BLC_DEVEntities()) { scode = context.Screens.FirstOrDefault(s => s.URL.Trim() == pageUrl).ScreenCode.ToString(); var pdvId = context.Sys_PreDefineValueFor.FirstOrDefault(s => s.ConcernPageID == scode) .PreDefineValueForID.ToString(); var tempPdvId = int.Parse(pdvId); pdvGroupId = context.Sys_PreDefineValue.FirstOrDefault(s => s.PreDefineValueForID == tempPdvId) .PreDefineValueGroup.ToString(); } return(GetPreDefineValue(pdvGroupId, scode)); } catch { return(null); } }
public DalExpTransportChallan() { _context = new BLC_DEVEntities(); _msg = new ValidationMsg(); _unit = new UnitOfWork(); _mode = new int(); }
public DalCommercialInvoice() { _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); save = 0; _context = new BLC_DEVEntities(); }
public DalPrqSupplierBill() { _context = new BLC_DEVEntities(); _vmMsg = new ValidationMsg(); _unit = new UnitOfWork(); _mode = 0; }
public string ReturnRequisitionNo(long _RequisitionDateID) { using (var context = new BLC_DEVEntities()) { return(context.PRD_YearMonthFinishReqDate.Where(x => x.RequisitionDateID == _RequisitionDateID).Select(x => x.RequisitionNo).FirstOrDefault()); } }
public string ReturnScheduleNo(long _ScheduleID) { using (var context = new BLC_DEVEntities()) { return(context.PRD_YearMonthSchedule.Where(x => x.ScheduleID == _ScheduleID).Select(x => x.ScheduleNo).FirstOrDefault()); } }
public DalExportForm() { _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _validationMsg = new ValidationMsg(); _save = 0; }
public int getIssueToProductionRecordCount(string _TransactionType) { using (BLC_DEVEntities context = new BLC_DEVEntities()) { return(context.INV_StoreTrans.Where(t => t.TransactionCategory == "ISU" & t.TransactionType == _TransactionType).Count()); } }
public DalExpFreightBillDoc() { _context = new BLC_DEVEntities(); _msg = new ValidationMsg(); _unit = new UnitOfWork(); _mode = new int(); }
public List <SysArticleChallanColor> GetArticleColorListAfterSave(long ArticleChallanID) { using (var context = new BLC_DEVEntities()) { var Data = (from d in context.Sys_ArticleChallanColor.AsEnumerable() where d.ArticleChallanID == ArticleChallanID join c in _context.Sys_Color on d.ArticleColor equals c.ColorID into Colors from c in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on d.ColorAreaUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() orderby d.ArticleColorNo ascending select new SysArticleChallanColor { ArticleChallanIDColor = d.ArticleChallanIDColor, ArticleColorNo = d.ArticleColorNo, ArticleColor = d.ArticleColor, ArticleColorName = (c == null ? null : c.ColorName), ColorAreaUnit = d.ColorAreaUnit, ColorAreaUnitName = (u == null ? "SFT" : u.UnitName), ArticleColorArea = d.ArticleColorArea, RemarkDate = d.RemarkDate == null ? null : Convert.ToDateTime(d.RemarkDate).ToString("dd'/'MM'/'yyyy"), Remarks = d.Remarks, QuantityDescription = d.QuantityDescription, }).ToList(); return(Data); } }
public DalSlsBuyerOrder() { _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); _mode = 0; _context = new BLC_DEVEntities(); }
public DalLcmPackingList() { _context = new BLC_DEVEntities(); _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); save = false; }
public List <SysArticleChallanDetail> GetArticleDetailListAfterSave(long ArticleChallanID) { using (var context = new BLC_DEVEntities()) { var Data = (from d in context.Sys_ArticleChallanDetail.AsEnumerable() where d.ArticleChallanID == ArticleChallanID join u in _context.Sys_Unit on d.SizeRangeUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() join tu in _context.Sys_Unit on d.ThicknessUnit equals tu.UnitID into ThicknessUnits from tu in ThicknessUnits.DefaultIfEmpty() select new SysArticleChallanDetail { ArticleChallanDtlID = d.ArticleChallanDtlID, SizeRange = d.SizeRange, PcsSideDescription = d.PcsSideDescription, GradeRange = d.GradeRange, ThicknessRange = d.ThicknessRange, ThicknessAt = (d.ThicknessAt == "AFFN" ? "After Finishing" : "After Shaving"), SizeRangeUnit = d.SizeRangeUnit, SizeRangeUnitName = (u == null ? "SFT" : u.UnitName), RequiredPercentage = d.RequiredPercentage, ThicknessUnit = d.ThicknessUnit, ThicknessUnitName = (tu == null?"SFT":tu.UnitName), Remarks = d.Remarks }).ToList(); return(Data); } }
public TransportChallanController() { _userId = 0; _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _validationMsg = new ValidationMsg(); _dalExpTransportChallan = new DalExpTransportChallan(); }
public ChemLocalPurcBillEntController() { _chemLocalPurcBillEnt = new DalPrqChemLocalPurcBillEnt(); _objCurrency = new DalSysCurrency(); _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); _context = new BLC_DEVEntities(); }
public BuyerPurcOrderController() { _unit = new UnitOfWork(); _context = new BLC_DEVEntities(); _objCurrency = new DalSysCurrency(); _validationMsg = new ValidationMsg(); _dalSlsBuyerOrder = new DalSlsBuyerOrder(); }
// After Save & Update to get fresh data into page grid public List <PRDChemProdReqItem> GetRequisitionItemList(int _RequisitionID, byte _StoreID) { using (var context = new BLC_DEVEntities()) { var FinalStock = DalChemicalStock.ItemWiseStockInSpecificChemicalStore(_StoreID); var Data = (from r in context.PRD_ChemProdReqItem.AsEnumerable() where r.RequisitionID == _RequisitionID from i in context.Sys_ChemicalItem.Where(x => x.ItemID == r.ItemID).DefaultIfEmpty() from u in context.Sys_Unit.Where(x => x.UnitID == r.RequiredUnit).DefaultIfEmpty() from su in context.Sys_Unit.Where(x => x.UnitID == r.SizeUnit).DefaultIfEmpty() from rq in context.Sys_Unit.Where(x => x.UnitID == r.RequisitionUnit).DefaultIfEmpty() from ap in context.Sys_Unit.Where(x => x.UnitID == r.ApproveUnit).DefaultIfEmpty() from size in context.Sys_Size.Where(x => x.SizeID == r.PackSize).DefaultIfEmpty() join s in FinalStock on i.ItemID equals s.ItemID into StockInfo from item in StockInfo.DefaultIfEmpty() join sup in context.Sys_Supplier on(item == null ? 0 : item.SupplierID) equals sup.SupplierID into badhon2 from finalitem in badhon2.DefaultIfEmpty() select new PRDChemProdReqItem { RequisitionItemID = r.RequisitionItemID, ItemID = r.ItemID, ItemName = (i == null ? null : i.ItemName), RequiredQty = Convert.ToDecimal(r.RequiredQty), RequiredUnit = Convert.ToByte(r.RequiredUnit), RequiredUnitName = (u == null ? null : u.UnitName), PackSize = Convert.ToByte(r.PackSize), PackSizeName = (size == null ? null : size.SizeName), SizeUnit = Convert.ToByte(r.SizeUnit), SizeUnitName = (su == null ? null : su.UnitName), PackQty = Convert.ToInt32(r.PackQty), RequsitionQty = r.RequsitionQty, RequisitionUnit = r.RequisitionUnit, RequisitionUnitName = (rq == null ? null : rq.UnitName), ApproveQty = Convert.ToDecimal(r.ApproveQty), ApproveUnit = Convert.ToByte(r.ApproveUnit), ApproveUnitName = (ap == null ? null : ap.UnitName), StockQty = (item == null ? 0 : (item.ClosingQty)), //StockUnitName = (su == null ? null : su.UnitName), SupplierID = (finalitem == null ? 0 : finalitem.SupplierID), SupplierName = (finalitem == null ? null : finalitem.SupplierName) }).ToList(); return(Data); } }
public static byte GetSizeCode(string SizeName) { using (var context = new BLC_DEVEntities()) { var SizeID = (from s in context.Sys_Size.AsEnumerable() where s.SizeName == SizeName select s.SizeID).FirstOrDefault(); return(SizeID); } }
public static byte GetCurrencyID(string _CurrencyName) { using (var context = new BLC_DEVEntities()) { var CurrencyID = (from c in context.Sys_Currency where c.CurrencyName == _CurrencyName select c.CurrencyID).FirstOrDefault(); return(CurrencyID); } }
public static string GetItemTypeName(byte ItemTypeID) { using (var context = new BLC_DEVEntities()) { var ItemTypeName = (from s in context.Sys_ItemType.AsEnumerable() where s.ItemTypeID == ItemTypeID select s.ItemTypeName).FirstOrDefault(); return(ItemTypeName); } }
public static string GetStoreName(byte StoreID) { using (var context = new BLC_DEVEntities()) { var StoreName = (from s in context.SYS_Store.AsEnumerable() where s.StoreID == StoreID select s.StoreName).FirstOrDefault(); return(StoreName); } }
public byte GetRequisitionToInfo(long _RequisitionID) { using (var context = new BLC_DEVEntities()) { var RequisitionTo = (from p in context.PRD_ChemProdReq.AsEnumerable() where p.RequisitionID == _RequisitionID select p.RequisitionTo).FirstOrDefault(); return(RequisitionTo); } }
public static byte GetLeatherStatusCode(string LeatherType) { using (var context = new BLC_DEVEntities()) { var LeatherTypeID = (from l in context.Sys_LeatherStatus.AsEnumerable() where l.LeatherStatusName == LeatherType select l.LeatherStatusID).FirstOrDefault(); return(LeatherTypeID); } }
public static string GetUnitName(byte UnitID) { using (var context = new BLC_DEVEntities()) { var UnitName = (from s in context.Sys_Unit.AsEnumerable() where s.UnitID == UnitID select s.UnitName).FirstOrDefault(); return(UnitName); } }