public IActionResult UploadImageData(TblAppImageDataTemp tblAppImageDataTemp) { if (ModelState.IsValid) { TblAppImageData exist = db.TblAppImageData.Where(w => w.MenuId == tblAppImageDataTemp.MenuId && w.MenuLevel == tblAppImageDataTemp.MenuLevel).FirstOrDefault(); int count = db.TblAppImageData.Count(), x = 0; if (exist == null) { TblAppImageData imageData = new TblAppImageData { ImageDataId = count + 1, MenuId = tblAppImageDataTemp.MenuId, MenuLevel = tblAppImageDataTemp.MenuLevel, //ImageTitle = tblAppImageDataTemp.ImageTitle.ToCharArray(), ImageBlob = Convert.FromBase64String(ConvertImageToBase64(tblAppImageDataTemp.Image)) }; if (imageData != null) { db.TblAppImageData.Add(imageData); x = db.SaveChanges(); ViewBag.Result = x > 0 ? "success" : "failed"; } else { ViewBag.Result = "failed"; } } else { exist.ImageBlob = Convert.FromBase64String(ConvertImageToBase64(tblAppImageDataTemp.Image)); db.Entry(exist).State = EntityState.Modified; x = db.SaveChanges(); ViewBag.Result = x > 0 ? "updated" : "update failed"; } } return(View()); }
public string SendFeedback(string user_name, string phone_no, string user_email, string user_comment) { string result = string.Empty; TblUserComments tblUserComments = new TblUserComments(); try { if (!string.IsNullOrEmpty(user_name)) { tblUserComments.UserName = user_name; tblUserComments.UserPhone = phone_no; tblUserComments.UserEmailAddress = user_email; tblUserComments.UserComments = user_comment; if (tblUserComments != null) { db.TblUserComments.Add(tblUserComments); int x = db.SaveChanges(); result = x > 0 ? "success" : "failed"; } else { result = "failed"; } } else { result = "failed"; } } catch (Exception ex) { result = ex.Message; } return(result); }