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