public Master_User Getdata(string userId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Users where c.UserID == userId select c).FirstOrDefault();
return(model);
}
public MSPLANT Add(MSPLANT model)
{
var dc = new eprocdbDataContext();
MSPLANT md = new MSPLANT();
md.PLANTID = model.PLANTID;
md.NAME = model.NAME;
md.ALAMAT = model.ALAMAT;
md.ALAMAT2 = model.ALAMAT2;
md.ALAMAT3 = model.ALAMAT3;
md.ALAMAT4 = model.ALAMAT4;
md.ALAMAT5 = model.ALAMAT5;
md.KELURAHAN = model.KELURAHAN;
md.KECAMATAN = model.KECAMATAN;
md.CITY = model.CITY;
md.PROPINSI = model.PROPINSI;
md.REGION = model.REGION;
md.NOTELPPLANT = model.NOTELPPLANT;
md.CONTACTPERSONNAME = model.CONTACTPERSONNAME;
md.TITLECP = model.TITLECP;
md.NOHPCP = model.NOHPCP;
md.PIC = model.PIC;
md.POSTALCODE = model.POSTALCODE;
md.CUSTOMERNO = model.CUSTOMERNO;
dc.MSPLANTs.InsertOnSubmit(md);
dc.SubmitChanges();
return(model);
}
public DetailAssignmentPOVendorViewModel GetDetailAssignment(string poNumber)
{
var dc = new eprocdbDataContext();
var model = (from custpo in dc.CUSTOMPOs
from custgr in dc.CUSTOMGRs.Where(mapping => mapping.PONUMBER == custpo.PONUMBER).DefaultIfEmpty() //on custpo.PONUMBER equals custgr.PONUMBER
from custbpkb in dc.CUSTOMBPKBs.Where(mapping => mapping.PONUMBER == custgr.PONUMBER).DefaultIfEmpty() //on custgr.PONUMBER equals custbpkb.PONUMBER
from stream in dc.STREAMLINERs.Where(mapping => mapping.PONUMBER == custpo.PONUMBER).DefaultIfEmpty() //on custpo.PONUMBER equals stream.PONUMBER
where custpo.PONUMBER == poNumber
select new DetailAssignmentPOVendorViewModel
{
PONumber = custpo.PONUMBER,
PODate = custpo.TGLPO,
PODescription = custpo.DESCPO,
PlantCabang = custpo.CABANGTRAC,
OnTheRoadPrice = custpo.ONTHEROADPRICE,
Discount = custpo.DISC,
NetPrice = (custpo.ONTHEROADPRICE + custpo.DISC),
Color = custpo.COLOR,
PromiseDeliveryDate = custpo.PROMISEDLVDATEPO.Value.Date,
OfficerName = stream.OfficerName,
PurchaseStatus = custpo.PURCHASESTATUS,
UnitDeliveryAddress = custpo.UNITDELIVERYADDRESS,
ProsesKeVendorKaroseri = stream.PRKaroseri,
ProsesKeVendorAksesoris = stream.PRAccessories,
POStatus = custpo.POSTATUSID,
BBN = stream.BBN,
TujuanDeliveryUnit = custgr.STATUSDELIVERYUNIT
}).SingleOrDefault();
return(model);
}
public CUSTOMBPKB UpdateBpkbCustBPKB(string poNumber, CUSTOMBPKB model)
{
var dc = new eprocdbDataContext();
var md = (from c in dc.CUSTOMBPKBs
where c.PONUMBER == poNumber.Trim()
select c).SingleOrDefault();
md.ACTUALRECEIVEDBPKBDIHO = model.ACTUALRECEIVEDBPKBDIHO;
md.ACTUALRECEIVEDBPKBDICAB = model.ACTUALRECEIVEDBPKBDICAB;
md.DETAILPROBLEM = model.DETAILPROBLEM;
md.REASONREVISEBPKB = model.REASONREVISEBPKB;
md.TGLSERAHBPKB = model.TGLSERAHBPKB;
md.ACTUALDELIVERYBPKBTOFINANCE = model.ACTUALDELIVERYBPKBTOFINANCE;
md.ACTUALRECEIVEDBPKBHOBACK = model.ACTUALRECEIVEDBPKBHOBACK;
md.DATEDELIVERYTOBRANCHORVENDOR = model.DATEDELIVERYTOBRANCHORVENDOR;
md.NOBPKB = model.NOBPKB;
md.NOFAKTUR = model.NOFAKTUR;
md.NOSERTIFIKAT = model.NOSERTIFIKAT;
md.NOFORMULIRA = model.NOFORMULIRA;
md.KETSURATUBAHBENTUK = model.KETSURATUBAHBENTUK;
md.NOSURATUBAHBENTUK = model.NOSURATUBAHBENTUK;
md.TGLSURATUBAHBENTUK = model.TGLSURATUBAHBENTUK;
md.KETERANGANSURATRUBAHWARNA = model.KETERANGANSURATRUBAHWARNA;
md.NOSURATRUBAHWARNA = model.NOSURATRUBAHWARNA;
md.TANGGALSURATRUBAHWARNA = model.TANGGALSURATRUBAHWARNA;
md.NOSERTIFIKATREGUJITIPE = model.NOSERTIFIKATREGUJITIPE;
md.REMARKSDETAILPROBLEM = model.REMARKSDETAILPROBLEM;
md.KETBPKB = model.KETBPKB;
md.MODIFIED_BY = model.MODIFIED_BY;
md.MODIFIED_DATE = model.MODIFIED_DATE;
dc.SubmitChanges();
UpdateStatus(poNumber);
return(model);
}
public MSPLANT Getdata(string plantId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.MSPLANTs where c.PLANTID == plantId select c).SingleOrDefault();
return(model);
}
public Master_Menu Getdata(string menuId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Menus where c.MenuID == menuId select c).SingleOrDefault();
return(model);
}
public CUSTOMCITY Getdata(string cityId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.CUSTOMCITies where c.CITYID == cityId select c).SingleOrDefault();
return(model);
}
public List <Company_Code> GetAll()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Company_Codes select c).ToList();
return(model);
}
public CUSTOMCOMPANY Getdata(string companyId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.CUSTOMCOMPANies where c.COMPANYCODE == companyId select c).SingleOrDefault();
return(model);
}
public List <Master_Group> GetAll()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Groups select c).ToList();
return(model);
}
public Company_Code Getdata(string companyCode)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Company_Codes where c.companyCode == companyCode select c).SingleOrDefault();
return(model);
}
public IEnumerable <Master_Menu> GetAllMenu()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Menus select c).ToList();
return(model);
}
public Master_Group Getdata(string groupId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Groups where c.GroupID == groupId select c).SingleOrDefault();
return(model);
}
public DashboardViewModel GetDashboard()
{
var dc = new eprocdbDataContext();
var model = new DashboardViewModel();
if (System.Web.HttpContext.Current.Session["GroupID"].ToString() == "PROCUREMENT")
{
model.JmlPO = (from p in dc.CUSTOMPOs where p.TGLPO.Value.Year == DateTime.Today.Year select p.PONUMBER).Count();
model.JmlPR = (from p in dc.CUSTOMPRs join q in dc.CUSTOMPOs on p.PRSAP equals q.PRNUMBERSAP where q.TGLPO.Value.Year == DateTime.Today.Year select p).Count();
model.JmlGR = (from p in dc.CUSTOMGRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && p.TGLGRSAP != null select p).Count();
model.JmlNonGR = (from p in dc.CUSTOMGRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && p.TGLGRSAP == null select p).Count();
model.JmlPOClearing = (from p in dc.CUSTOMIRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && p.TGLPEMBAYARAN != null select p).Count();
model.JmlPONotClearing = (from p in dc.CUSTOMIRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && p.TGLPEMBAYARAN == null select p).Count();
model.JmlBPKB = (from p in dc.CUSTOMBPKBs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && p.TGLGRBPKB != null select p).Count();
model.JmlBPKBOutstanding = (from p in dc.CUSTOMBPKBs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.POSTATUSID != "10" && q.POSTATUSID != "12" select p).Count();
}
else if (System.Web.HttpContext.Current.Session["GroupID"].ToString() == "VENDOR")
{
string vendorId = System.Web.HttpContext.Current.Session["VendorID"].ToString();
model.JmlPO = (from p in dc.CUSTOMPOs where p.TGLPO.Value.Year == DateTime.Today.Year && p.VENDORID == vendorId select p.PONUMBER).Count();
model.JmlPR = (from p in dc.CUSTOMPRs join q in dc.CUSTOMPOs on p.PRSAP equals q.PRNUMBERSAP where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId select p).Count();
model.JmlGR = (from p in dc.CUSTOMGRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && p.TGLGRSAP != null select p).Count();
model.JmlNonGR = (from p in dc.CUSTOMGRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && p.TGLGRSAP == null select p).Count();
model.JmlPOClearing = (from p in dc.CUSTOMIRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && p.TGLPEMBAYARAN != null select p).Count();
model.JmlPONotClearing = (from p in dc.CUSTOMIRs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && p.TGLPEMBAYARAN == null select p).Count();
model.JmlBPKB = (from p in dc.CUSTOMBPKBs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && p.TGLGRBPKB != null select p).Count();
model.JmlBPKBOutstanding = (from p in dc.CUSTOMBPKBs join q in dc.CUSTOMPOs on p.PONUMBER equals q.PONUMBER where q.TGLPO.Value.Year == DateTime.Today.Year && q.VENDORID == vendorId && q.POSTATUSID != "10" && q.POSTATUSID != "12" select p).Count();
}
return(model);
}
public List <MSMATERIAL> GetAll()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.MSMATERIALs select c).ToList();//.OrderBy(p => p.MATERIALNUMBER).Take(500).ToList();
return(model);
}
public MSVENDOR UpdateVendor(string id, MSVENDOR model)
{
var dc = new eprocdbDataContext();
var md = (from c in dc.MSVENDORs
where c.VENDORID == id
select c).SingleOrDefault();
md.VENDORID = model.VENDORID;
//md.VENDORNAME = model.VENDORNAME;
//md.STREET = model.STREET;
//md.DISTRIC = model.DISTRIC;
//md.CITY = model.CITY;
//md.POSTALCODE = model.POSTALCODE;
//md.TELEPHONE = model.TELEPHONE;
//md.EMAIL = model.EMAIL;
//md.EMAIL2 = model.EMAIL2;
//md.EMAIL3 = model.EMAIL3;
//md.EMAIL4 = model.EMAIL4;
//md.EMAIL5 = model.EMAIL5;
//md.EMAIL6 = model.EMAIL6;
//md.EMAIL7 = model.EMAIL7;
//md.EMAIL8 = model.EMAIL8;
//md.PLANTIDTSO = model.PLANTIDTSO;
md.B2B = model.B2B;
dc.SubmitChanges();
return(model);
}
public DetailAssignmentPOProcViewModel GetDetailAssignment(string poNumber)
{
var dc = new eprocdbDataContext();
var model = (from custpo in dc.CUSTOMPOs
from stream in dc.STREAMLINERs.Where(mapping1 => mapping1.PONUMBER == custpo.PONUMBER).DefaultIfEmpty() // on custpo.PONUMBER equals stream.PONUMBER
from custgr in dc.CUSTOMGRs.Where(mapping1 => mapping1.PONUMBER == custpo.PONUMBER).DefaultIfEmpty() //on custpo.PONUMBER equals custgr.PONUMBER
where custpo.PONUMBER == poNumber
select new DetailAssignmentPOProcViewModel
{
TujuanDeliveryUnit = custgr.STATUSDELIVERYUNIT,
PONumber = custpo.PONUMBER,
PODate = custpo.TGLPO,
PODescription = custpo.DESCPO,
OnTheRoadPrice = custpo.ONTHEROADPRICE,
Discount = custpo.DISC,
NetPrice = (custpo.ONTHEROADPRICE + custpo.DISC),
ExpectedDateDelivered = custpo.EXPECTEDDATEDELIVERED,
PromiseDeliveryDate = custpo.PROMISEDLVDATEPO,
OfficerName = stream.OfficerName,
PRKaroseri = stream.PRKaroseri,
Accessories = stream.PRAccessories,
AssignVendorTo = custpo.VENDORNAME,
Color = custpo.COLOR,
BBN = stream.BBN
}).SingleOrDefault();
return(model);
}
public MSMATERIAL UpdateMaterial(string id, MSMATERIAL model)
{
var dc = new eprocdbDataContext();
var md = (from c in dc.MSMATERIALs
where c.MATERIALNUMBER == id
select c).SingleOrDefault();
//md.MATERIALNUMBER = model.MATERIALNUMBER;
//md.DESCRIPTION = model.DESCRIPTION;
//md.MATERIALTYPE = model.MATERIALTYPE;
//md.MATERIALGROUP = model.MATERIALGROUP;
//md.OLDMATERIAL = model.OLDMATERIAL;
//md.BOMMATERIAL = model.BOMMATERIAL;
//md.BRAND = model.BRAND;
//md.MODEL = model.MODEL;
//md.GARDAN = model.GARDAN;
//md.YEAR = model.YEAR;
//md.PURCHASEGROUPID = model.PURCHASEGROUPID;
md.MATERIALIDVENDOR = model.MATERIALIDVENDOR;
//md.PRICELIST = model.PRICELIST;
dc.SubmitChanges();
return(model);
}
public List <Master_Menu> GetAll()
{
var dc = new eprocdbDataContext();
var model = dc.Master_Menus.Where(a => a.ParentID == null).OrderByDescending(a => a.MenuID).ToList();
return(model);
}
public List <MSVENDOR> GetAll()
{
var dc = new eprocdbDataContext();
var model = dc.MSVENDORs.Where(a => a.VENDORID.StartsWith("13") || a.VENDORID.StartsWith("31") || a.VENDORID.StartsWith("33")).OrderByDescending(a => a.VENDORID).ToList();
return(model);
}
public List <CUSTOMCITY> GetAll()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.CUSTOMCITies select c).ToList();
return(model);
}
public VendorViewModel Add(VendorViewModel model)
{
var dc = new eprocdbDataContext();
var md = new MSVENDOR();
md.VENDORNAME = model.VENDORNAME;
md.STREET = model.STREET;
md.DISTRIC = model.DISTRIC;
md.CITY = model.CITY;
md.TELEPHONE = model.TELEPHONE;
md.POSTALCODE = model.POSTALCODE;
md.EMAIL = model.EMAIL;
md.EMAIL2 = model.EMAIL2;
md.EMAIL3 = model.EMAIL3;
md.EMAIL4 = model.EMAIL4;
md.EMAIL5 = model.EMAIL5;
md.EMAIL6 = model.EMAIL6;
md.EMAIL7 = model.EMAIL7;
md.EMAIL8 = model.EMAIL8;
md.PLANTIDTSO = model.PLANTIDTSO;
md.B2B = model.B2Bs == true ? '1' : '0';
dc.MSVENDORs.InsertOnSubmit(md);
dc.SubmitChanges();
return(model);
}
public CUSTOMPO UpdateDeliveryCustPO(string poNumber, CUSTOMPO model)
{
var dc = new eprocdbDataContext();
var md = (from c in dc.CUSTOMPOs
where c.PONUMBER == poNumber.Trim()
select c).SingleOrDefault();
if (md != null)
{
md.HARGADPP_INPUT = model.HARGADPP_INPUT;
md.HARGAPPNUNIT_INPUT = model.HARGAPPNUNIT_INPUT;
md.HARGABBN_INPUT = model.HARGABBN_INPUT;
md.DODATE = model.DODATE;
md.DONUMBER = model.DONUMBER;
md.CARROSERIEVENDORNAME = model.CARROSERIEVENDORNAME;
md.ACCESORIESADDRESS = model.ACCESORIESADDRESS;
md.REMARKSCARROSSERIE = model.REMARKSCARROSSERIE;
md.TGLMASUKKAROSERI = model.TGLMASUKKAROSERI;
md.TGLSELESAIKAROSERI = model.TGLSELESAIKAROSERI;
md.REMARKS = model.REMARKS;
md.MODIFIED_BY = model.MODIFIED_BY;
md.MODIFIED_DATE = model.MODIFIED_DATE;
dc.SubmitChanges();
UpdateStatus(poNumber);
}
return(model);
}
public VendorViewModel Getdata(string vendorId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.MSVENDORs where c.VENDORID == vendorId select c).SingleOrDefault();
var md = new VendorViewModel();
md.VENDORNAME = model.VENDORNAME;
md.STREET = model.STREET;
md.DISTRIC = model.DISTRIC;
md.CITY = model.CITY;
md.TELEPHONE = model.TELEPHONE;
md.POSTALCODE = model.POSTALCODE;
md.EMAIL = model.EMAIL;
md.EMAIL2 = model.EMAIL2;
md.EMAIL3 = model.EMAIL3;
md.EMAIL4 = model.EMAIL4;
md.EMAIL5 = model.EMAIL5;
md.EMAIL6 = model.EMAIL6;
md.EMAIL7 = model.EMAIL7;
md.EMAIL8 = model.EMAIL8;
md.PLANTIDTSO = model.PLANTIDTSO;
md.B2B = model.B2B;
md.B2Bs = model.B2B == '1' ? true : false;
return(md);
}
public MSPLANT Edit(string plantId, MSPLANT model)
{
var dc = new eprocdbDataContext();
var md = (from c in dc.MSPLANTs where c.PLANTID == plantId select c).SingleOrDefault();
md.NAME = model.NAME;
md.ALAMAT = model.ALAMAT;
md.ALAMAT2 = model.ALAMAT2;
md.ALAMAT3 = model.ALAMAT3;
md.ALAMAT4 = model.ALAMAT4;
md.ALAMAT5 = model.ALAMAT5;
md.KELURAHAN = model.KELURAHAN;
md.KECAMATAN = model.KECAMATAN;
md.CITY = model.CITY;
md.PROPINSI = model.PROPINSI;
md.REGION = model.REGION;
md.NOTELPPLANT = model.NOTELPPLANT;
md.CONTACTPERSONNAME = model.CONTACTPERSONNAME;
if (model.TITLECP == null)
{
md.TITLECP = md.TITLECP;
}
else
{
md.TITLECP = model.TITLECP;
}
md.NOHPCP = model.NOHPCP;
md.PIC = model.PIC;
md.POSTALCODE = model.POSTALCODE;
md.CUSTOMERNO = model.CUSTOMERNO;
dc.SubmitChanges();
return(model);
}
public CUSTOMREGION Getdata(string regionId)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.CUSTOMREGIONs where c.REGIONID == regionId select c).SingleOrDefault();
return(model);
}
public List <MSPLANT> GetAll()
{
var dc = new eprocdbDataContext();
var model = dc.MSPLANTs.OrderByDescending(a => a.PLANTID).ToList();
return(model);
}
public MSMATERIAL Getdata(string materialNumber)
{
var dc = new eprocdbDataContext();
var model = (from c in dc.MSMATERIALs where c.MATERIALNUMBER == materialNumber select c).SingleOrDefault();
return(model);
}
public List <ListPOVendorViewModel> GetAll(string VendorId)
{
var dc = new eprocdbDataContext();
// from custgr in dc.CUSTOMGRs.Where(mapping => mapping.PONUMBER == custpo.PONUMBER).DefaultIfEmpty()
var model = (from a in dc.CUSTOMPOs
join d in dc.CUSTOMGRs on a.PONUMBER equals d.PONUMBER
join e in dc.CUSTOMSTATUS on a.POSTATUSID equals e.ID
join b in dc.STREAMLINERs on a.PONUMBER equals b.PONUMBER //from b in dc.STREAMLINERs.Where(mapping => mapping.PONUMBER == a.PONUMBER).DefaultIfEmpty() //on a.PONUMBER equals b.PONUMBER//join b in dc.STREAMLINERs on a.PONUMBER equals b.PONUMBER
join custMISC in dc.CUSTOMMISCs on a.PONUMBER equals custMISC.PONumber
join custBPKB in dc.CUSTOMBPKBs on a.PONUMBER equals custBPKB.PONUMBER
//where a.VENDORID == VendorId
//from d in dc.CUSTOMGRs.Where(mapping => mapping.PONUMBER == a.PONUMBER).DefaultIfEmpty() //on a.PONUMBER equals d.PONUMBER
//from e in dc.CUSTOMSTATUS.Where(mapping => mapping.ID == a.POSTATUSID).DefaultIfEmpty() //on a.POSTATUSID equals e.ID
//from b in dc.STREAMLINERs.Where(mapping => mapping.PONUMBER == a.PONUMBER).DefaultIfEmpty() //on a.PONUMBER equals b.PONUMBER
//from custMISC in dc.CUSTOMMISCs.Where(mapping => mapping.PONumber == a.PONUMBER).DefaultIfEmpty() //on a.PONUMBER equals custMISC.PONumber
//from custBPKB in dc.CUSTOMBPKBs.Where(mapping => mapping.PONUMBER == a.PONUMBER).DefaultIfEmpty() //on a.PONUMBER equals custBPKB.PONUMBER
//where a.VENDORID == VendorId
select new ListPOVendorViewModel
{
VendorID = a.VENDORID,
PONumber = a.PONUMBER,
PODate = a.TGLPO,
StatusId = a.POSTATUSID,
StatusPO = b.POStatus == "Rejected" ? "Rejected" : e.STATUS, //c.POStatus == "Rejected" ? "Rejected" : d.STATUS,
ChasisNumber = d.NOCHASIS,
OfficerName = b.OfficerName
}).Distinct().ToList();
if (VendorId != "")
{
model = (from a in model where a.VendorID == VendorId && a.StatusPO != "PO Cancel" orderby a.PODate ascending select a).ToList();
model = (from a in model
select new ListPOVendorViewModel {
StrPoDate = a.PODate.Value.ToString("dd/MM/yyyy"),
VendorID = a.VendorID,
PONumber = a.PONumber,
StatusId = a.StatusId,
StatusPO = a.StatusPO,
ChasisNumber = a.ChasisNumber,
OfficerName = a.OfficerName
}).Distinct().ToList();
}
else
{
model = (from a in model where a.StatusPO != "PO Cancel" orderby a.PODate ascending select a).ToList();
model = (from a in model
select new ListPOVendorViewModel
{
StrPoDate = a.PODate.Value.ToString("dd/MM/yyyy"),
VendorID = a.VendorID,
PONumber = a.PONumber,
StatusId = a.StatusId,
StatusPO = a.StatusPO,
ChasisNumber = a.ChasisNumber,
OfficerName = a.OfficerName
}).Distinct().ToList();
}
return(model);
}
public List <Master_User> GetAll()
{
var dc = new eprocdbDataContext();
var model = (from c in dc.Master_Users where c.UserID != "Superadmin" select c).ToList();
return(model);
}
