public static InvoiceViewModel CreateInvoice(int client, int division, string period, DateTime startdate, DateTime enddate)
{
InvoiceViewModel obj = new InvoiceViewModel();
using (var db = new EF.CMCSQL03Entities())
{
obj.invoiceid = -1;
obj.invoicedate = DateTime.UtcNow;
obj.status = "New";
if (division > 0)
{
var div = db.tblDivision.Find(division);
obj.billinggroup = div.Division;
}
else {
obj.billinggroup = "All";
}
// Pull default values from Client table
var cl = db.tblClient.Find(client);
obj.clientid = cl.ClientID;
obj.clientname = cl.ClientName;
obj.warehouselocation = cl.CMCLocation;
obj.billto = cl.InvoiceAddress;
obj.netterm = String.IsNullOrEmpty(cl.ClientNetTerm) ? "Net 30 Days" : cl.ClientNetTerm;
obj.currency = cl.ClientCurrency;
obj.ponumber = "Enter PO Number";
obj.tier = 1;
obj.invoiceperiod = period;
obj.invoicestartdate = startdate;
obj.invoiceenddate = enddate;
obj.remitto = "<p>Chemical Marketing Concepts, LLC<br />c/o Odyssey Logistics & Technology Corp<br />39 Old Ridgebury Road, N-1<br />Danbury, CT 06810</p>";
// Pull default values from Rates table
var rate = (from t in db.tblRates
where t.ClientID == 1
select t).FirstOrDefault();
obj.revenuerate = rate.RevenueRate;
obj.nonrevenuerate = rate.NonRevenueRate;
obj.manualentryrate = rate.ManualEntryRate;
obj.followuprate = rate.FollowUpRate;
obj.labelprtrate = rate.LabelPrtRate;
obj.relabelprtrate = rate.ReLabelPrtRate;
obj.relabelfeerate = rate.ReLabelFeeRate;
obj.productsetuprate = rate.ProductSetupRate;
obj.ccprocessrate = rate.CCProcessRate;
obj.rushshiprate = rate.RushShipRate;
obj.emptypailsrate = rate.EmptyPailsRate;
obj.inactivestockrate = rate.InactiveStockRate;
obj.minimalsamplecharge = rate.MinimalSampleCharge;
UpdateTierPricing(obj, startdate, enddate); // go update tier pricing
obj = GetOrderTransCharges(obj, startdate, enddate); // now go read tblOrderTrans fill in some properties for the system generated trans
return obj;
}
}
/// <summary>
/// Generates temporary model values in clone modal
/// </summary>
public ActionResult Clone(int id)
{
GHSPHSource PHSrc = new GHSPHSource();
string[] Suffix = new string[] {"A","B","C","D","E","F","G","H","I","J"};
using (var db = new EF.CMCSQL03Entities())
{
var phsrc = (from t in db.tblGHSPHSource
where t.PHsourceID == id
select t).FirstOrDefault();
int i = 0;
PHSrc.PHNumber = phsrc.PHNumber + "-" + Suffix[i];
var isExists = db.tblGHSPHSource.Any(r => r.PHNumber.Equals(PHSrc.PHNumber));
while (isExists)
{
++i;
PHSrc.PHNumber = phsrc.PHNumber + "-" + Suffix[i];
isExists = db.tblGHSPHSource.Any(r => r.PHNumber.Equals(PHSrc.PHNumber));
}
PHSrc.PHSourceID = phsrc.PHsourceID;
PHSrc.Language = phsrc.Language;
PHSrc.PHStatement = phsrc.PHStatement;
}
return PartialView("CloneEdit", PHSrc);
}
public static void fnDeleteShelfMaster(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
db.Database.ExecuteSqlCommand("Delete from tblShelfMaster where ShelfID=" + id.ToString());
}
}
public static int ExecuteADOSQL(string sql)
{
using (var db = new EF.CMCSQL03Entities())
{
db.Database.ExecuteSqlCommand(sql);
return 1;
}
}
public static int fnDeleteProductNote(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
db.Database.ExecuteSqlCommand("Delete from tblInvPMLogNote Where InvPMLogNoteIDID=" + id);
}
return id;
}
public ActionResult DeletePHDetail(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
string s = @"Delete from tblGHSPHDetail where PHDetailID=" + id.ToString();
db.Database.ExecuteSqlCommand(s);
}
return null;
}
public ActionResult Search(string sortOrder, string currentFilter, string searchString, int? page)
{
using (var db = new EF.CMCSQL03Entities())
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.LocationSortParm = sortOrder == "location" ? "location_desc" : "location";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var clients = from c in db.tblInvoice
select c;
if (!String.IsNullOrEmpty(searchString))
{
clients = clients.Where(c => c.ClientName.Contains(searchString)
|| c.BillingGroup.Contains(searchString)
|| c.WarehouseLocation.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
clients = clients.OrderByDescending(c => c.ClientName);
break;
case "location":
clients = clients.OrderBy(c => c.WarehouseLocation);
break;
case "location_desc":
clients = clients.OrderByDescending(c => c.WarehouseLocation);
break;
default:
clients = clients.OrderBy(c => c.ClientName);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return View(clients.ToPagedList(pageNumber, pageSize));
}
}
public static int fnCloneShelfMaster(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
// copy a record, return the productdetailid
var dbrow = db.tblShelfMaster.Find(id);
int pdid = Convert.ToInt32(dbrow.ProductDetailID);
string s = String.Format("Insert into tblShelfMaster (ProductDetailID,Warehouse,Size,Bin,ReorderMin,ReorderMax,ReorderQty,Notes,HazardSurcharge,FlammableSurcharge,HeatSurcharge,RefrigSurcharge,FreezerSurcharge,CleanSurcharge,BlendSurcharge,NalgeneSurcharge,NitrogenSurcharge,BiocideSurcharge,KosherSurcharge,LabelSurcharge,OtherSurcharge) Select ProductDetailID,Warehouse,Size,Bin,ReorderMin,ReorderMax,ReorderQty,Notes,HazardSurcharge,FlammableSurcharge,HeatSurcharge,RefrigSurcharge,FreezerSurcharge,CleanSurcharge,BlendSurcharge,NalgeneSurcharge,NitrogenSurcharge,BiocideSurcharge,KosherSurcharge,LabelSurcharge,OtherSurcharge from tblShelfMaster where shelfid={0}", id);
db.Database.ExecuteSqlCommand(s);
return pdid;
}
}
public static ShelfMasterViewModel fnFillShelfMasterFromDB(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
ShelfMasterViewModel SM = new ShelfMasterViewModel();
var dbSM = db.tblShelfMaster.Find(id);
// get a pointer to the ProductDetail and ProductMaster parent records
var PD = db.tblProductDetail.Find(dbSM.ProductDetailID);
var PM = db.tblProductMaster.Find(PD.ProductMasterID);
SM.shelfid = dbSM.ShelfID;
SM.productdetailid = dbSM.ProductDetailID;
SM.warehouse = dbSM.Warehouse;
SM.size = dbSM.Size;
SM.unitweight = dbSM.UnitWeight;
SM.reordermin = dbSM.ReorderMin;
SM.reordermax = dbSM.ReorderMax;
SM.reorderqty = dbSM.ReorderQty;
SM.bin = dbSM.Bin; //??????
SM.hazardsurcharge = dbSM.HazardSurcharge;
SM.flammablesurcharge = dbSM.FlammableSurcharge;
SM.heatsurcharge = dbSM.HeatSurcharge;
SM.refrigsurcharge = dbSM.RefrigSurcharge;
SM.freezersurcharge = dbSM.FreezerSurcharge;
SM.cleansurcharge = dbSM.CleanSurcharge;
SM.blendsurcharge = dbSM.BlendSurcharge;
SM.nalgenesurcharge = dbSM.NalgeneSurcharge;
SM.nitrogensurcharge = dbSM.NitrogenSurcharge;
SM.biocidesurcharge = dbSM.BiocideSurcharge;
SM.koshersurcharge = dbSM.KosherSurcharge;
SM.labelsurcharge = dbSM.LabelSurcharge;
SM.othersurcharge = dbSM.OtherSurcharge;
SM.othersurchargeamt = dbSM.OtherSurchargeAmt;
SM.othersurchargedescription = dbSM.OtherSurchargeDescription;
SM.newitem = dbSM.NewItem;
SM.inactivesize = dbSM.InactiveSize;
SM.weboeinclude = dbSM.WebOEInclude;
SM.sortorder = dbSM.SortOrder;
SM.packageid = dbSM.PackageID;
SM.notes = dbSM.Notes;
SM.discontinued = dbSM.Discontinued;
SM.alert = dbSM.Alert;
SM.custcode = dbSM.CustCode;
SM.ListOfTierSizes = fnListOfTierSizes(PM.ClientID);
SM.ListOfPackages = fnListOfPackageIDs(dbSM.Size);
SM.ListOfWareHouses = fnWarehouseIDs();
return SM;
}
}
private static List<SelectListItem> fnListOfClientIDs()
{
using (var db = new EF.CMCSQL03Entities())
{
List<SelectListItem> mylist = new List<SelectListItem>();
mylist = (from t in db.tblClient
join pm in db.tblProductMaster on t.ClientID equals pm.ClientID
join pd in db.tblProductDetail on pm.ProductMasterID equals pd.ProductDetailID
orderby t.ClientName
select new SelectListItem { Value = t.ClientID.ToString(), Text = t.CMCLocation + " - " + t.ClientName }).Distinct().ToList();
mylist = (from t in mylist orderby t.Text select t).ToList();
mylist.Insert(0, new SelectListItem { Value = "0", Text = "Select Client" });
return mylist;
}
}
public ActionResult FillIndexViewBag(int id)
{
// This will change later (after some DB changes)
using (var db = new EF.CMCSQL03Entities())
{
var dbProductDetail = db.tblProductDetail.Find(id);
var dbProductMaster = db.tblProductMaster.Find(dbProductDetail.ProductMasterID);
var dbClient = db.tblClient.Find(dbProductMaster.ClientID);
ViewBag.ParentID = id;
ViewBag.logofilename = dbClient.LogoFileName;
ViewBag.ProductCode = dbProductDetail.ProductCode;
ViewBag.ProductName = dbProductDetail.ProductName;
return null;
}
}
public static ShelfMasterViewModel fnCreateNewShelfMaster(int id)
{
ShelfMasterViewModel SM = new ShelfMasterViewModel();
SM.shelfid = -1;
SM.productdetailid = id;
using (var db = new EF.CMCSQL03Entities())
{
// get a pointer to the ProductDetail and ProductMaster parent records
var PD = db.tblProductDetail.Find(id);
var PM = db.tblProductMaster.Find(PD.ProductMasterID);
SM.ListOfTierSizes = fnListOfTierSizes(PM.ClientID);
SM.ListOfPackages = fnListOfPackageIDs(null);
SM.ListOfWareHouses = fnWarehouseIDs();
return SM;
}
}
public static string fnBuildShelfMasterPackagesDropDown(string size)
{
// This returns ONLY the <option> portion of the <select> tag
using (var db = new EF.CMCSQL03Entities())
{
var qry = (from t in db.tblPackage where t.Size == size orderby t.Size select t);
string s = "<option value='0' selected=true>Select Package</option>";
if (qry.Count() > 0)
{
foreach (var item in qry)
{ s = s + "<option value=" + item.PackageID.ToString() + ">" + item.PartNumber + " - " + item.Description + "</option>"; }
}
else
{ s = s + "<option value=0>No Packages Found</option>"; }
s = s + "</select>";
return s;
}
}
public static InventoryLogNote fnCreateInventoryLogNote(int id)
{
InventoryLogNote obj = new InventoryLogNote();
using (var db = new EF.CMCSQL03Entities())
{
obj.productnoteid = -1;
obj.productmasterid = id; // important
obj.reasoncode = null;
obj.notedate = DateTime.UtcNow;
obj.notes = null;
obj.ListOfReasonCodes = (from t in db.tblReasonCode
orderby t.Reason
select new SelectListItem { Value = t.Reason, Text = t.Reason }).ToList();
obj.ListOfReasonCodes.Insert(0, new SelectListItem { Value = "", Text = "Select Reason Code" });
}
return obj;
}
public ActionResult AddPHDetail(int id)
{
int proddetid = Convert.ToInt32(TempData["ProductDetId"]);
using (var db = new EF.CMCSQL03Entities())
{
var srcrcd = db.tblGHSPHSource.Find(id);
var newrecord = new EF.tblGHSPHDetail
{
PHNumber = srcrcd.PHNumber,
ProductDetailID = proddetid,
CreateDate = DateTime.Now,
CreateUser = HttpContext.User.Identity.Name
};
db.tblGHSPHDetail.Add(newrecord);
db.SaveChanges();
}
return null;
}
public ActionResult Detail(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
List<GHSDetail> model = new List<GHSDetail>();
var phdetail = (from t in db.tblGHSPHDetail
join tsrc in db.tblGHSPHSource on t.PHNumber equals tsrc.PHNumber
where t.ProductDetailID == id && tsrc.Language == "EN"
orderby t.PHNumber ascending
select new
{
t.PHDetailID,
t.ProductDetailID,
t.ExcludeFromLabel,
t.PHNumber,
tsrc.Language,
tsrc.PHStatement
}).ToList();
foreach (var item in phdetail) //retrieve each item and assign to model
{
model.Add(new GHSDetail()
{
PHDetailID = item.PHDetailID,
ProductDetailID = Convert.ToInt32(item.ProductDetailID),
ExcludeFromLabel = item.ExcludeFromLabel,
PHNumber = item.PHNumber,
Language = item.Language,
PHStatement = item.PHStatement
});
}
return PartialView(model);
}
}
public ActionResult CasList(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
var obj = (from t in db.tblCAS
where t.ProductDetailID == id
select new Cas
{
casid = t.CASID,
productdetailid = t.ProductDetailID,
casnumber = t.CasNumber,
chemicalname = t.ChemicalName,
percentage = t.Percentage,
restrictedqty = t.RestrictedQty,
restrictedamount = t.RestrictedAmount,
reportableqty = t.ReportableQty,
reportableamount = t.ReportableAmount,
lessthan = t.LessThan,
excludefromlabel = t.ExcludeFromLabel
}).ToList();
ViewBag.ParentKey = id;
return PartialView("~/Views/Products/_Cas.cshtml", obj);
}
}
public static int fnProductMasterID(int id)
{
// return MasterID of a Detail
using (var db = new EF.CMCSQL03Entities())
{
var q = (from t in db.tblProductDetail
where t.ProductDetailID == id
select new { t.ProductMasterID }).FirstOrDefault();
return Convert.ToInt32(q.ProductMasterID);
}
}
public static int fnSaveCASToDB(Cas CS)
{
using (var db = new EF.CMCSQL03Entities())
{
if (CS.casid == -1)
{
var newrec = new EF.tblCAS();
db.tblCAS.Add(newrec);
db.SaveChanges();
CS.casid = newrec.CASID;
}
var q = (from t in db.tblCAS
where t.CASID == CS.casid
select t).FirstOrDefault();
q.ProductDetailID = CS.productdetailid;
q.CasNumber = CS.casnumber;
q.ChemicalName = CS.chemicalname;
q.Percentage = CS.percentage;
q.RestrictedQty = CS.restrictedqty;
q.RestrictedAmount = CS.restrictedamount;
q.ReportableQty = CS.reportableqty;
q.ReportableAmount = CS.reportableamount;
q.LessThan = CS.lessthan;
q.ExcludeFromLabel = CS.excludefromlabel;
db.SaveChanges();
return q.CASID;
}
}
private static int fnNewShelfID()
{
using (var db = new EF.CMCSQL03Entities())
{
var newrecord = new EF.tblShelfMaster
{
// dont need to insert any fields, just need the new PK
};
db.tblShelfMaster.Add(newrecord); db.SaveChanges();
int newpk = newrecord.ShelfID;
return newpk;
}
}
public static ClientProfile FillFromDB(ClientProfile CP)
{
using (var db = new EF.CMCSQL03Entities())
{
var q = (from t in db.tblClient
where t.ClientID == CP.ClientID
select t).FirstOrDefault();
CP.ClientID = q.ClientID;
CP.LegacyID = q.LegacyID;
CP.GlobalClientID = q.GlobalClientID;
CP.ClientCode = q.ClientCode;
CP.ClientName = q.ClientName;
CP.CMCLocation = q.CMCLocation;
CP.ClientReference = q.ClientReference;
CP.ClientEntityName = q.ClientEntityName;
CP.ClientCurrency = q.ClientCurrency;
CP.ClientUM = q.ClientUM;
CP.ClientNetTerm = String.IsNullOrEmpty(q.ClientNetTerm) ? "Net 30 Days" : q.ClientNetTerm;
CP.MSDS = q.MSDS ?? false;
CP.MSDSFileDir = q.MSDSFileDir;
CP.TDS = q.TDS ?? false;
CP.TDSFileDir = q.TDSFileDir;
CP.COA = q.COA ?? false;
CP.COAFileDir = q.COAFileDir;
CP.BOLComment = q.BOLComment;
//CP.LogoFileDir = q.LogoFileDir;
CP.LogoFileDir = q.ClientCode + ".gif";
CP.InvoiceAddress = q.InvoiceAddress;
CP.InvoiceEmailTo = q.InvoiceEmailTo;
CP.KeyContactDir = q.KeyContactDir;
CP.ClientContact = q.ClientContact;
CP.CMCContact = q.CMCContact;
CP.ClientUrl = q.ClientUrl;
CP.ProductSetupDetails = q.ProductSetupDetails;
CP.SDSLanguage = q.SDSLanguage;
CP.SDSUpdateMethod = q.SDSUpdateMethod;
CP.LabelLanguage = q.LabelLanguage;
CP.SDSRequired = q.SDSRequired ?? false;
CP.COARequired = q.COARequired ?? false;
CP.TDSRequired = q.TDSRequired ?? false;
CP.StdCoverLetterRequired = q.StdCoverLetterRequired ?? false;
CP.InventoryReports = q.InventoryReports;
CP.CeaseShipPeriod = q.CeaseShipPeriod;
CP.ReplenishmentLeadDays = q.ReplenishmentLeadDays;
CP.ExpDateOnLabel = q.ExpDateOnLabel ?? false;
CP.ExpDateRules = q.ExpDateRules;
CP.WasteProcedure = q.WasteProcedure;
CP.InventoryBusinessRules = q.InventoryBusinessRules;
CP.SpecialReqAllowed = q.SpecialReqAllowed;
CP.CommercialInvoiceValue = q.CommercialInvoiceValue;
CP.FreezableProcedure = q.FreezableProcedure;
CP.SurveyUsed = q.SurveyUsed ?? false;
CP.CSBusinessRules = q.CSBusinessRules;
CP.ShippingRules = q.ShippingRules;
CP.ShipConfirmEmail = q.ShipConfirmEmail;
CP.DelayConfirmEmail = q.DelayConfirmEmail;
CP.OrderConfirmEmail = q.OrderConfirmEmail;
CP.InvoiceSegregation = q.InvoiceSegregation;
CP.ChargesSummary = q.ChargesSummary;
CP.PartialDeliveryAllowed = q.PartialDeliveryAllowed;
CP.ClientStatus = q.ClientStatus;
CP.ActiveDate = q.ActiveDate;
CP.SurchageHazard = q.SurchageHazard;
CP.SurchargeFlammable = q.SurchargeFlammable;
CP.SurchargeHeat = q.SurchargeHeat;
CP.SurchargeRefrigerate = q.SurchargeRefrigerate;
CP.SurchargeFreeze = q.SurchargeFreeze;
CP.SurchargeClean = q.SurchargeClean;
CP.SurchargeNalgene = q.SurchargeNalgene;
CP.SurchargeNitrogen = q.SurchargeNitrogen;
CP.SurchargeBiocide = q.SurchargeBiocide;
CP.SurchargeBlend = q.SurchargeBlend;
CP.SurchargeKosher = q.SurchargeKosher;
CP.HazDHServLvl1 = q.HazDHServLvl1;
CP.HazDHServLvl2 = q.HazDHServLvl2;
CP.HazDHServLvl3 = q.HazDHServLvl3;
CP.HazDHServLvl4 = q.HazDHServLvl4;
CP.NonHazDHServLvl1 = q.NonHazDHServLvl1;
CP.NonHazDHServLvl2 = q.NonHazDHServLvl2;
CP.NonHazDHServLvl3 = q.NonHazDHServLvl3;
CP.NonHazDHServLvl4 = q.NonHazDHServLvl4;
return CP;
}
}
private static List<SelectListItem> fnListOfTierSizes(int? ClientID)
{
List<SelectListItem> mylist = new List<SelectListItem>();
using (var db = new EF.CMCSQL03Entities())
{
mylist = (from t in db.tblTier
where t.ClientID == ClientID
orderby t.Size
select new SelectListItem { Value = t.Size, Text = t.Size }).Distinct().ToList();
mylist.Add(new SelectListItem { Value = "", Text = "" });
return mylist;
}
}
private static List<SelectListItem> fnListOfPackageIDs(string size)
{
List<SelectListItem> mylist = new List<SelectListItem>();
using (var db = new EF.CMCSQL03Entities())
{
mylist = (from t in db.tblPackage
where t.Size == size
orderby t.Size
select new SelectListItem { Value = t.PackageID.ToString(), Text = t.PartNumber + "-" + t.Description }).ToList();
mylist.Add(new SelectListItem { Value = "", Text = "" });
return mylist;
}
}
public static void fnSaveShelfMaster(ShelfMasterViewModel obj)
{
using (var db = new EF.CMCSQL03Entities())
{
if (obj.shelfid == -1)
{ obj.shelfid = fnNewShelfID(); }
var dbSM = db.tblShelfMaster.Find(obj.shelfid);
//SM.shelfid = dbSM.ShelfID;
dbSM.ProductDetailID = obj.productdetailid;
dbSM.Warehouse = obj.warehouse;
dbSM.Size = obj.size;
dbSM.UnitWeight = obj.unitweight;
dbSM.ReorderMin = obj.reordermin;
dbSM.ReorderMax = obj.reordermax;
dbSM.ReorderQty = obj.reorderqty;
dbSM.Bin = obj.bin; //??????
dbSM.HazardSurcharge = obj.hazardsurcharge;
dbSM.FlammableSurcharge = obj.flammablesurcharge;
dbSM.HeatSurcharge = obj.heatsurcharge;
dbSM.RefrigSurcharge = obj.refrigsurcharge;
dbSM.FreezerSurcharge = obj.freezersurcharge;
dbSM.CleanSurcharge = obj.cleansurcharge;
dbSM.BlendSurcharge = obj.blendsurcharge;
dbSM.NalgeneSurcharge = obj.nalgenesurcharge;
dbSM.NitrogenSurcharge = obj.nitrogensurcharge;
dbSM.BiocideSurcharge = obj.biocidesurcharge;
dbSM.KosherSurcharge = obj.koshersurcharge;
dbSM.LabelSurcharge = obj.labelsurcharge;
dbSM.OtherSurcharge = obj.othersurcharge;
dbSM.OtherSurchargeAmt = obj.othersurchargeamt;
dbSM.OtherSurchargeDescription = obj.othersurchargedescription;
dbSM.NewItem = obj.newitem;
dbSM.InactiveSize = obj.inactivesize;
dbSM.WebOEInclude = obj.weboeinclude;
dbSM.SortOrder = obj.sortorder;
dbSM.PackageID = obj.packageid;
dbSM.Notes = obj.notes;
dbSM.Discontinued = obj.discontinued;
dbSM.Alert = obj.alert;
dbSM.CustCode = obj.custcode;
db.SaveChanges();
}
}
public static void SaveProductMaster(ProductProfile pm)
{
using (var db = new EF.CMCSQL03Entities())
{
var q = db.tblProductMaster.Find(pm.productmasterid);
q.UpdateDate = System.DateTime.Now;
q.UpdateUser = HttpContext.Current.User.Identity.Name;
q.ClientID = pm.clientid;
q.MasterCode = pm.mastercode;
q.MasterName = pm.mastername;
q.SUPPLYID = pm.supplyid;
q.Discontinued = pm.discontinued;
q.NoReorder = pm.noreorder;
q.PackOutOnReceipt = pm.packoutonreceipt;
q.RestrictedToAmount = pm.restrictedtoamount;
q.CreateDate = pm.createdate;
q.MasterNotes = pm.masternotes;
q.MasterNotesAlert = pm.masternotesalert;
q.ReOrderAdjustmentDays = pm.reorderadjustmentdays;
q.CeaseShipDifferential = pm.ceaseshipdifferential;
q.CleanRoomGMP = pm.cleanroomgmp;
q.NitrogenBlanket = pm.nitrogenblanket;
q.MoistureSensitive = pm.moisturesensitive;
q.MixWell = pm.mixwell;
q.MixingInstructions = pm.mixinginstructions;
q.Refrigerate = pm.refrigerate;
q.DoNotPackAbove60 = pm.donotpackabove60;
q.HandlingOther = pm.handlingother;
q.FlammableGround = pm.flammableground;
q.HeatPriorToFilling = pm.heatpriortofilling;
q.FlashPoint = pm.flashpoint;
q.HeatingInstructions = pm.heatinginstructions;
q.OtherHandlingInstr = pm.otherhandlinginstr;
q.NormalAppearence = pm.normalappearence;
q.RejectionCriterion = pm.rejectioncriterion;
q.Hood = pm.hood;
q.LabHood = pm.labhood;
q.WalkInHood = pm.walkinhood;
q.SafetyGlasses = pm.safetyglasses;
q.Gloves = pm.gloves;
q.GloveType = pm.glovetype;
q.Apron = pm.apron;
q.ArmSleeves = pm.armsleeves;
q.Respirator = pm.respirator;
q.FaceShield = pm.faceshield;
q.FullSuit = pm.fullsuit;
q.CleanRoomEquipment = pm.cleanroomequipment;
q.OtherEquipment = pm.otherequipment;
q.Toxic = pm.toxic;
q.HighlyToxic = pm.highlytoxic;
q.ReproductiveToxin = pm.reproductivetoxin;
q.CorrosiveHaz = pm.corrosivehaz;
q.Sensitizer = pm.sensitizer;
q.Carcinogen = pm.carcinogen;
q.Ingestion = pm.ingestion;
q.Inhalation = pm.inhalation;
q.Skin = pm.skin;
q.SkinContact = pm.skincontact;
q.EyeContact = pm.eyecontact;
q.Combustible = pm.combustible;
q.Corrosive = pm.corrosive;
q.Flammable = pm.flammable;
q.Oxidizer = pm.oxidizer;
q.Reactive = pm.reactive;
q.Hepatotoxins = pm.hepatotoxins;
q.Nephrotoxins = pm.nephrotoxins;
q.Neurotoxins = pm.neurotoxins;
q.Hepatopoetics = pm.hepatopoetics;
q.PulmonaryDisfunction = pm.pulmonarydisfunction;
q.ReporductiveToxin = pm.reporductivetoxin;
q.CutaneousHazards = pm.cutaneoushazards;
q.EyeHazards = pm.eyehazards;
q.Health = pm.health;
q.Flammability = pm.flammability;
q.Reactivity = pm.reactivity;
q.OtherEquipmentDescription = pm.otherequipmentdescription;
q.ShlfLife = pm.shlflife;
q.Booties = pm.booties;
q.HazardClassGround_SG = pm.hazardclassground_sg;
q.irritant = pm.irritant;
q.RighttoKnow = pm.righttoknow;
q.SARA = pm.sara;
q.FlammableStorageRoom = pm.flammablestorageroom;
q.FireList = pm.firelist;
q.FreezableList = pm.freezablelist;
q.MSDSOTHERNUMBER = pm.msdsothernumber;
q.FREEZERSTORAGE = pm.freezerstorage;
q.CLIENTREQ = pm.clientreq;
q.CMCREQ = pm.cmcreq;
q.RETURNLOCATION = pm.returnlocation;
q.DENSITY = pm.density;
q.SpecialBlend = pm.specialblend;
q.SARA302EHS = pm.sara302ehs;
q.SARA313 = pm.sara313;
q.HalfMaskRespirator = pm.halfmaskrespirator;
q.FullFaceRespirator = pm.fullfacerespirator;
q.Torque = pm.torque;
q.TorqueRequirements = pm.torquerequirements;
q.OtherPkg = pm.otherpkg;
q.EECAll = pm.eecall;
q.RPhrasesAll = pm.rphrasesall;
q.SPhrasesAll = pm.sphrasesall;
q.PHAll = pm.phall;
q.English = pm.english;
q.German = pm.german;
q.Dutch = pm.dutch;
q.EECSymbol1 = pm.eecsymbol1;
q.EECSymbol2 = pm.eecsymbol2;
q.EECSymbol3 = pm.eecsymbol3;
q.Handling = pm.handling;
q.ShippingNotes = pm.shippingnotes;
q.OtherLabelNotes = pm.otherlabelnotes;
q.ProductDescription = pm.productdescription;
q.PeroxideFormer = pm.peroxideformer;
q.SpecificGravity = pm.specificgravity;
q.phValue = pm.phvalue;
q.PhysicalToxic = pm.physicaltoxic;
q.WasteCode = pm.wastecode;
q.CountryOfOrigin = pm.countryoforigin;
q.LeadTime = pm.leadtime;
q.DustFilter = pm.dustfilter;
q.TemperatureControlledStorage = pm.temperaturecontrolledstorage;
q.PrePacked = pm.prepacked;
q.AlertNotesReceiving = pm.alertnotesreceiving;
q.AlertNotesPackout = pm.alertnotespackout;
q.WasteAccumStartDate = pm.wasteaccumstartdate;
q.ProductSetupDate = pm.productsetupdate;
db.SaveChanges();
}
}
public static List<ShelfMasterViewModel> fnListOfShelfMasters(int id)
{
using (var db = new EF.CMCSQL03Entities())
{
var mylist = (from t in db.tblShelfMaster
join pd in db.tblProductDetail on t.ProductDetailID equals pd.ProductDetailID
join pm in db.tblProductMaster on pd.ProductMasterID equals pm.ProductMasterID
join cl in db.tblClient on pm.ClientID equals cl.ClientID
where t.ProductDetailID == id //&& t.InactiveSize == false
let PPN = (from pk in db.tblPackage where pk.PackageID == t.PackageID select pk.PartNumber).FirstOrDefault()
let PPMaterial = (from pk1 in db.tblPackage where pk1.PackageID == t.PackageID select pk1.Description).FirstOrDefault()
select new ShelfMasterViewModel
{
clientum = cl.ClientUM,
shelfid = t.ShelfID,
productdetailid = t.ProductDetailID,
clientid = cl.ClientID,
clientname = cl.ClientName,
logofilename = cl.LogoFileName,
productcode = pd.ProductCode,
productname = pd.ProductName,
size = t.Size,
packageid = t.PackageID,
// ii busarea = t.BusArea,
warehouse = t.Warehouse,
bin = t.Bin,
reordermin = t.ReorderMin,
reordermax = t.ReorderMax,
reorderqty = t.ReorderQty,
notes = t.Notes,
packagepartnumber = PPN,
pkgmaterial = PPMaterial,
hazardsurcharge = t.HazardSurcharge,
flammablesurcharge = t.FlammableSurcharge,
heatsurcharge = t.HeatSurcharge,
refrigsurcharge = t.RefrigSurcharge,
freezersurcharge = t.FreezerSurcharge,
cleansurcharge = t.CleanSurcharge,
blendsurcharge = t.BlendSurcharge,
nalgenesurcharge = t.NalgeneSurcharge,
nitrogensurcharge = t.NitrogenSurcharge,
biocidesurcharge = t.BiocideSurcharge,
koshersurcharge = t.KosherSurcharge,
labelsurcharge = t.LabelSurcharge,
othersurcharge = t.OtherSurcharge,
inactivesize = t.InactiveSize
}).ToList();
foreach (var item in mylist)
{
}
return mylist;
}
}
public static int NewClientId()
{
using (var db = new EF.CMCSQL03Entities())
{
var newrow = new EF.tblClient { };
db.tblClient.Add(newrow);
db.SaveChanges();
int clientkey = newrow.ClientID;
return clientkey;
}
}
public static int fnSaveProductNoteToDB(ProductNote PN)
{
using (var db = new EF.CMCSQL03Entities())
{
if (PN.productnoteid == -1)
{
var newrec = new EF.tblPPPDLogNote();
db.tblPPPDLogNote.Add(newrec);
db.SaveChanges();
PN.productnoteid = newrec.PPPDLogNoteID;
}
var q = (from t in db.tblPPPDLogNote
where t.PPPDLogNoteID == PN.productnoteid
select t).FirstOrDefault();
q.ProductDetailID = PN.productdetailid;
q.NoteDate = PN.notedate;
q.Notes = PN.notes;
q.ReasonCode = PN.reasoncode;
db.SaveChanges();
return q.PPPDLogNoteID;
}
}
public static void SaveClient(ClientProfile CP)
{
using (var db = new EF.CMCSQL03Entities())
{
var q = db.tblClient.Find(CP.ClientID);
q.ClientID = CP.ClientID;
q.LegacyID = CP.LegacyID;
q.GlobalClientID = CP.GlobalClientID;
q.ClientCode = CP.ClientCode;
q.ClientName = CP.ClientName;
q.CMCLocation = CP.CMCLocation;
q.ClientCurrency = CP.ClientCurrency;
q.ClientUM = CP.ClientUM;
q.ClientNetTerm = CP.ClientNetTerm;
q.MSDS = CP.MSDS;
q.MSDSFileDir = CP.MSDSFileDir;
q.TDS = CP.TDS;
q.TDSFileDir = CP.TDSFileDir;
q.COA = CP.COA;
q.COAFileDir = CP.COAFileDir;
q.BOLComment = CP.BOLComment;
//q.LogoFileDir = CP.LogoFileDir;
q.InvoiceAddress = CP.InvoiceAddress;
q.InvoiceEmailTo = CP.InvoiceEmailTo;
q.KeyContactDir = CP.KeyContactDir;
q.ClientContact = CP.ClientContact;
q.CMCContact = CP.CMCContact;
q.ClientUrl = CP.ClientUrl;
q.ProductSetupDetails = CP.ProductSetupDetails;
q.SDSLanguage = CP.SDSLanguage;
q.SDSUpdateMethod = CP.SDSUpdateMethod;
q.LabelLanguage = CP.LabelLanguage;
q.SDSRequired = CP.SDSRequired;
q.COARequired = CP.COARequired;
q.TDSRequired = CP.TDSRequired;
q.StdCoverLetterRequired = CP.StdCoverLetterRequired;
q.InventoryReports = CP.InventoryReports;
q.CeaseShipPeriod = CP.CeaseShipPeriod;
q.ReplenishmentLeadDays = CP.ReplenishmentLeadDays;
q.ExpDateOnLabel = CP.ExpDateOnLabel;
q.ExpDateRules = CP.ExpDateRules;
q.WasteProcedure = CP.WasteProcedure;
q.InventoryBusinessRules = CP.InventoryBusinessRules;
q.SpecialReqAllowed = CP.SpecialReqAllowed;
q.CommercialInvoiceValue = CP.CommercialInvoiceValue;
q.FreezableProcedure = CP.FreezableProcedure;
q.SurveyUsed = CP.SurveyUsed;
q.CSBusinessRules = CP.CSBusinessRules;
q.ShippingRules = CP.ShippingRules;
q.ShipConfirmEmail = CP.ShipConfirmEmail;
q.DelayConfirmEmail = CP.DelayConfirmEmail;
q.OrderConfirmEmail = CP.OrderConfirmEmail;
q.InvoiceSegregation = CP.InvoiceSegregation;
q.ChargesSummary = CP.ChargesSummary;
q.PartialDeliveryAllowed = CP.PartialDeliveryAllowed;
q.ClientStatus = CP.ClientStatus;
q.ActiveDate = CP.ActiveDate;
q.SurchageHazard = CP.SurchageHazard;
q.SurchargeFlammable = CP.SurchargeFlammable;
q.SurchargeHeat = CP.SurchargeHeat;
q.SurchargeRefrigerate = CP.SurchargeRefrigerate;
q.SurchargeFreeze = CP.SurchargeFreeze;
q.SurchargeClean = CP.SurchargeClean;
q.SurchargeNalgene = CP.SurchargeNalgene;
q.SurchargeNitrogen = CP.SurchargeNitrogen;
q.SurchargeBiocide = CP.SurchargeBiocide;
q.SurchargeBlend = CP.SurchargeBlend;
q.SurchargeKosher = CP.SurchargeKosher;
q.HazDHServLvl1 = CP.HazDHServLvl1;
q.HazDHServLvl2 = CP.HazDHServLvl2;
q.HazDHServLvl3 = CP.HazDHServLvl3;
q.HazDHServLvl4 = CP.HazDHServLvl4;
q.NonHazDHServLvl1 = CP.NonHazDHServLvl1;
q.NonHazDHServLvl2 = CP.NonHazDHServLvl2;
q.NonHazDHServLvl3 = CP.NonHazDHServLvl3;
q.NonHazDHServLvl4 = CP.NonHazDHServLvl4;
db.SaveChanges();
}
}
public static void SaveProductDetail(ProductProfile PP)
{
using (var db = new EF.CMCSQL03Entities())
{
var q = db.tblProductDetail.Find(PP.productdetailid);
q.UpdateDate = System.DateTime.Now;
q.UpdateUser = HttpContext.Current.User.Identity.Name;
q.ProductCode = PP.productcode;
q.ProductDetailID = PP.productdetailid;
q.ProductMasterID = PP.productmasterid;
q.DivisionID = PP.divisionid;
q.ProductCode = PP.productcode;
q.ProductName = PP.productname;
q.CustCode = PP.custcode;
q.MultiLotReq = PP.multilotreq;
q.ExtendableExpDt = PP.extendableexpdt;
q.HarmonizedCode = PP.harmonizedcode;
q.EndUse = PP.enduse;
q.SGRevisionDate = PP.sgrevisiondate;
q.MSDSRevisionDate = PP.msdsrevisiondate;
q.MSDSRevisionNumber = PP.msdsrevisionnumber;
q.LabelRevisionDate = PP.labelrevisiondate;
q.LabelNumber = PP.labelnumber;
q.ProductChecked = PP.productchecked;
q.CheckedBy = PP.checkedby;
q.CheckedWhen = PP.checkedwhen;
q.EPABiocide = PP.epabiocide;
q.LabelInfo = PP.labelinfo;
q.GHSReady = PP.ghsready;
q.CustomsValue = PP.customsvalue;
q.CustomsValueUnit = PP.customsvalueunit;
q.GlobalProduct = PP.globalproduct;
q.PolymerizationHazard = PP.polymerizationhazard;
q.SDSContactName = PP.sdscontactname;
q.SDSContactPhone = PP.sdscontactphone;
q.ChinaCertificationDate = PP.chinacertificationdate;
q.LabelContactName = PP.labelcontactname;
q.LabelContactPhone = PP.labelcontactphone;
q.TechnicalSheet = PP.technicalsheet;
q.TechnicalSheetRevisionDate = PP.technicalsheetrevisondate;
q.EmergencyContactNumber = PP.emergencycontactnumber;
q.EPAHazardousWaste = PP.epahazardouswaste;
q.NonRCRAWaste = PP.nonrcrawaste;
q.WasteProfileNumber = PP.wasteprofilenumber;
q.ShippingChemicalName = PP.shippingchemicalname;
q.LabelNotesEPA = PP.labelnotesepa;
q.GRNUNNUMBER = PP.grnunnumber;
q.GRNPKGRP = PP.grnpkgrp;
q.GRNHAZSUBCL = PP.grnhazsubcl;
q.GRNLABEL = PP.grnlabel;
q.GRNSUBLABEL = PP.grnsublabel;
q.GRNHAZCL = PP.grnhazcl;
q.GRNSHIPNAME = PP.grnshipname;
q.GRNOSNAME = PP.grnosname;
q.GRNSHIPNAMED = PP.grnshipnamed;
q.GRNTREMACARD = PP.grntremacard;
q.AIRUNNUMBER = PP.airunnumber;
q.AIRPKGRP = PP.airpkgrp;
q.AIRHAZSUBCL = PP.airhazsubcl;
q.AIRLABEL = PP.airlabel;
q.AIRSUBLABEL = PP.airsublabel;
q.AIRHAZCL = PP.airhazcl;
q.AIRSHIPNAME = PP.airshipname;
q.AIRNOSNAME = PP.airnosname;
q.SEAUNNUM = PP.seaunnum;
q.SEAPKGRP = PP.seapkgrp;
q.SEAHAZSUBCL = PP.seahazsubcl;
q.SEALABEL = PP.sealabel;
q.SEASUBLABEL = PP.seasublabel;
q.SEAHAZCL = PP.seahazcl;
q.SEASHIPNAME = PP.seashipname;
q.SEANOSNAME = PP.seanosname;
q.SEASHIPNAMED = PP.seashipnamed;
q.SEAHAZMAT = PP.seahazmat;
q.SEAEMSNO = PP.seaemsno;
q.SEAMFAGNO = PP.seamfagno;
q.AlertNotesShipping = PP.alertnotesshipping;
q.AlertNotesOrderEntry = PP.alertnotesorderentry;
q.RCRAUNNumber = PP.rcraunnumber;
q.RCRAPKGRP = PP.rcrapkgrp;
q.RCRAHAZSUBCL = PP.rcrahazsubcl;
q.RCRALABEL = PP.rcralabel;
q.RCRASUBLABEL = PP.rcrasublabel;
q.RCRAHAZCL = PP.rcrahazcl;
q.RCRASHIPNAME = PP.rcrashipname;
q.RCRANOSNAME = PP.rcranosname;
q.Active = PP.active;
q.AccuracyVerified = PP.accuracyverified;
if (q.AccuracyVerified == true)
{
q.AccuracyVerifiedBy = HttpContext.Current.User.Identity.Name;
}
db.SaveChanges();
}
}
