public ActionResult CreateUser(mUser user)
{
user.LastDateLoggedIn = DateTime.Now;
user.Customer_Flag = true;
user.Is_Deleted = false;
user.Create_Date = DateTime.Now;
user.Create_User = user.UserID;
user.Update_Date = DateTime.Now;
user.Update_User = user.UserID;
user.Password = EncodePasswordMd5(user.Password);
mSite checker = (from c in db.mSites
where c.SiteName == user.UserID && c.Is_Deleted == false
select c).FirstOrDefault();
if (checker == null)
{
try
{
db.mUsers.Add(user);
db.SaveChanges();
}
catch (Exception err) { }
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditSite(mSite site)
{
try
{
mSite sites = new mSite();
sites = (from u in db.mSites.ToList()
where u.SiteCode == site.SiteCode
select u).FirstOrDefault();
sites.SiteName = site.SiteName;
sites.Address = site.Address;
site.Update_User = "******";
site.Update_Date = DateTime.Now;
mSite checker = (from c in db.mSites
where c.SiteName == site.SiteName &&
c.Address == site.Address &&
c.Is_Deleted == false &&
c.SiteCode != site.SiteCode
select c).FirstOrDefault();
if (checker == null)
{
db.Entry(sites).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception err) { }
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteSite(string SiteCode)
{
mSite site = new mSite();
site = (from u in db.mSites.ToList()
where u.SiteCode == SiteCode
select u).FirstOrDefault();
site.Is_Deleted = true;
site.Update_Date = DateTime.Now;
site.Update_User = user.UserID;
db.Entry(site).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateSite(mSite site)
{
string gencode = string.Empty;
string lastgencode = (from u in db.mSites.ToList()
orderby u.SiteCode descending
select u.SiteCode).FirstOrDefault();
if (lastgencode == null)
{
gencode = "STS0001";
}
else
{
gencode = lastgencode.Substring(3);
int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1;
gencode = string.Format("STS{0}", upId.ToString().PadLeft(4, '0'));
}
site.SiteCode = gencode;
site.Is_Deleted = false;
site.Create_Date = DateTime.Now;
site.Create_User = user.UserID;
site.Update_Date = DateTime.Now;
site.Update_User = user.UserID;
mSite checker = (from c in db.mSites
where c.SiteName == site.SiteName &&
c.Address == site.Address &&
c.Is_Deleted == false
select c).FirstOrDefault();
if (checker == null)
{
try
{
db.mSites.Add(site);
db.SaveChanges();
}
catch (Exception err) { }
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
