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);
}
