public JsonResult GetCustomerDetail(int CRef)
{
var db = new NSMMSEntities();
CustomerViewModel t = new CustomerViewModel();
t = db.Customer.Where(x => x.CustomerRef == CRef).Select(c => new CustomerViewModel
{
CustomerStatus = c.CustomerStatus,
CustomerRef = c.CustomerRef,
FullName = c.FullName,
ShortName = c.ShortName,
PostalCode = c.PostalCode,
Addr = c.Addr,
Phone1 = c.Phone1,
Phone2 = c.Phone2,
Fax = c.Fax,
ContactPersonName = c.ContactPersonName,
ContactPersonPhone = c.ContactPersonPhone,
UniformNumbers = c.UniformNumbers,
Notes = c.Notes,
GroupSW = c.GroupSW,
GroupID = c.GroupID,
BranchID = c.BranchID,
ResponsibleID = c.ResponsibleID,
RegionID = c.RegionID,
DefaultUserName = c.SubArea.ResponsibleClass.UserData2.UserName
}).First();
var jsonResult = Json(t, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return jsonResult;
//return Json(lookupList, JsonRequestBehavior.AllowGet);
}
public IQueryable<CustomerViewModel> CustomerSearch(string GroupID, string CustomerID, string FullName, string ShortName, string FieldClass, string ContentClass)
{
List<CustomerViewModel> ret = new List<CustomerViewModel>();
var qry = db.Customer.Where(x => x.CustomerRef != 0);
if (FieldClass == "0")
{
if(GroupID != "" || CustomerID != "" || FullName != "" || ShortName != "")
qry = qry.Where(x => (x.GroupID == GroupID && GroupID != "") || (x.CustomerID.Contains(CustomerID) && CustomerID != "") || (x.FullName.Contains(FullName) && FullName != "") || (x.ShortName.Contains(ShortName) && ShortName != ""));
}
else if (FieldClass == "1")
{
if(GroupID != "")
qry = qry.Where(x => x.GroupID == GroupID);
if (CustomerID != "")
qry = qry.Where(x => x.CustomerID.Contains(CustomerID));
if (FullName != "")
qry = qry.Where(x => x.FullName.Contains(FullName));
if (ShortName != "")
qry = qry.Where(x => x.ShortName.Contains(ShortName));
}
foreach (Customer o in qry)
{
CustomerViewModel c = new CustomerViewModel();
c.Addr = o.Addr;
c.BranchID = o.BranchID;
c.ContactPersonName = o.ContactPersonName;
c.ContactPersonPhone = o.ContactPersonPhone;
c.CustomerID = o.CustomerID;
c.CustomerRef = o.CustomerRef;
c.CustomerStatus = o.CustomerStatus;
if (c.CustomerStatus == "0")
c.CustomerStatusStr = "停用";
else if (c.CustomerStatus == "1")
c.CustomerStatusStr = "使用";
else if (c.CustomerStatus == "9")
c.CustomerStatusStr = "暫用";
c.Fax = o.Fax;
c.FullName = o.FullName;
c.GroupID = o.GroupID;
c.GroupSW = o.GroupSW;
c.Notes = o.Notes;
c.Phone1 = o.Phone1;
c.Phone2 = o.Phone2;
c.PostalCode = o.PostalCode;
c.RegionID = o.RegionID;
c.RegionIDStr = o.SubArea.Name;
c.ResponsibleID = o.ResponsibleID;
c.ShortName = o.ShortName;
c.UniformNumbers = o.UniformNumbers;
//new
c.AddrNumber = (o.AddrNumber == null) ? "" : o.AddrNumber;
//c.CreateDT = o.CreateDateTime.Value;
c.CreateDTStr = "";
if (o.CreateDateTime != null)
{
c.CreateDT = o.CreateDateTime.Value;
c.CreateDTStr = o.CreateDateTime.Value.ToString("yyyy/MM/dd HH:mm");
}
c.CreateUserName = (o.CreateUserID == null) ? "" : o.UserData.UserName;
c.CreateUserID = o.CreateUserID;
//if (o.CreateUserID != null)
// c.CreateUserName = o.UserData.UserName;
//c.History = o.History;
c.History = (o.History == null) ? "" : o.History;
//c.ModifyDT = o.ModifyDateTime.Value;
c.ModifyDTStr = "";
if (o.ModifyDateTime != null)
{
c.ModifyDT = o.ModifyDateTime.Value;
c.ModifyDTStr = o.ModifyDateTime.Value.ToString("yyyy/MM/dd HH:mm");
}
c.ModifyUserID = o.ModifyUserID;
c.ModifyUserName = (o.ModifyUserID == null) ? "" : o.UserData1.UserName;
//if (o.ModifyUserID != null)
// c.ModifyUserName = o.UserData1.UserName;
ret.Add(c);
}
return ret.AsQueryable();
}
public bool Delete(CustomerViewModel customerViewModel)
{
bool ret = false;
try
{
Customer c = db.Customer.Find(customerViewModel.CustomerRef);
db.Customer.Remove(c);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool Update(CustomerViewModel customerViewModel)
{
bool ret = false;
try
{
Customer c = db.Customer.Find(customerViewModel.CustomerRef);
c.Addr = customerViewModel.Addr;
c.BranchID = customerViewModel.BranchID;
c.ContactPersonName = customerViewModel.ContactPersonName;
c.ContactPersonPhone = customerViewModel.ContactPersonPhone;
c.CustomerID = customerViewModel.CustomerID;
c.CustomerStatus = customerViewModel.CustomerStatus;
c.Fax = customerViewModel.Fax;
c.FullName = customerViewModel.FullName;
c.GroupID = customerViewModel.GroupID;
c.GroupSW = customerViewModel.GroupSW;
c.Notes = customerViewModel.Notes;
c.Phone1 = customerViewModel.Phone1;
c.Phone2 = customerViewModel.Phone2;
c.PostalCode = customerViewModel.PostalCode;
c.RegionID = customerViewModel.RegionID;
c.ResponsibleID = customerViewModel.ResponsibleID;
c.ShortName = customerViewModel.ShortName;
c.UniformNumbers = customerViewModel.UniformNumbers;
//new
c.AddrNumber = customerViewModel.AddrNumber;
c.History = customerViewModel.History;
c.CreateDateTime = DateTime.Now;
c.ModifyDateTime = DateTime.Now;
//c.CreateUserID = customerViewModel.CreateUserID;
c.ModifyUserID = customerViewModel.ModifyUserID;
db.SaveChanges();
ret = true;
}
catch (DbUpdateConcurrencyException ex)
{
// Update the values of the entity that failed to save from the store
ex.Entries.Single().Reload();
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
return ret;
}
public bool Create(CustomerViewModel customerViewModel)
{
bool ret = false;
try
{
Customer c = new Customer();
c.CustomerRef = db.Customer.AsEnumerable().Select(x => x.CustomerRef).DefaultIfEmpty(0).Max(x => x) + 1;
c.Addr = customerViewModel.Addr;
c.BranchID = customerViewModel.BranchID;
c.ContactPersonName = customerViewModel.ContactPersonName;
c.ContactPersonPhone = customerViewModel.ContactPersonPhone;
c.CustomerID = customerViewModel.CustomerID;
c.CustomerStatus = customerViewModel.CustomerStatus;
c.Fax = customerViewModel.Fax;
c.FullName = customerViewModel.FullName;
c.GroupID = customerViewModel.GroupID;
c.GroupSW = customerViewModel.GroupSW;
c.Notes = customerViewModel.Notes;
c.Phone1 = customerViewModel.Phone1;
c.Phone2 = customerViewModel.Phone2;
c.PostalCode = customerViewModel.PostalCode;
c.RegionID = customerViewModel.RegionID;
c.ResponsibleID = customerViewModel.ResponsibleID;
c.ShortName = customerViewModel.ShortName;
c.UniformNumbers = customerViewModel.UniformNumbers;
//newsdata.UpdUserID = "AAA";
//newsdata.LastUpdDT = DateTime.Now;
//new
c.AddrNumber = customerViewModel.AddrNumber;
c.History = customerViewModel.History;
c.CreateDateTime = DateTime.Now;
c.ModifyDateTime = DateTime.Now;
c.CreateUserID = customerViewModel.CreateUserID;
c.ModifyUserID = customerViewModel.ModifyUserID;
db.Customer.Add(c);
db.SaveChanges();
//bulletinViewModel.SeqNo = bulletin.SeqNo;
ret = true;
}
catch
{
}
return ret;
}
public IQueryable<CustomerViewModel> Read()
{
List<CustomerViewModel> ret = new List<CustomerViewModel>();
var qry = db.Customer;
foreach (Customer o in qry)
{
CustomerViewModel c = new CustomerViewModel();
c.Addr = o.Addr;
c.BranchID = o.BranchID;
c.ContactPersonName = o.ContactPersonName;
c.ContactPersonPhone = o.ContactPersonPhone;
c.CustomerID = o.CustomerID;
c.CustomerRef = o.CustomerRef;
c.CustomerStatus = o.CustomerStatus;
if (c.CustomerStatus == "0")
c.CustomerStatusStr = "停用";
else if (c.CustomerStatus == "1")
c.CustomerStatusStr = "使用";
else if (c.CustomerStatus == "9")
c.CustomerStatusStr = "暫用";
c.Fax = o.Fax;
c.FullName = o.FullName;
c.GroupID = o.GroupID;
c.GroupSW = o.GroupSW;
c.Notes = o.Notes;
c.Phone1 = o.Phone1;
c.Phone2 = o.Phone2;
c.PostalCode = o.PostalCode;
c.RegionID = o.RegionID;
c.RegionIDStr = o.SubArea.Name;
c.ResponsibleID = o.ResponsibleID;
c.ShortName = o.ShortName;
c.UniformNumbers = o.UniformNumbers;
//new
c.AddrNumber = o.AddrNumber;
//c.CreateDT = o.CreateDateTime.Value;
c.CreateDTStr = "";
if (o.CreateDateTime != null) {
c.CreateDT = o.CreateDateTime.Value;
c.CreateDTStr = o.CreateDateTime.Value.ToString("yyyy/MM/dd HH:mm");
}
c.CreateUserID = o.CreateUserID;
if (o.CreateUserID != null)
c.CreateUserName = o.UserData.UserName;
c.History = o.History;
//c.ModifyDT = o.ModifyDateTime.Value;
c.ModifyDTStr = "";
if (o.ModifyDateTime != null) {
c.ModifyDT = o.ModifyDateTime.Value;
c.ModifyDTStr = o.ModifyDateTime.Value.ToString("yyyy/MM/dd HH:mm");
}
c.ModifyUserID = o.ModifyUserID;
if (o.ModifyUserID != null)
c.ModifyUserName = o.UserData1.UserName;
ret.Add(c);
}
return ret.AsQueryable();
}