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")); } }
public ActionResult Add(string tableName) { Dictionary <string, string> ColumnList = MasterTableDAL.GetColumns(tableName); List <ColumnFieldValue> columnFieldValueList = new List <ColumnFieldValue>(); foreach (var item in ColumnList) { if (item.Key == ColumnList.FirstOrDefault().Key) { continue; } foreach (string key in Request.Form.AllKeys) { var newkey = key.Replace("values", "").Replace("[", "").Replace("]", "").ToLower(); if (newkey == item.Key.ToLower()) { var columnFieldValue = new ColumnFieldValue(); columnFieldValue.ColumnName = item.Key; columnFieldValue.ColumnValue = Request.Form[key]; columnFieldValue.ColumnType = item.Value; columnFieldValueList.Add(columnFieldValue); } } } //create column string string strColumns = String.Join(",", columnFieldValueList.Select(x => x.ColumnName)); string strValues = "N'" + String.Join("',N'", columnFieldValueList.Select(V => V.ColumnValue)) + "'"; string jsonResult = MasterTableDAL.AddRecord(tableName, strColumns, strValues); return(JsonMax("OK")); }
public ActionResult List(string tableName) { var records = MasterTableDAL.GetListOfRecords(tableName); var json = ToJson(records); return(JsonMax(json)); }
public ActionResult Delete(string tableName) { string primaryKey = MasterTableDAL.GetPrimaryKey(tableName); MasterTableDAL.DeleteRecord(tableName, primaryKey, Request.Form["key"]); return(Content("{\"Result\":\"OK\"}", "application/json")); }
public ActionResult List(string tableName) { using (Models.Planner2Entities db = new Models.Planner2Entities()) { var item = db.DataViewers.Where(v => v.TableEdit == tableName).FirstOrDefault(); var records = MasterTableDAL.GetListOfRecords(item.QueryData); var json = ToJson(records); return(JsonMax(json)); } }
public ActionResult Update(string tableName) { Dictionary <string, string> ColumnList = MasterTableDAL.GetColumns(tableName); List <ColumnFieldValue> columnFieldValueList = new List <ColumnFieldValue>(); var primaryKeyName = MasterTableDAL.GetPrimaryKey(tableName); foreach (var item in ColumnList) { foreach (string key in Request.Form.AllKeys) { var newkey = key.Replace("values", "").Replace("[", "").Replace("]", "").ToLower(); if (newkey == item.Key.ToLower() && newkey != primaryKeyName.ToLower()) { var columnFieldValue = new ColumnFieldValue(); columnFieldValue.ColumnName = item.Key; columnFieldValue.ColumnValue = Request.Form[key]; columnFieldValue.ColumnType = item.Value; columnFieldValueList.Add(columnFieldValue); } } } //create column string string strColumnUpdate = ""; foreach (var column in columnFieldValueList) { switch (column.ColumnType) { case "System.Int64": case "System.Int32": case "System.Boolean": strColumnUpdate = strColumnUpdate + column.ColumnName + "=" + column.ColumnValue + ","; break; case "System.String": case "System.DateTime": strColumnUpdate = strColumnUpdate + column.ColumnName + "='" + column.ColumnValue + "',"; break; } } strColumnUpdate = strColumnUpdate.TrimEnd(','); //audit fields strColumnUpdate = strColumnUpdate + " WHERE " + primaryKeyName + " = " + Request.Form["key"]; MasterTableDAL.UpdateRecord(tableName, strColumnUpdate); return(Content("{\"Result\":\"OK\"}", "application/json")); }
// 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()); }
public ActionResult Add() { string tableName = ""; if (!String.IsNullOrEmpty(Request.QueryString["tableName"])) { tableName = Request.QueryString["tableName"]; } //we will be receiving all values in form variables. Dictionary <string, string> ColumnList = MasterTableDAL.GetColumns(tableName); List <ColumnFieldValue> columnFieldValueList = new List <ColumnFieldValue>(); foreach (var item in ColumnList) { if (item.Key == ColumnList.FirstOrDefault().Key) { continue; } foreach (string key in Request.Form.AllKeys) { if (key.Replace("values", "").Replace("[", "").Replace("]", "").ToLower() == item.Key.ToLower()) { var columnFieldValue = new ColumnFieldValue(); columnFieldValue.ColumnName = item.Key; columnFieldValue.ColumnValue = Request.Form[key]; columnFieldValue.ColumnType = item.Value; columnFieldValueList.Add(columnFieldValue); } } } //create column string string strColumns = String.Join(",", columnFieldValueList.Select(x => x.ColumnName)); string strValues = "'" + String.Join("',N'", columnFieldValueList.Select(V => V.ColumnValue)) + "'"; string jsonResult = MasterTableDAL.AddRecord(tableName, strColumns, strValues); return(JsonMax("OK")); }