public ActionResult ActionCreate(SBH_TM_GALERY_FOTO galeryView) { string a = Request.Form["storeImage"]; try { string encodedString = Server.HtmlEncode(galeryView.DESCRIPTION); galeryView.DESCRIPTION = encodedString; galeryView.USER_ID = (int)Session["Id"]; galeryView.CREATED_BY = Session["UserId"].ToString(); galeryView.CREATED_TIME = DateTime.Now; List <string> lString = CData.GetListString; rs = repo.AddAll(galeryView, lString); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been created successfully"); TempData["msgSuccess"] = rs.MessageText; CData.CleanDataString(); } else { rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionEdit(TOURIS_TV_CITY cityView) { try { cityView.LAST_MODIFIED_BY = CurrentUser.GetCurrentUserId(); cityView.LAST_MODIFIED_TIME = CurrentUser.GetCurrentDateTime(); rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(cityView, "City", "Edit", EnumList.IHttpMethod.Post.ToString())); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been edited successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionEdit(TOURIS_TV_COUNTRY countryView) { ResultStatus rs = new ResultStatus(); try { countryView.LAST_MODIFIED_BY = CurrentUser.GetCurrentUserId(); countryView.LAST_MODIFIED_TIME = CurrentUser.GetCurrentDateTime(); rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.JsonData(countryView, "Country", "EditObjCountry")); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been edited successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ResultStatus ChangePassword(int id, string oldPassword, string newPassword) { ResultStatus rs = new ResultStatus(); try { SBH_TM_USER_ADMIN user = _ctx.SBH_TM_USER_ADMIN.Find(id); if (user.PASSWORD == oldPassword) { user.LAST_MODIFIED_TIME = DateTime.Now; user.LAST_MODIFIED_BY = user.USER_NAME; user.PASSWORD = newPassword; _ctx.Entry(user).State = EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus("Change password has been success"); } else if (user.PASSWORD == newPassword) { rs.SetErrorStatus("New password can not be same old password"); } else { rs.SetErrorStatus("Old password is not match"); } } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public IHttpActionResult Delete(int id) { ApiResData res = new ApiResData(); try { if (!ModelState.IsValid) { rs.SetErrorStatus(eFunc.fg.SFailed); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, new Exception(eFunc.fg.DataNf))); return(Content(HttpStatusCode.NotFound, resObj)); } rs = repo.Delete(id, "System", CurrentUser.GetCurrentDateTime()); if (rs.IsSuccess) { rs.SetSuccessStatus(); } else { rs.SetErrorStatus(eFunc.fg.SFailed); } resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, null)); return(Content(HttpStatusCode.OK, resObj)); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, new Exception(eFunc.fg.DFailed))); return(Content(HttpStatusCode.BadRequest, resObj)); } }
public ActionResult ActionDelete(TOURIS_TV_COUNTRY countryView) { ResultStatus rs = new ResultStatus(); try { rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.JsonData(countryView, "Country", "DeleteObjCountry")); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been deleted successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionDelete(int id) { try { rs = repo.Delete(id, Session["UserId"].ToString(), DateTime.Now); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been deleted successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionDelete(int id) { try { rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(id, "City", "Delete", EnumList.IHttpMethod.Put.ToString())); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been deleted successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to deleted"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionEdit(SBH_TM_GALERY_FOTO galeryView, HttpPostedFileBase postedFile) { try { string encodedString = Server.HtmlEncode(galeryView.DESCRIPTION); galeryView.DESCRIPTION = encodedString; galeryView.LAST_MODIFIED_BY = Session["UserId"].ToString(); galeryView.LAST_MODIFIED_TIME = DateTime.Now; rs = repo.Edit(galeryView); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been edited successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionCreate(TOURIS_TV_MENU menuView) { try { menuView.CREATED_BY = CurrentUser.GetCurrentUserId(); menuView.CREATED_TIME = CurrentUser.GetCurrentDateTime(); rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(menuView, "Menu", "Add", EnumList.IHttpMethod.Post.ToString())); if (rs.IsSuccess) { rs.SetSuccessStatus("Data has been created successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ActionResult ActionEdit(TOURIS_TV_USER userView, HttpPostedFileBase postedFile) { try { string physicalPath = ""; TOURIS_TV_USER_PROFILE userProfileView = new TOURIS_TV_USER_PROFILE(); if (postedFile != null) { string ImageName = System.IO.Path.GetFileName(postedFile.FileName); //file2 to store path and url physicalPath = Server.MapPath("~" + Common.GetPathFolderImg() + ImageName); userView.PHOTO_PATH = Common.GetPathFolderImg() + ImageName; userProfileView.PHOTO_PATH = userView.PHOTO_PATH; } userView.LAST_MODIFIED_BY = CurrentUser.GetCurrentUserId(); userView.LAST_MODIFIED_TIME = CurrentUser.GetCurrentDateTime(); userProfileView.GENDER = userView.GENDER; userProfileView.BORN = userView.BORN; userProfileView.ADDRESS = userView.ADDRESS; userProfileView.DESCRIPTION = userView.DESCRIPTION; userProfileView.JOB = userView.JOB; userProfileView.COMPANY = userView.COMPANY; userProfileView.HOBBY = userView.HOBBY; userView.TOURIS_TV_USER_PROFILE.Add(userProfileView); rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(userView, "User", "Edit", EnumList.IHttpMethod.Post.ToString())); if (rs.IsSuccess) { if (physicalPath != "") { postedFile.SaveAs(physicalPath); } rs.SetSuccessStatus("Data has been edited successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to edited"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public IHttpActionResult Add(TOURIS_TV_SUB_CATEGORY subCategoryView) { ApiResData res = new ApiResData(); try { if (!ModelState.IsValid) { rs.SetErrorStatus(eFunc.fg.SFailed); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid))); return(Content(HttpStatusCode.NotFound, resObj)); } TOURIS_TM_SUB_CATEGORY subCategory = new TOURIS_TM_SUB_CATEGORY(); subCategory.CATEGORY_ID = subCategoryView.CATEGORY_ID; subCategory.VILLAGE_ID = subCategoryView.VILLAGE_ID; subCategory.SUB_CATEGORY_NAME = subCategoryView.SUB_CATEGORY_NAME; subCategory.SUB_CATEGORY_DESCRIPTION = subCategoryView.SUB_CATEGORY_DESCRIPTION; subCategory.START_TIME = subCategoryView.START_TIME; subCategory.END_TIME = subCategoryView.END_TIME; subCategory.PHOTO_PATH = subCategoryView.PHOTO_PATH; subCategory.ADDRESS = subCategoryView.ADDRESS; subCategory.LATITUDE = subCategoryView.LATITUDE; subCategory.LONGITUDE = subCategoryView.LONGITUDE; subCategory.CREATED_BY = subCategoryView.CREATED_BY; subCategory.CREATED_TIME = subCategoryView.CREATED_TIME; subCategory.ROW_STATUS = eStat.fg.IsActive; rs = repo.Add(subCategory); if (rs.IsSuccess) { rs.SetSuccessStatus(); } else { rs.SetErrorStatus(eFunc.fg.SFailed); } resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null)); return(Content(HttpStatusCode.OK, resObj)); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed))); return(Content(HttpStatusCode.BadRequest, resObj)); } }
public ResultStatus Add(SBH_TM_NEWS news) { try { _ctx.SBH_TM_NEWS.Add(news); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(SBH_TM_GALERY_FOTO galery) { try { _ctx.SBH_TM_GALERY_FOTO.Add(galery); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(GEMA_TM_PRICEL_LIST priceList) { try { _ctx.GEMA_TM_PRICEL_LIST.Add(priceList); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(GEMA_TM_CATEGORY category) { try { _ctx.GEMA_TM_CATEGORY.Add(category); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_SOSMED sosmed) { try { _ctx.TOURIS_TM_SOSMED.Add(sosmed); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_PROVINCE province) { try { _ctx.TOURIS_TM_PROVINCE.Add(province); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_DISTRICT district) { try { _ctx.TOURIS_TM_DISTRICT.Add(district); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(GEMA_TM_SLIDESHOW slideshow) { try { _ctx.GEMA_TM_SLIDESHOW.Add(slideshow); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_COUNTRY country) { try { _ctx.TOURIS_TM_COUNTRY.Add(country); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_VILLAGE village) { try { _ctx.TOURIS_TM_VILLAGE.Add(village); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_CONTACT_US contactUs) { try { _ctx.TOURIS_TM_CONTACT_US.Add(contactUs); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_MENU menu) { try { _ctx.TOURIS_TM_MENU.Add(menu); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Add(TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto) { try { _ctx.TOURIS_TM_SUB_CATEGORY_PHOTO.Add(subCategoryPhoto); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public IHttpActionResult Add(TOURIS_TV_SOSMED sosmedView) { ApiResData res = new ApiResData(); try { if (!ModelState.IsValid) { rs.SetErrorStatus(eFunc.fg.SFailed); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid))); return(Content(HttpStatusCode.NotFound, resObj)); } TOURIS_TM_SOSMED sosmed = new TOURIS_TM_SOSMED(); sosmed.TYPE = sosmedView.TYPE; sosmed.NAME = sosmedView.NAME; sosmed.DESCRIPTION = sosmedView.DESCRIPTION; sosmed.ICON = sosmedView.ICON; sosmed.URL = sosmedView.URL; sosmed.DATA_EMBED = sosmedView.DATA_EMBED; sosmed.HEIGHT = sosmedView.HEIGHT; sosmed.WIDTH = sosmedView.WIDTH; sosmed.DATA_WIDGET_ID = sosmedView.DATA_WIDGET_ID; sosmed.CREATED_BY = sosmedView.CREATED_BY; sosmed.CREATED_TIME = sosmedView.CREATED_TIME; sosmed.ROW_STATUS = eStat.fg.IsActive; rs = repo.Add(sosmed); if (rs.IsSuccess) { rs.SetSuccessStatus(); } else { rs.SetErrorStatus(eFunc.fg.SFailed); } resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null)); return(Content(HttpStatusCode.OK, resObj)); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed))); return(Content(HttpStatusCode.BadRequest, resObj)); } }
public ApiGridResponse EditDataCountry(TOURIS_TV_COUNTRY countryView) { ApiGridResponse res = new ApiGridResponse(); ResultStatus rs = new ResultStatus(); try { using (TourismpediaEntities tourisdb = new TourismpediaEntities()) { TOURIS_TM_COUNTRY country = tourisdb.TOURIS_TM_COUNTRY.Find(countryView.ID); country.COUNTRY_CODE = countryView.COUNTRY_CODE; country.COUNTRY_NAME = countryView.COUNTRY_NAME; country.COUNTRY_DESCRIPTION = countryView.COUNTRY_DESCRIPTION; country.LAST_MODIFIED_BY = countryView.LAST_MODIFIED_BY; country.LAST_MODIFIED_TIME = countryView.LAST_MODIFIED_TIME; tourisdb.Entry(country).State = EntityState.Modified; tourisdb.SaveChanges(); rs.SetSuccessStatus(); } res = ResGetDataTable(new object[] { rs }, null); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); res = ResGetDataTable(new object[] { rs }, ex); } return(res); }
public ApiGridResponse DeleteDataCountry(TOURIS_TV_COUNTRY countryView) { ApiGridResponse res = new ApiGridResponse(); ResultStatus rs = new ResultStatus(); try { using (TourismpediaEntities tourisdb = new TourismpediaEntities()) { TOURIS_TM_COUNTRY country = tourisdb.TOURIS_TM_COUNTRY.Find(countryView.ID); tourisdb.TOURIS_TM_COUNTRY.Remove(country); tourisdb.SaveChanges(); rs.SetSuccessStatus(); } res = ResGetDataTable(new object[] { rs }, null); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); res = ResGetDataTable(new object[] { rs }, ex); } return(res); }
public ApiGridResponse InsertDataCountry(TOURIS_TV_COUNTRY countryView) { ApiGridResponse res = new ApiGridResponse(); ResultStatus rs = new ResultStatus(); try { TOURIS_TM_COUNTRY country = new TOURIS_TM_COUNTRY(); using (TourismpediaEntities tourisdb = new TourismpediaEntities()) { country.COUNTRY_CODE = countryView.COUNTRY_CODE; country.COUNTRY_NAME = countryView.COUNTRY_NAME; country.COUNTRY_DESCRIPTION = countryView.COUNTRY_DESCRIPTION; country.CREATED_BY = countryView.CREATED_BY; country.CREATED_TIME = countryView.CREATED_TIME; tourisdb.TOURIS_TM_COUNTRY.Add(country); tourisdb.SaveChanges(); rs.SetSuccessStatus(); } res = ResGetDataTable(new object[] { rs }, null); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); res = ResGetDataTable(new object[] { rs }, ex); } return(res); }
public ActionResult CreateChatMessage(int senderId, int receiverId, string message) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString); DateTime date = DateTime.Now; string date3 = date.ToString("yyyy-MM-dd"); string time = date.ToString("HH:mm:ss"); try { conn.Open(); string query = "insert into SBH_TM_CHATBOX values('" + senderId + "','" + receiverId + "','" + message + "','" + date3 + "','" + time + "')"; SqlCommand cmd = new SqlCommand(query, conn); int i = cmd.ExecuteNonQuery(); conn.Close(); if (i >= 1) { rs.SetSuccessStatus(); } } catch (Exception ex) { rs.SetErrorStatus(ex.Message); conn.Close(); } return(Json(rs, JsonRequestBehavior.AllowGet)); }