public string IconDelete(TIconModel mdl)
{
try
{
string ret = "";
var res = db.PTIconDelete(
mdl.IDIcon,
mdl.UserLastMaintenance,
Convert.ToDateTime(mdl.DateLastMaintenance)
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.IconLabelIcon, retSplit[1]);
}
else
{
ret = "Err|" + res.Pesan;
}
return(ret);
}
catch (Exception err)
{
return("Err|" + err.InnerException.Message);
}
}
public ActionResult Delete(TIconModel mdl)
{
var CUI = Session["CurrentUICulture"].ToString();
DateTime DateEntry = Convert.ToDateTime(mdl.DateEntry, CultureInfo.CreateSpecificCulture(CUI));
mdl.DateEntry = DateEntry.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat);
mdl.UserLastMaintenance = Session["IDUser"].ToString();
mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat);
if (ModelState.IsValid)
{
string ret = "";
try
{
Icon = new TIconClass();
ret = Icon.IconDelete(mdl);
return(Json(new { result = ret }));
}
catch (Exception err)
{
ret = "Err|" + err.Message;
return(Json(new { result = ret }));
}
}
else
{
return(View(mdl));
}
}
public string IconInsert(TIconModel mdl)
{
try
{
string ret = "";
var res = db.PTIconInsert(
mdl.IconName,
mdl.IconDesc,
mdl.IconClass,
mdl.IconType,
mdl.IconPath,
mdl.IconCategory,
mdl.IsDefault,
mdl.UserEntry,
Convert.ToDateTime(mdl.DateEntry),
mdl.UserLastMaintenance,
Convert.ToDateTime(mdl.DateLastMaintenance)
).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.IconLabelIcon, retSplit[1]);
}
else
{
ret = "Err|" + res.Pesan;
}
return(ret);
}
catch (Exception err)
{
string ErrMsg = "";
if (err.GetType().Name == "EntityCommandExecutionException")
{
var SqlErr = err.InnerException as SqlException;
if (SqlErr.Number == 52627)
{
var ErrSplit = SqlErr.Message.Split('|');
ErrMsg = TranslateMessageClass.TranslateMessage(ErrSplit[0], Resources.Resource.LabelIcon, ErrSplit[1]);
}
}
else
{
ErrMsg = err.InnerException.Message;
}
return("Err|" + ErrMsg);
}
}
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Icon = new TIconClass();
var res = Icon.IconSelectById(id).FirstOrDefault();
if (res == null)
{
return(HttpNotFound());
}
TIconModel mdl = new TIconModel();
mdl.IDIcon = res.IDIcon;
mdl.IconName = res.IconName;
mdl.IconDesc = res.IconDesc;
mdl.IconClass = res.IconClass;
mdl.IconPath = res.IconPath;
mdl.IconCategory = res.IconCategory;
mdl.IconType = res.IconType;
mdl.IsDefault = res.IsDefault;
mdl.UserEntry = res.UserEntry;
mdl.DateEntry = ConvertDate.convert_date(res.DateEntry);
mdl.UserLastMaintenance = res.UserLastMaintenance;
mdl.DateLastMaintenance = ConvertDate.convert_date(res.DateLastMaintenance);
var IconType = new SelectList(new[]
{
new { ID = "Unicode", Name = "Unicode" },
new { ID = "Image", Name = "Image" },
},
"ID", "Name", mdl.IconType);
ViewData["Icon Type"] = IconType;
var IconCategory = new SelectList(new[]
{
new { ID = "TextEditor", Name = "TextEditor" },
new { ID = "Brand", Name = "Brand" },
new { ID = "Currency", Name = "Currency" },
},
"ID", "Name", mdl.IconCategory);
ViewData["Icon Category"] = IconCategory;
ViewBag.historyKeyword = Request["historyKeyword"];
ViewBag.historyisDefault = Request["historyisDefault"];
return(View(mdl));
}
public ActionResult Edit(TIconModel mdl)
{
var CUI = Session["CurrentUICulture"].ToString();
DateTime DateEntry = Convert.ToDateTime(mdl.DateEntry, CultureInfo.CreateSpecificCulture(CUI));
mdl.DateEntry = DateEntry.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat);
mdl.UserLastMaintenance = Session["IDUser"].ToString();
mdl.DateLastMaintenance = DateTime.Now.ToString(CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat);
int number = 0;
string random = "";
bool upload = false;
foreach (var fileKey in Request.Files.AllKeys)
{
var file = Request.Files[fileKey];
try
{
if (file != null)
{
var fileName = Path.GetFileNameWithoutExtension(file.FileName);
var extension = Path.GetExtension(file.FileName);
Random randomNumber = new Random();
while (upload == false)
{
for (var i = 0; i <= 5; i++)
{
number = randomNumber.Next(0, 9);
random += number.ToString();
}
var path = Path.Combine(Server.MapPath("~/Images/AssetImage"), fileName + random + extension);
if (!System.IO.File.Exists(path))
{
mdl.IconPath = "../Images/AssetImage/" + fileName + random + extension;
file.SaveAs(path);
upload = true;
}
}
}
}
catch (Exception)
{
return(Json(new { Message = "Error in saving file" }));
}
}
if (ModelState.IsValid)
{
string ret = "";
try
{
Icon = new TIconClass();
ret = Icon.IconUpdate(mdl);
return(Json(new { result = ret }));
}
catch (Exception err)
{
ret = "Err|" + err.Message;
return(Json(new { result = ret }));
}
}
else
{
return(View(mdl));
}
}
