public async Task <IActionResult> LanguageCreate(SuClassificationValueLanguageEditGetWitLanguageListModel FromForm)
{
SuUserModel CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@OId", FromForm.ClassificationValue.OId),
new SqlParameter("@LanguageId", FromForm.ClassificationValue.LanguageId),
new SqlParameter("@Name", FromForm.ClassificationValue.Name ?? ""),
new SqlParameter("@Description", FromForm.ClassificationValue.Description ?? ""),
new SqlParameter("@MouseOver", FromForm.ClassificationValue.MouseOver ?? ""),
new SqlParameter("@MenuName", FromForm.ClassificationValue.MenuName ?? ""),
new SqlParameter("@DropDownName", FromForm.ClassificationValue.PageName ?? ""),
new SqlParameter("@PageName", FromForm.ClassificationValue.PageDescription ?? ""),
new SqlParameter("@PageDescription", FromForm.ClassificationValue.HeaderName ?? ""),
new SqlParameter("@HeaderName", FromForm.ClassificationValue.HeaderDescription ?? ""),
new SqlParameter("@HeaderDescription", FromForm.ClassificationValue.TopicName ?? ""),
new SqlParameter("@ModifierId", CurrentUser.Id)
};
_context.Database.ExecuteSqlCommand("ClassificationValueLanguageCreatePost " +
"@OId" +
", @LanguageId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName" +
", @DropDownName" +
", @PageName" +
", @PageDescription" +
", @HeaderName" +
", @HeaderDescription" +
", @TopicName" +
", @ModifierId", parameters);
return(RedirectToAction("LanguageIndex", new { Id = FromForm.ClassificationValue.OId.ToString() }));
//if (ModelState.IsValid)
//{
// var ClassificationValueLanguage = new SuClassificationValueLanguageModel
// {
// Name = FromForm.SuObject.Name,
// Description = FromForm.SuObject.Description,
// DropDownName = FromForm.SuObject.DropDownName,
// MenuName = FromForm.SuObject.MenuName,
// MouseOver = FromForm.SuObject.MouseOver
// };
// ClassificationValueLanguage.MouseOver = FromForm.SuObject.MouseOver;
// ClassificationValueLanguage.PageDescription = FromForm.SuObject.PageDescription;
// ClassificationValueLanguage.HeaderName = FromForm.SuObject.HeaderName;
// ClassificationValueLanguage.HeaderDescription = FromForm.SuObject.HeaderDescription;
// ClassificationValueLanguage.TopicName = FromForm.SuObject.TopicName;
// ClassificationValueLanguage.ClassificationValueId = FromForm.SuObject.ObjectId;
// ClassificationValueLanguage.LanguageId = FromForm.SuObject.LanguageId;
// _classificationValueLanguage.AddClassificationValueLanguage(ClassificationValueLanguage);
//}
//return RedirectToAction("LanguageIndex", new { Id = FromForm.SuObject.ObjectId.ToString() });
}
public async Task <IActionResult> LanguageCreate(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 parameter = new SqlParameter("@Id", Id);
var LanguageList = _context.ZdbLanguageCreateGetLanguageList.FromSql("ClassificationValueLanguageCreateGetLanguageList @Id", parameter).ToList();
List <SelectListItem> LList = new List <SelectListItem>();
foreach (var Language in LanguageList)
{
LList.Add(new SelectListItem {
Value = Language.Value, Text = Language.Text
});
}
if (LList.Count() == 0)
{
return(RedirectToAction("LanguageIndex", new { Id }));
}
SuClassificationValueLanguageEditGetModel ClassificationValue = new SuClassificationValueLanguageEditGetModel
{
OId = Id
};
ViewBag.Id = Id.ToString();
var ClassificationValueAndStatus = new SuClassificationValueLanguageEditGetWitLanguageListModel
{
ClassificationValue = ClassificationValue
,
LanguageList = LList
};
return(View(ClassificationValueAndStatus));
//List<int> LanguagesAlready = new List<int>();
//LanguagesAlready = (from c in _classificationValueLanguage.GetAllClassificationValueLanguages()
// where c.ClassificationValueId == Id
// select c.LanguageId).ToList();
//var SuLanguage = (from l in _language.GetAllLanguages()
// where !LanguagesAlready.Contains(l.Id)
// && l.Active == true
// select new SelectListItem
// {
// Value = l.Id.ToString()
// ,
// Text = l.LanguageName
// }).ToList();
//if (SuLanguage.Count() == 0)
//{
// return RedirectToAction("LanguageIndex", new { Id });
//}
//SuObjectVM SuObject = new SuObjectVM
//{
// ObjectId = Id
//};
////------
//var xyz = _classificationValue.GetClassificationValue(Id);
//// ClassificationValue.NullId = xyz.ParentValueId;
//int Level = 1;
//var x = new SuClassificationValueModel();
//int? Parent = xyz.ParentValueId;
//while (Parent != null)
//{
// Level++;
// x = _classificationValue.GetClassificationValue(Parent ?? 0);
// Parent = x.ParentValueId;
//}
//// var ClassificationList = new List<SelectListItem>();
////string a;
////a = ToForm.Description;
////ClassificationValue.Level = Level;
//var ToForm = (from s in _classificationLevel.GetAllClassificationLevels()
// where s.ClassificationId == Convert.ToInt32(HttpContext.Request.Query["CId"]) && s.Sequence == Level
// select new SuObjectVM
// {
// DateLevel = s.DateLevel
// ,
// Alphabetically = s.Alphabetically
// ,
// InDropDown = s.InDropDown
// }).First();
////------
//ViewBag.Id = Id.ToString();
//var ClassificationAndStatus = new SuObjectAndStatusViewModel
//{
// SuObject = SuObject
// ,
// SomeKindINumSelectListItem = SuLanguage
//};
//ViewBag.ShowInDropDown = ToForm.InDropDown;
//return View(ClassificationAndStatus);
}
