public List <PTModuleSelectByID_Result> ModuleSelectByID(string IDmodule)
{
db = new Hartama_IOTEntities();
var res = db.PTModuleSelectByID(IDmodule).ToList();
return(res);
}
public List <PTModuleSelect_Result> ModuleSelect(string OrderBy, string Direction, int Limit, int Offset)
{
db = new Hartama_IOTEntities();
var res = db.PTModuleSelect(OrderBy, Direction, Limit, Offset).ToList();
return(res);
}
public List <PTRoleSelectByKeywordDiscontinue_Result> RoleSelectByKeywordDiscontinue(string OrderBy, string Direction, string Keyword, bool Discontinue, int Limit, int Offset)
{
db = new Hartama_IOTEntities();
var res = db.PTRoleSelectByKeywordDiscontinue(OrderBy, Direction, Keyword, Discontinue, Limit, Offset).ToList();
return(res);
}
public List <PTUserLogin_Result> TUserLogin(AuthModel Auth)
{
db = new Hartama_IOTEntities();
var res = db.PTUserLogin(Auth.userName, Auth.password).ToList();
return(res);
}
public List <GetCategoryDatatable_Result> GetCategory(string keyword, int limit, int offset)
{
db = new Hartama_IOTEntities();
var res = db.GetCategoryDatatable(limit, offset, keyword).ToList();
return(res);
}
public List <PTModuleSelectByKeyword_Result> ModuleSelectByKeyword(string keyword, int Limit, int Offset)
{
db = new Hartama_IOTEntities();
var res = db.PTModuleSelectByKeyword(keyword, Limit, Offset).ToList();
return(res);
}
public List <GETSENSORDetail_Result> GetSensorDetail(string id)
{
db = new Hartama_IOTEntities();
var res = db.GETSENSORDetail(id).ToList();
return(res);
}
public String ModuleDelete(TModuleModel mdl)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.PTModuleDelete(
mdl.IDModule,
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.LabelModule, retSplit[1]);
ret = "1";
}
else
{
ret = "Err|" + res.Pesan;
}
return(ret);
}
catch (Exception err)
{
return("Err|" + err.Message);
}
}
public List <PTIconSelectByKeywordIsDefault_Result> IconSelectByKeywordIsDefault(string orderBy, string dir, string keyword, bool?isDefault, int Limit, int Offset)
{
db = new Hartama_IOTEntities();
var res = db.PTIconSelectByKeywordIsDefault(orderBy, dir, keyword, isDefault, Limit, Offset).ToList();
return(res);
}
public List <PTIconSelectByID_Result> IconSelectById(string id)
{
db = new Hartama_IOTEntities();
var res = db.PTIconSelectByID(id).ToList();
return(res);
}
public List <PTIconSelectByKeyword_Result> IconSelect(string orderBy, string dir, string keyword)
{
db = new Hartama_IOTEntities();
var res = db.PTIconSelectByKeyword(orderBy, dir, keyword).ToList();
return(res);
}
public List <PTIconSelectLov_Result> IconSelectLov(string orderBy, string dir, string keyword, int Limit, int Offset)
{
db = new Hartama_IOTEntities();
var res = db.PTIconSelectLov(orderBy, dir, keyword, Limit, Offset).ToList();
return(res);
}
public List <PTFeatureSelectByIDFeatureIDModule_Result> FeatureSelectByIDFeatureIDModule(string IDFeature, string IDModule)
{
db = new Hartama_IOTEntities();
var res = db.PTFeatureSelectByIDFeatureIDModule(IDFeature, IDModule).ToList();
return(res);
}
public String ModuleUpdateSequence(string IDModule, string direction)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.PTModuleUpdateSequence(
IDModule, direction
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelModule, retSplit[1]);
ret = "1";
}
else
{
ret = "Err|" + res.Pesan;
ret = "0";
}
return(ret);
}
catch (Exception err)
{
return("Err|" + err.Message);
}
}
public ActionResult GetOptionValue()
{
Hartama_IOTEntities db = new Hartama_IOTEntities();
List <OptionModel> opt = new List <OptionModel>();
try
{
var ret = (from option in db.Options.Where(x => x.OptionsName == "SiteURL" || x.OptionsName == "CompanyAddress" || x.OptionsName == "CompanyName" || x.OptionsName == "CompanyPhone" || x.OptionsName == "LogoArray") select new { option.OptionsName, option.OptionsValue }).ToList();
for (var x = 0; x < ret.Count; x++)
{
OptionModel optm = new OptionModel();
if (ret[x].OptionsName == "LogoArray")
{
var image = Path.Combine(Server.MapPath("~/Images/"), ret[x].OptionsValue);
byte[] imgdata = System.IO.File.ReadAllBytes(image);
optm.OptionsName = ret[x].OptionsName;
optm.OptionsValue = Convert.ToBase64String(imgdata);
}
else
{
optm.OptionsName = ret[x].OptionsName;
optm.OptionsValue = ret[x].OptionsValue;
}
opt.Add(optm);
}
}
catch (Exception ex)
{
return(Json(new { result = ex.Message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = opt }, JsonRequestBehavior.AllowGet));
}
public List <GetDeviceBySiteDatatable_Result> GetDevice(string user, string keyword, int limit, int offset)
{
db = new Hartama_IOTEntities();
var res = db.GetDeviceBySiteDatatable(user, limit, offset, keyword).ToList();
return(res);
}
public List <GetSite_Result> GetSite(string keyword, int limit, int offset)
{
db = new Hartama_IOTEntities();
var res = db.GetSite(offset, limit, keyword).ToList();
return(res);
}
// GET: Report
public ActionResult ReportLog()
{
Hartama_IOTEntities db = new Hartama_IOTEntities();
var x = db.Options.Where(y => y.OptionsName == "SiteURL").FirstOrDefault();
var logo = db.Options.Where(y => y.OptionsName == "LogoArray").FirstOrDefault();
ViewBag.paramfile = x.OptionsValue;
ViewBag.Logo = logo.OptionsValue;
return(View());
}
public String ModuleInsert(TModuleModel mdl)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.PTModuleInsert(
mdl.ModuleCode,
mdl.ModuleName,
mdl.ModuleDesc,
mdl.UserEntry,
Convert.ToDateTime(mdl.DateEntry),
mdl.UserLastMaintenance,
Convert.ToDateTime(mdl.DateLastMaintenance),
mdl.Sequence,
mdl.IsDefault,
mdl.IDIcon
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelModule, retSplit[1]);
ret = "1";
}
else
{
ret = "Err|" + res.Pesan;
ret = "0";
}
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.LabelModule, ErrSplit[1]);
}
}
else
{
ErrMsg = err.InnerException.Message;
}
return("Err|" + ErrMsg);
}
}
public ActionResult UpdateOptions(OptionModel2 optm)
{
Hartama_IOTEntities db = new Hartama_IOTEntities();
try
{
if (optm.CompanyName != null || optm.CompanyName != "")
{
var ret = db.Options.Where(x => x.OptionsName == "CompanyName").FirstOrDefault();
OptionModel o = new OptionModel();
o.OptionsID = ret.OptionsID.ToString();
o.OptionsName = ret.OptionsName;
o.OptionsValue = optm.CompanyName;
var exe = opt.UpdateOption(o);
}
if (optm.CompanyAddress != null || optm.CompanyAddress != "")
{
var ret = db.Options.Where(x => x.OptionsName == "CompanyAddress").FirstOrDefault();
OptionModel o = new OptionModel();
o.OptionsID = ret.OptionsID.ToString();
o.OptionsName = ret.OptionsName;
o.OptionsValue = optm.CompanyAddress;
var exe = opt.UpdateOption(o);
}
if (optm.CompanyPhone != null || optm.CompanyPhone != "")
{
var ret = db.Options.Where(x => x.OptionsName == "CompanyPhone").FirstOrDefault();
OptionModel o = new OptionModel();
o.OptionsID = ret.OptionsID.ToString();
o.OptionsName = ret.OptionsName;
o.OptionsValue = optm.CompanyPhone;
var exe = opt.UpdateOption(o);
}
if (optm.ApiUri != null || optm.ApiUri != "")
{
var ret = db.Options.Where(x => x.OptionsName == "SiteURL").FirstOrDefault();
OptionModel o = new OptionModel();
o.OptionsID = ret.OptionsID.ToString();
o.OptionsName = ret.OptionsName;
o.OptionsValue = optm.ApiUri;
var exe = opt.UpdateOption(o);
}
}
catch (Exception e)
{
return(Json(new { result = e.Message }));
}
return(Json(new { result = "" }));
}
public string DeviceInsert(DeviceModel mdl)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.InsertDevice(
mdl.Device_Name,
mdl.Device_category_ID,
mdl.Device_Site_ID,
mdl.Device_Description,
mdl.UserEntry,
DateTime.Now.ToShortDateString(),
mdl.UserEntry,
DateTime.Now.ToShortDateString(),
mdl.UserEntry,
mdl.MacAddress1,
mdl.MacAddress2,
mdl.MacAddress3
).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 Dashboard_2()
{
if ((Session["UserName"] == null) || (Session["IDSite"] == null))
{
return(RedirectToAction("Index", "Login"));
}
Hartama_IOTEntities db = new Hartama_IOTEntities();
var res = db.Options.Where(x => x.OptionsName == "GapRefreshChart").FirstOrDefault();
ViewBag.Gap = res.OptionsValue;
//GetSiteList();
return(View());
}
public ActionResult Home()
{
if ((Session["UserName"] == null) || (Session["IDSite"] == null))
{
return(RedirectToAction("Index", "Login"));
}
ViewBag.Dashboard = "";
Hartama_IOTEntities db = new Hartama_IOTEntities();
var res = db.Options.Where(x => x.OptionsName == "SiteURL").FirstOrDefault();
ViewBag.SiteUrl = res.OptionsValue;
//GetSiteList();
return(View());
}
public string CategoryInsertorupdate(CategoryModel mdl)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.InsertCategory(
mdl.CategoryID,
mdl.CategoryName,
mdl.CategoryDescription,
mdl.UserEntry
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
//var retSplit = res.Pesan.Split('|');
//ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSite, retSplit[1]);
ret = res.Pesan;
}
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 UploadImage(string Company)
{
Hartama_IOTEntities db = new Hartama_IOTEntities();
// var ret;
try
{
foreach (string file in Request.Files)
{
var fileContent = Request.Files[file];
if (fileContent != null && fileContent.ContentLength > 0)
{
// get a stream
var stream = fileContent.InputStream;
// and optionally write the file to disk
var fileName = Path.GetFileName(fileContent.FileName);
var z = fileName.Split('.')[1];
var path = Path.Combine(Server.MapPath("~/Images/"), Company.Remove(' ') + "." + z);
using (var fileStream = System.IO.File.Create(path))
{
stream.CopyTo(fileStream);
}
var ret = db.Options.Where(x => x.OptionsName == "LogoArray").FirstOrDefault();
OptionModel optm = new OptionModel();
optm.OptionsID = ret.OptionsID.ToString();
optm.OptionsName = ret.OptionsName;
optm.OptionsValue = Company + "." + z;
var exe = opt.UpdateOption(optm);
}
}
}
catch (Exception e)
{
return(Json(new { result = e.Message }));
}
return(Json(new { result = "Success Upload Image" }));
}
public ActionResult writeReport(DateTime datestart, DateTime dateend, string filepath)
{
string ret = "";
Hartama_IOTEntities db = new Hartama_IOTEntities();
if (ModelState.IsValid)
{
try
{
var ss = db.InsertToLogTemp(filepath, Session["IDUser"].ToString(), datestart, dateend);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = "error" }));
}
}
return(Json(new { result = "OK" }));
}
public string createoreditsensorparamdetail(string idsensor, string idcategory, decimal lower, decimal upper, string user)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.CreateorEditSensor(
idsensor, idcategory, lower, upper, user
).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 string DeviceDelete(DeviceModel id)
{
try
{
db = new Hartama_IOTEntities();
string ret = "";
var res = db.DeleteDevice(id.Device_ID).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 create(ActionModel mdl)
{
var ret = "";
var user = Session["IDUser"].ToString();
int AffectedRows = 0;
Hartama_IOTEntities db = new Hartama_IOTEntities();
try
{
var count = db.TActions.Count() + 1;
var takeAction = db.Set <TAction>();
takeAction.Add(new TAction
{
Action_ID = "ACT" + count,
NotificationID = mdl.IDNotif,
ActionType = mdl.ActionType,
ActionDescription = mdl.ActionDescription,
UserEntry = user,
DateEntry = DateTime.Now
});
AffectedRows = db.SaveChanges();
if (AffectedRows > 0)
{
ret = "1";
}
else
{
ret = "Err|" + "Failed To Insert Data";
}
}
catch (Exception e)
{
ret = "Err|" + e.Message;
}
return(Json(new { result = ret }));
}
//Add By Irham for upadte last user login Site
//04-09-2015
public void UpdateTUserLastLogin(string IDUser, string IDSite)
{
db = new Hartama_IOTEntities();
db.PTUserUpdateLastLoginSite(IDUser, IDSite);
}
