public async Task <IActionResult> Edit(SuProcessTemplateFieldEditGetWithListModel FromForm)
{
if (ModelState.IsValid)
{
var CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@Id", FromForm.ProcessTemplateField.OId),
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId),
new SqlParameter("@ProcessTemplateFieldTypeId", FromForm.ProcessTemplateField.ProcessTemplateFieldTypeId),
new SqlParameter("@ModifierId", CurrentUser.Id),
new SqlParameter("@Name", FromForm.ProcessTemplateField.Name),
new SqlParameter("@Description", FromForm.ProcessTemplateField.Description),
new SqlParameter("@MouseOver", FromForm.ProcessTemplateField.MouseOver),
new SqlParameter("@MenuName", FromForm.ProcessTemplateField.MenuName)
};
_context.Database.ExecuteSqlCommand("ProcessTemplateFieldEditPost " +
"@Id" +
", @LanguageId" +
", @ProcessTemplateFieldTypeId" +
", @ModifierId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName", parameters);
}
return(RedirectToAction("Index", new { Id = FromForm.ProcessTemplateField.PId.ToString() }));
}
public async Task <IActionResult> Create(SuProcessTemplateFieldEditGetWithListModel FromForm)
{
if (ModelState.IsValid)
{
var CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@PId", FromForm.ProcessTemplateField.PId),
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId),
new SqlParameter("@ProcessTemplateFieldTypeId", FromForm.ProcessTemplateField.ProcessTemplateFieldTypeId),
new SqlParameter("@ModifierId", CurrentUser.Id),
new SqlParameter("@Name", FromForm.ProcessTemplateField.Name),
new SqlParameter("@Description", FromForm.ProcessTemplateField.Description),
new SqlParameter("@MouseOver", FromForm.ProcessTemplateField.MouseOver),
new SqlParameter("@MenuName", FromForm.ProcessTemplateField.MenuName)
};
_context.Database.ExecuteSqlCommand("ProcessTemplateFieldCreatePost " +
"@PId" +
", @LanguageId" +
", @ProcessTemplateFieldTypeId" +
", @ModifierId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName", parameters);
}
return(RedirectToAction("Index", new { Id = FromForm.ProcessTemplateField.PId.ToString() }));
// return RedirectToAction("Index");
// var CurrentUser = await _userManager.GetUserAsync(User);
//
// SqlParameter[] parameters =
//{
// new SqlParameter("@ProcessTemplateId", FromForm.Field.Id)
// , new SqlParameter("@FieldDataTypeId", FromForm.Field.NotNullId)
// , new SqlParameter("@FieldMasterListId", FromForm.Field.NotNullId2)
// , new SqlParameter("@LanguageId", FromForm.Field.LanguageId)
// , new SqlParameter("@Name", FromForm.Field.Name)
// , new SqlParameter("@Description", FromForm.Field.Description)
// , new SqlParameter("@MouseOver", FromForm.Field.MouseOver)
// };
// _context.Database.ExecuteSqlCommand("ProcessTemplateFieldCreate @ProcessTemplateId, @FieldDataTypeId, @FieldMasterListId, @LanguageId, @Name, @Description, @MouseOver", parameters);
}
public async Task <IActionResult> Create(int Id)
{
var CurrentUser = await _userManager.GetUserAsync(User);
var DefaultLanguageID = CurrentUser.DefaultLanguageId;
var UICustomizationArray = new UICustomization(_context);
ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID);
Menus a = new Menus(_context);
ViewBag.menuItems = await a.TopMenu(DefaultLanguageID);
var FieldTypeList = new List <SelectListItem>();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var FieldTypesFromDb = _context.ZDbTypeList.FromSql("ContentTypeSelectAllForLanguage @LanguageId", parameter).ToList();
foreach (var FieldTypeFromDb in FieldTypesFromDb)
{
FieldTypeList.Add(new SelectListItem
{
Text = FieldTypeFromDb.Name,
Value = FieldTypeFromDb.Id.ToString()
});
}
SuProcessTemplateFieldEditGetModel ProcessTemplateFieldEditGet = new SuProcessTemplateFieldEditGetModel
{
PId = Id
};
SuProcessTemplateFieldEditGetWithListModel ProcessTemplateFieldWithList = new SuProcessTemplateFieldEditGetWithListModel
{
ProcessTemplateField = ProcessTemplateFieldEditGet,
FieldTypeList = FieldTypeList
};
return(View(ProcessTemplateFieldWithList));
//var ProcessTemplateField = new SuObjectVM
//{
// Id = Id
// ,
// LanguageId = DefaultLanguageID
//};
////DataTypes
//var DataTypeList = new List<SelectListItem>();
//var DataTypesFromDb = _context.ZDbStatusList.FromSql("DataTypeSelectAll").ToList();
//foreach (var DataTypeFromDb in DataTypesFromDb)
//{
// DataTypeList.Add(new SelectListItem
// {
// Text = DataTypeFromDb.Name,
// Value = DataTypeFromDb.Id.ToString()
// });
//}
////ContentType
////MasterList
//var MasterListList = new List<SelectListItem>();
//var MasterListsFromDb = _context.ZDbTypeList.FromSql("GetMasterList").ToList();
//foreach (var MasterListFromDb in MasterListsFromDb)
//{
// MasterListList.Add(new SelectListItem
// {
// Text = MasterListFromDb.Name,
// Value = MasterListFromDb.Id.ToString()
// });
//}
////MasterList
//var FieldsAndDropDowns = new SuProcessTemplateFieldWith2DropDown { Field = ProcessTemplateField, DataTypes = DataTypeList, MasterList = MasterListList };
//return View(FieldsAndDropDowns);
}
public async Task <IActionResult> Edit(int Id)
{
var CurrentUser = await _userManager.GetUserAsync(User);
var DefaultLanguageID = CurrentUser.DefaultLanguageId;
var UICustomizationArray = new UICustomization(_context);
ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID);
Menus a = new Menus(_context);
ViewBag.menuItems = await a.TopMenu(DefaultLanguageID);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@OId", Id)
};
SuProcessTemplateFieldEditGetModel ProcessTemplateFieldEditGet = _context.ZdbSuProcessTemplateFieldEditGet.FromSql("ProcessTemplateFieldEditGet @LanguageId, @OId", parameters).First();
var FieldTypeList = new List <SelectListItem>();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var FieldTypesFromDb = _context.ZDbTypeList.FromSql("ContentTypeSelectAllForLanguage @LanguageId", parameter).ToList();
foreach (var FieldTypeFromDb in FieldTypesFromDb)
{
FieldTypeList.Add(new SelectListItem
{
Text = FieldTypeFromDb.Name,
Value = FieldTypeFromDb.Id.ToString()
});
}
SuProcessTemplateFieldEditGetWithListModel ProcessTemplateFieldWithList = new SuProcessTemplateFieldEditGetWithListModel
{
ProcessTemplateField = ProcessTemplateFieldEditGet,
FieldTypeList = FieldTypeList
};
return(View(ProcessTemplateFieldWithList));
//var ProcessTemplateField = (from c in _processTemplateField.GetAllProcessTemplateFields()
// join l in _processTemplateFieldLanguage.GetAllProcessTemplateFieldLanguages()
// on c.Id equals l.ProcessTemplateFieldId
// where c.Id == Id && l.LanguageId == DefaultLanguageID
// orderby l.Name
// select new SuObjectVM
// {
// Id = c.ProcessTemplateId
// ,
// ObjectId = c.Id
// ,
// LanguageId = l.LanguageId
// ,
// ObjectLanguageId = l.Id
// ,
// Name = l.Name
// ,
// Description = l.Description
// ,
// MouseOver = l.MouseOver
// , NotNullId = c.FieldDataTypeId
// , NotNullId2 = c.FieldMasterListId
// }).First();
////DataTypes
//var DataTypeList = new List<SelectListItem>();
//var DataTypesFromDb = _context.ZDbStatusList.FromSql("DataTypeSelectAll").ToList();
//foreach (var DataTypeFromDb in DataTypesFromDb)
//{
// DataTypeList.Add(new SelectListItem
// {
// Text = DataTypeFromDb.Name,
// Value = DataTypeFromDb.Id.ToString()
// });
//}
////ContentType
////MasterList
//var MasterListList = new List<SelectListItem>();
//var MasterListsFromDb = _context.ZDbTypeList.FromSql("GetMasterList").ToList();
//foreach (var MasterListFromDb in MasterListsFromDb)
//{
// MasterListList.Add(new SelectListItem
// {
// Text = MasterListFromDb.Name,
// Value = MasterListFromDb.Id.ToString()
// });
//}
////MasterList
//var FieldsAndDropDowns = new SuProcessTemplateFieldWith2DropDown { Field = ProcessTemplateField, DataTypes = DataTypeList, MasterList = MasterListList } ;
//return View(FieldsAndDropDowns);
}
