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