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