public ActionResult Viewer(int ID = 0)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var item = db.DataViewers.Where(v => v.ID == ID).FirstOrDefault();
var nd = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
if (item != null && item.UserView != null && (item.UserView.Contains("*") || item.UserView.Contains(nd.StaffID)))
{
string tableName = item.TableEdit;
const string listUrl = "/TableEdittor/List?tablename={0}";
const string addUrl = "/TableEdittor/add?tablename={0}";
const string updateUrl = "/TableEdittor/update?tablename={0}";
const string deleteUrl = "/TableEdittor/delete?tablename={0}";
ViewBag.title += item.Name;
ViewBag.primaryKeyName = MasterTableDAL.GetPrimaryKey(tableName);
ViewBag.FieldData = MasterTableDAL.GetJsonFields(item.QueryData, item.TableEdit);
ViewBag.ListUrl = String.Format(listUrl, tableName);
ViewBag.AddUrl = String.Format(addUrl, tableName);
ViewBag.UpdateUrl = String.Format(updateUrl, tableName);
ViewBag.DeleteUrl = String.Format(deleteUrl, tableName);
return(View());
}
return(View("KHONG CO QUYEN"));
}
}
// GET: Default
public ActionResult Index()
{
const string listUrl = "/default/List?tablename={0}";
const string addUrl = "/default/add?tablename={0}";
const string updateUrl = "/default/update?tablename={0}";
const string deleteUrl = "/default/delete?tablename={0}";
string tableName = "mstr_Country";
ViewBag.primaryKeyName = MasterTableDAL.GetPrimaryKey(tableName);
ViewBag.FieldData = MasterTableDAL.GetJsonFields(tableName);
ViewBag.ListUrl = String.Format(listUrl, tableName);
ViewBag.AddUrl = String.Format(addUrl, tableName);
ViewBag.UpdateUrl = String.Format(updateUrl, tableName);
ViewBag.DeleteUrl = String.Format(deleteUrl, tableName);
//
return(View());
}
