/* Add by Irham 24 agustus 2015 for Update Site User*/
public String SiteUserSave(string IDSite, string ValueList, TSiteModel mdl)
{
try
{
string ret = "";
var res = db.PTSiteUserSave(
IDSite,
ValueList,
mdl.UserEntry,
Convert.ToDateTime(mdl.DateEntry),
mdl.UserLastMaintenance,
Convert.ToDateTime(mdl.DateLastMaintenance)
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSiteUser, retSplit[1]);
}
else
{
ret = "Err|" + res.Pesan;
}
return(ret);
}
catch (Exception err)
{
return("Err|" + err.InnerException.Message);
}
}
public string SiteDelete(TSiteModel mdl)
{
try
{
string ret = "";
var res = db.PTSiteDelete(
mdl.IDSite,
mdl.UserLastMaintenance,
DateTime.Now
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = "1";//0TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSite, retSplit[1]);
}
else
{
ret = "Err|" + res.Pesan;
}
return(ret);
}
catch (Exception err)
{
return("Err|" + err.InnerException.Message);
}
}
public string SiteUpdate(TSiteModel mdl)
{
try
{
string ret = "";
var res = db.PTSiteUpdate(
mdl.IDSite,
mdl.SiteName,
mdl.Address,
mdl.PostCode,
mdl.TelephoneNo,
mdl.FaxNo,
mdl.Email,
mdl.PICSite,
mdl.UserLastMaintenance,
DateTime.Now,
mdl.Discontinue,
mdl.SiteLogo,
0
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
//var retSplit = res.Pesan.Split('|');
//ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSite, retSplit[1]);
ret = "1";
}
else
{
ret = res.Pesan;
}
return(ret);
}
catch (Exception err)
{
string ErrMsg = "";
if (err.GetType().Name == "EntityCommandExecutionException")
{
var SqlErr = err.InnerException as SqlException;
if (SqlErr.Number == 52627)
{
var ErrSplit = SqlErr.Message.Split('|');
ErrMsg = TranslateMessageClass.TranslateMessage(ErrSplit[0], Resources.Resource.LabelSite, ErrSplit[1]);
}
}
else
{
ErrMsg = err.InnerException.Message;
}
return(ErrMsg);
}
}
public ActionResult Edit(TSiteModel upd)
{
upd.UserLastMaintenance = Session["IDUser"].ToString();
string ret = "";
if (ModelState.IsValid)
{
try
{
ret = BC.SiteUpdate(upd);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = ret }));
}
}
return(Json(new { result = ret }));
}
public ActionResult Delete(TSiteModel del)
{
if (ModelState.IsValid) //untuk check apakah value yang akan di inputkan ke model valid atau tidak
{
var ret = "";
try
{
ret = BC.SiteDelete(del);
return(Json(new { result = ret }));
}
catch (Exception err)
{
ret = "Err|" + err.Message;
return(Json(new { result = ret }));
}
}
else //jika tidak maka akan di return kembali ke view
{
return(View(del));
}
}
public ActionResult Create(TSiteModel ins)
{
string ret = "";
ins.UserEntry = Session["IDUser"].ToString();
// ins.SiteCode = Session["IDSite"].ToString();
if (ModelState.IsValid)
{
try
{
// ret = EMC.EmployeeInsert(ins, IsActive);
ret = BC.SiteInsert(ins);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = ret }));
}
}
return(Json(new { result = ret }));
}
public ActionResult GetSiteByID(string idSite)
{
List <TSiteModel> mm1 = new List <TSiteModel>();
mdl = new TSiteModel();
try
{
var res = BC.SiteSelectByID(idSite.Trim());
if (res.Count > 0)
{
mdl.IDSite = res[0].IDSite;
mdl.SiteName = res[0].SiteName;
mdl.Address = res[0].Address;
mdl.PostCode = res[0].PostCode;
mdl.TelephoneNo = res[0].TelephoneNo;
mdl.FaxNo = res[0].FaxNo;
mdl.Email = res[0].Email;
mdl.PICSite = res[0].PICSite;
mdl.UserEntry = res[0].UserEntry;
mdl.UserLastMaintenance = res[0].UserLastMaintenance;
mdl.DateEntry = res[0].DateEntry.ToShortDateString();
mdl.DateLastMaintenance = res[0].DateLastMaintenance.Value.ToShortDateString();
mdl.Discontinue = res[0].Discontinue.GetValueOrDefault(false);
}
mm1.Add(mdl);
}
catch (Exception err)
{
}
return(Json(new
{
Data = mm1.ToList()
}, JsonRequestBehavior.AllowGet));
//return mm1.ToList();
}
