public List <TFeatureAccessModel> RoleAccess(string path, string RoleID) { if (CWU.OpenConnection()) { sql = "SELECT a.[view], a.New, a.Edit,a.[Delete], a.Printable, c.PathApp, a.IDRole FROM TFeaturesAccess as a left join TModuleFeatures as b on b.IDModuleFeatures = a.IDModuleFeatures left join TFeatures as c on c.IDFeatures = b.IDFeatures where c.PathApp ='" + path + "' and a.IDRole = '" + RoleID + "'"; 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 Role = new TFeatureAccessModel(); //Employee.UserID = CWU.dtreader[0].ToString(); Role.BindView = CWU.dtreader[0].ToString(); Role.BindNew = CWU.dtreader[1].ToString(); Role.BindEdit = CWU.dtreader[2].ToString(); Role.BindDelete = CWU.dtreader[3].ToString(); //Role.BindDelete = CWU.dtreader[3].ToString(); Role.BindPrintable = CWU.dtreader[4].ToString(); // Employee.SiteCode = CWU.dtreader[5].ToString(); Role.PathApp = CWU.dtreader[5].ToString(); Role.IDRole = CWU.dtreader[6].ToString(); ModelFeature.Add(Role); } } CWU.dtreader.Close(); return(ModelFeature); }
public ActionResult Save(TFeatureAccessModel featureAccess) { //featureAccess.UserEntry = Session["IDUser"].ToString(); //featureAccess.DateEntry = DateTime.Today; //featureAccess.UserLastMaintenance = Session["IDUser"].ToString(); //featureAccess.DateLastMaintenance = DateTime.Today; //if (ModelState.IsValid) //{ // string ret = ""; // try // { // ret = roleAccess.SaveRoleAccess(featureAccess); // return Json(new { result = ret }); // } // catch (Exception err) // { // ret = "Err|" + err.Message; // return Json(new { result = ret }); // } //} //else //{ // return View(); // featureAccess.UserEntry = Session["IDUser"].ToString(); featureAccess.DateEntry = DateTime.Today; featureAccess.UserLastMaintenance = Session["IDUser"].ToString(); featureAccess.DateLastMaintenance = DateTime.Today; featureAccess.IDRole = Session["IDRole"].ToString(); if (ModelState.IsValid) { string ret = ""; try { ret = roleAccess.SaveRoleAccess(featureAccess); return(Json(new { result = ret })); } catch (Exception err) { ret = "Err|" + err.Message; return(Json(new { result = ret })); } } else { return(View()); } }
public string SaveRoleAccess(TFeatureAccessModel mdl) { string res = ""; try { CWU.OpenConnection(); sql = "[dbo].[PTFeatureAccessSave]"; CWU.command.CommandText = sql; CWU.command.Connection = CWU.connection; CWU.command.CommandType = System.Data.CommandType.StoredProcedure; CWU.command.Parameters.AddWithValue("@Visible", mdl.BindVisible); CWU.command.Parameters.AddWithValue("@View", mdl.BindView); CWU.command.Parameters.AddWithValue("@New", mdl.BindNew); CWU.command.Parameters.AddWithValue("@Edit", mdl.BindEdit); CWU.command.Parameters.AddWithValue("@Delete", mdl.BindDelete); CWU.command.Parameters.AddWithValue("@Printable", mdl.BindPrintable); CWU.command.Parameters.AddWithValue("@IDFeatureAccess", mdl.BindIDFeatureAccess); CWU.command.Parameters.AddWithValue("@Action", mdl.BindAction); CWU.command.Parameters.AddWithValue("@IDModuleFeatures", mdl.BindIDModuleFeatures); CWU.command.Parameters.AddWithValue("@UserEntry", mdl.UserEntry); CWU.command.Parameters.AddWithValue("@DateEntry", mdl.DateEntry); CWU.command.Parameters.AddWithValue("@UserLastMaintenance", mdl.UserLastMaintenance); CWU.command.Parameters.AddWithValue("@DateLastMaintenance", mdl.DateLastMaintenance); CWU.command.Parameters.AddWithValue("@IDRole", mdl.IDRole); int ret = CWU.command.ExecuteNonQuery(); res = "1|"; CWU.command.Connection.Close(); } catch (Exception err) { return(res = err.Message.ToString()); } return(res); }