public ActionResult Create(TFeatureModel mdl) { mdl.UserEntry = Session["IDUser"].ToString(); mdl.DateEntry = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.UserLastMaintenance = Session["IDUser"].ToString(); mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.IsExternal = true; if (ModelState.IsValid) { string ret = ""; try { Feature = new TFeatureClass(); ret = Feature.FeatureInsert(mdl); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } } else { return(View(mdl)); } }
public ActionResult Delete(TFeatureModel mdl) { var CUI = Session["CurrentUICulture"].ToString(); DateTime DateEntry = Convert.ToDateTime(mdl.DateEntry, CultureInfo.CreateSpecificCulture(CUI)); mdl.DateEntry = DateEntry.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); mdl.UserLastMaintenance = Session["IDUser"].ToString(); mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat); if (ModelState.IsValid) { string ret = ""; try { Feature = new TFeatureClass(); ret = Feature.FeatureDelete(mdl); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } } else { return(View(mdl)); } }
public ActionResult Create(string id) { TFeatureModel mdl = new TFeatureModel(); mdl.IDModule = id; return(View(mdl)); }
public ActionResult FeatureDuplicate(string IDModule, string IDFeature) { string ret = ""; try { TFeatureModel mdl = new TFeatureModel(); mdl.IDModule = IDModule; mdl.IDFeatures = IDFeature; var CUI = Session["CurrentUICulture"].ToString(); DateTime DateEntry = Convert.ToDateTime(mdl.DateEntry, CultureInfo.CreateSpecificCulture(CUI)); mdl.UserEntry = Session["IDUser"].ToString(); mdl.DateEntry = DateTime.Now.ToString(); mdl.UserLastMaintenance = Session["IDUser"].ToString(); mdl.DateLastMaintenance = DateTime.Now.ToString(); TFeatureClass Feature = new TFeatureClass(); ret = Feature.FeatureDuplicate(mdl); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } }
public String FeatureUpdateSequence(TFeatureModel mdl, string Dir) { try { string ret = ""; var res = db.PTFeatureUpdateSequence( mdl.IDModule, mdl.IDFeatures, Dir, mdl.FeaturesType ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { var retSplit = res.Pesan.Split('|'); ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.FeatureLabelFeature, retSplit[1]); ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { return("Err|" + err.InnerException.Message); } }
public String FeatureDuplicate(TFeatureModel mdl) { try { string ret = ""; var res = db.PTFeatureDuplicate( mdl.IDModule, mdl.IDFeatures, 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.FeatureLabelFeature, retSplit[1]); //ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { return("Err|" + err.InnerException.Message); } }
public String FeatureDelete(TFeatureModel mdl) { try { string ret = ""; var res = db.PTFeatureDelete( mdl.IDModule, mdl.IDFeatures, mdl.UserLastMaintenance, Convert.ToDateTime(mdl.DateLastMaintenance) ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { ret = res.Pesan; ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { return("Err|" + err.Message); } }
public ActionResult ModuleFeatureUpdateSequence(string IDModule, string IDFeature, string FeatureType, string direction) { string ret = ""; try { TFeatureModel mdl = new TFeatureModel(); mdl.IDModule = IDModule; mdl.IDFeatures = IDFeature; mdl.FeaturesType = FeatureType; Feature = new TFeatureClass(); ret = Feature.FeatureUpdateSequence(mdl, direction); return(Json(new { result = ret }, JsonRequestBehavior.AllowGet)); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret }, JsonRequestBehavior.AllowGet)); } }
public String FeatureUpdate(TFeatureModel mdl) { try { string ret = ""; var res = db.PTFeatureUpdate( mdl.IDFeatures, mdl.FeaturesCode, mdl.FeaturesName, mdl.FeaturesDesc, mdl.FeaturesType, mdl.FeaturesAction, mdl.IsExternal, mdl.PathApp, mdl.UserLastMaintenance, Convert.ToDateTime(mdl.DateLastMaintenance), mdl.IDIcon ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { var retSplit = res.Pesan.Split('|'); ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.FeatureLabelFeature, retSplit[1]); ret = "1"; } else { ret = "Err|" + res.Pesan; ret = "0"; } return(ret); } catch (Exception err) { return("Err|" + err.InnerException.Message); } }
public List <TFeatureModel> GetDataFeatureByModule(int Start, int Length, string IDModule) { int TR = 0; if (CWU.OpenConnection()) { sql = "SELECT count(*) FROM [dbo].[TModuleFeatures] a, [dbo].[TFeatures] b join [dbo].[TIcon] c on b.[IDIcon] = c.[IDIcon] where a.[IDFeatures] = b.[IDFeatures] and a.[IDModule] = '" + IDModule + "'"; CWU.command.CommandType = System.Data.CommandType.Text; CWU.command.CommandText = sql; CWU.command.Connection = CWU.connection; CWU.dtreader = CWU.command.ExecuteReader(); while (CWU.dtreader.Read()) { TR = Convert.ToInt32(CWU.dtreader[0]); } CWU.dtreader.Close(); sql = " SELECT a.[IDModuleFeatures] " + " ,a.[IDModule] " + " ,a.[IDFeatures] " + " ,b.[FeaturesCode] " + " ,b.[FeaturesName] " + " ,b.[FeaturesDesc] " + " ,b.[FeaturesType] " + " ,b.[FeaturesAction] " + " ,b.[IsExternal] " + " ,b.[PathApp] " + " ,a.[Sequence] " + " ,g.[Username] " + " ,a.[DateEntry] " + " ,h.[Username] " + " ,a.[DateLastMaintenance] " + " ,'10' as TotalRecords " + " ,c.IconName " + " ,c.IconClass " + " ,c.IDIcon " + " FROM [dbo].[TModuleFeatures] a left JOIN [dbo].[TUser] g ON a.[UserEntry] = g.[IDUser] left JOIN [dbo].[TUser] h ON a.[UserLastMaintenance] = h.[IDUser], [dbo].[TFeatures] b " + " join [dbo].[TIcon] c on b.[IDIcon] = c.[IDIcon] " + " where a.[IDFeatures] = b.[IDFeatures] " + " and a.[IDModule] = '" + IDModule + "' " + " order by " + " b.FeaturesType, a.Sequence OFFSET " + Start + " ROWS FETCH NEXT " + Length + " ROWS ONLY;"; CWU.command.CommandType = System.Data.CommandType.Text; CWU.command.CommandText = sql; CWU.command.Connection = CWU.connection; CWU.dtreader = CWU.command.ExecuteReader(); while (CWU.dtreader.Read()) { var x = new TFeatureModel(); x.IDModuleFeatures = CWU.dtreader[0].ToString(); x.IDModule = CWU.dtreader[1].ToString(); x.IDFeatures = CWU.dtreader[2].ToString(); x.FeaturesCode = CWU.dtreader[3].ToString(); x.FeaturesName = CWU.dtreader[4].ToString(); x.FeaturesDesc = CWU.dtreader[5].ToString(); x.FeaturesType = CWU.dtreader[6].ToString(); x.FeaturesAction = CWU.dtreader[7].ToString(); x.IsExternal = Convert.ToBoolean(CWU.dtreader[8].ToString()); x.PathApp = CWU.dtreader[9].ToString(); x.Sequence = Convert.ToInt16(CWU.dtreader[10].ToString()); x.UserEntry = CWU.dtreader[11].ToString(); x.DateEntry = CWU.dtreader[12].ToString(); x.UserLastMaintenance = CWU.dtreader[13].ToString(); x.DateLastMaintenance = CWU.dtreader[14].ToString(); x.TotalRecord = Convert.ToInt32(CWU.dtreader[15]); x.IconName = CWU.dtreader[16].ToString(); x.IconClass = CWU.dtreader[17].ToString(); x.IDIcon = CWU.dtreader[18].ToString(); ModelFeature.Add(x); } } CWU.dtreader.Close(); CWU.command.Connection.Close(); return(ModelFeature); }