public ActionResult Edit(int id)
{
ClientProfile CP = new ClientProfile();
CP.ClientID = id;
CP = ClientService.FillFromDB(CP);
return View(CP);
}
public static int fnSaveClientProfile(ClientProfile obj)
{
int clientid = Convert.ToInt32(obj.ClientID);
if (clientid == -1)
{
obj.ClientID = NewClientId();
}
ClientService.SaveClient(obj);
return obj.ClientID;
}
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 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;
}
}
public ActionResult SaveClientProfile(ClientProfile CPVM)
{
int pk = ClientService.fnSaveClientProfile(CPVM);
return RedirectToAction("Edit", new { id = pk });
}
public ActionResult View(int id)
{
ClientProfile obj = new ClientProfile();
obj.ClientID = id;
obj = ClientService.FillFromDB(obj);
return View(obj);
}