public M_JobTimeableModel JobTimeTable_Select(M_JobTimeableModel Mjt) { TOSEntities ent = new TOSEntities(); //M_JobTimeable mj = ent.M_JobTimeable.Where(m => m.CompanyCD == Mjt.CompanyCD).SingleOrDefault(); M_JobTimeable mj = ent.M_JobTimeable.SingleOrDefault(); if (mj != null) { Mjt.CompanyCD = mj.CompanyCD; Mjt.OrderAblePeriod = mj.OrderAblePeriod; Mjt.CancelAblePeriod = mj.CancelAblePeriod; Mjt.ExceptionAboutPeriod = mj.ExceptionAboutPeriod; } return(Mjt); }
public M_CompanyModel CheckLogin(M_CompanyModel mcmodel) { TOSEntities ent = new TOSEntities(); M_Company mc = ent.M_Company.Where(m => m.CompanyCD == mcmodel.CompanyCD && m.Password == mcmodel.Password).SingleOrDefault(); if (mc == null) { return(null); } else { mcmodel.CompanyName = mc.CompanyName; mcmodel.UserRole = mc.UserRole; return(mcmodel); } }
public ActionResult Login(int?errorId) { if (errorId > 0) { TOSEntities en = new TOSEntities(); string IDs = "E"; string Key = "1002"; ViewBag.ErrorMessage = en.Messages.Where(s => s.ID.Equals(IDs) && s.KEY.Equals(Key)).Select(s => s.Message1).FirstOrDefault(); } else { ViewBag.ErrorMessage = ""; } return(View()); }
public ActionResult InsertCompany(MultipleModel model) { Company_EntryBL cbl = new Company_EntryBL(); TOSEntities _entity = new TOSEntities(); var CompanyCD = _entity.M_Company.Where(m => m.CompanyCD.Equals(model.ComModel.CompanyCD)).Select(s => s.CompanyCD).FirstOrDefault(); if (CompanyCD != null) { try { var option = new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted, Timeout = TimeSpan.MaxValue }; TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, option); using (scope) { string PcName = System.Environment.MachineName; //Update Company if (model.ComModel.ZipCD1 != null) { string[] zips = model.ComModel.ZipCD1.Split(new Char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); string zip1 = zips[0].ToString(); string zip2 = zips[1].ToString(); model.ComModel.ZipCD1 = zip1; model.ComModel.ZipCD2 = zip2; } model.ComModel.UpdateOperator = Session["CompanyCD"].ToString(); model.ComModel.UpdateDateTime = DateTime.Now; DataTable dt = cbl.UpdateCompany(model.ComModel, PcName); //Update Company Shipping DataTable dtshipping = new DataTable(); using (var reader = ObjectReader.Create(model.ShippingModel, "ShippingID", "ShippingName", "ZipCD1", "ZipCD2", "Address1", "Address2", "TelephoneNO", "FaxNO")) { dtshipping.Load(reader); } for (int k = 0; k < dtshipping.Rows.Count; k++) { string zipcd = dtshipping.Rows[k]["ZipCD1"].ToString(); if (!String.IsNullOrWhiteSpace(zipcd)) { if (zipcd.Contains("-")) { string[] zip = zipcd.Split('-'); dtshipping.Rows[k]["ZipCD1"] = zip[0]; dtshipping.Rows[k]["ZipCD2"] = zip[1]; } } } cbl.UpdateCompanyShipping(dtshipping, model.ComModel, PcName); //Update Company Tag DataTable dttag = new DataTable(); using (var reader = ObjectReader.Create(model.TagModel, "CompanyCD", "Tag")) { dttag.Load(reader); } cbl.UpdateCompanyTag(dttag, model.ComModel, PcName); //Update Company Brand if (model.MBrandModel.BrandName != null) { model.MBrandModel.UpdateOperator = Session["CompanyCD"].ToString(); cbl.UpdateCompanyBrand(model.MBrandModel, model.ComModel, PcName); } scope.Complete(); } TempData["Imsg"] = "success"; return(RedirectToAction("Company_Entry")); //return RedirectToAction("CompanyUpdate_View"); } catch (Exception ex) { string st = ex.ToString(); TempData["Emsg"] = "Unsuccess"; return(RedirectToAction("Company_Entry")); } } else { try { DataTable Checkdt = cbl.Check_Duplicate_CompanyCD(model.ComModel); if (Checkdt.Rows.Count > 0) { DataTable dtIMsg = cbl.Message_Select("1006", "I"); string message = string.Empty; if (dtIMsg.Rows.Count > 0) { // TempData["Imsg"] = dtIMsg.Rows[0]["Message1"].ToString(); TempData["Dmsg"] = "Duplicate CompanyCD is " + model.ComModel.CompanyCD; } } else { var option = new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted, Timeout = TimeSpan.MaxValue }; TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, option); using (scope) { string PcName = System.Environment.MachineName; //Insert Company if (model.ComModel.ZipCD1 != null) { string[] zips = model.ComModel.ZipCD1.Split(new Char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); string zip1 = zips[0].ToString(); string zip2 = zips[1].ToString(); model.ComModel.ZipCD1 = zip1; model.ComModel.ZipCD2 = zip2; } model.ComModel.InsertOperator = Session["CompanyCD"].ToString(); DataTable dt = cbl.InsertCompany(model.ComModel, PcName); //Insert Company Shipping Array arrayShip = model.ShippingModel.ToArray(); if (arrayShip.Length > 0) { for (int i = 0; i < arrayShip.Length; i++) { if ((!string.IsNullOrWhiteSpace(model.ShippingModel[i].ShippingID.ToString())) && (!string.IsNullOrWhiteSpace(model.ComModel.CompanyCD.ToString())) && model.ShippingModel[i].ShippingID.ToString() != "0") { if (model.ShippingModel[i].ZipCD1 != null) { string[] zipships = model.ShippingModel[i].ZipCD1.Split(new Char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); string zipShip1 = zipships[0].ToString(); string zipShip2 = zipships[1].ToString(); model.ShippingModel[i].ZipCD1 = zipShip1; model.ShippingModel[i].ZipCD2 = zipShip2; } model.ShippingModel[i].InsertOperator = Session["CompanyCD"].ToString(); DataTable dtShip = cbl.InsertCompanyShipping(model.ShippingModel[i], model.ComModel, PcName); } } } //Insert Company Tag Array ArrayTag = model.TagModel.ToArray(); if (ArrayTag.Length > 0) { for (int i = 0; i < ArrayTag.Length; i++) { if (model.TagModel[i].Tag != null && (!string.IsNullOrWhiteSpace(model.ComModel.CompanyCD.ToString()))) { model.TagModel[i].InsertOperator = Session["CompanyCD"].ToString(); DataTable dtTag = cbl.InsertCompanyTag(model.TagModel[i], model.ComModel, PcName); } } } //Insert Company Brand if (model.MBrandModel.BrandName != null) { model.MBrandModel.InsertOperator = Session["CompanyCD"].ToString(); DataTable dtBrand = cbl.InsertCompanyBrand(model.MBrandModel, model.ComModel, PcName); } scope.Complete(); } TempData["Imsg"] = "success"; } return(RedirectToAction("Company_Entry")); //return RedirectToAction("CompanyUpdate_View"); } catch (Exception ex) { string st = ex.ToString(); TempData["Emsg"] = "Unsuccess"; return(RedirectToAction("Company_Entry")); } } }