private ResultStatus AddBooking(GEMA_TR_BOOKING booking, ref int booking_id)
{
_ctx.GEMA_TR_BOOKING.Add(booking);
_ctx.SaveChanges();
booking_id = _ctx.GEMA_TR_BOOKING.Where(x => x.TR_NUMBER == booking.TR_NUMBER).FirstOrDefault().ID;
rs.SetSuccessStatus();
return(rs);
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_SUB_CATEGORY> subCategories = repo.GridBind();
List <TOURIS_TV_SUB_CATEGORY> subCategoryViews = new List <TOURIS_TV_SUB_CATEGORY>();
if (subCategories.Count > 0)
{
foreach (var item in subCategories)
{
TOURIS_TV_SUB_CATEGORY subCategoryView = new TOURIS_TV_SUB_CATEGORY();
subCategoryView.ID = item.ID;
subCategoryView.CATEGORY_ID = item.CATEGORY_ID;
subCategoryView.CATEGORY_NAME = item.TOURIS_TM_CATEGORY.CATEGORY_NAME;
subCategoryView.COUNTRY_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
subCategoryView.COUNTRY_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
subCategoryView.PROVINCE_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID;
subCategoryView.PROVINCE_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
subCategoryView.CITY_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID;
subCategoryView.CITY_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME;
subCategoryView.VILLAGE_ID = item.VILLAGE_ID;
subCategoryView.VILLAGE_NAME = item.TOURIS_TM_VILLAGE.VILLAGE_NAME;
subCategoryView.SUB_CATEGORY_NAME = item.SUB_CATEGORY_NAME;
subCategoryView.SUB_CATEGORY_DESCRIPTION = item.SUB_CATEGORY_DESCRIPTION;
subCategoryView.ADDRESS = item.ADDRESS;
subCategoryView.START_TIME = item.START_TIME;
subCategoryView.END_TIME = item.END_TIME;
subCategoryView.PHOTO_PATH = item.PHOTO_PATH;
subCategoryView.LATITUDE = item.LATITUDE;
subCategoryView.LONGITUDE = item.LONGITUDE;
subCategoryView.CREATED_BY = item.CREATED_BY;
subCategoryView.CREATED_TIME = item.CREATED_TIME;
subCategoryView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
subCategoryView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
subCategoryViews.Add(subCategoryView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryViews }, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { rs }, new Exception(eFunc.fg.DataNf)));
return(Content(HttpStatusCode.BadGateway, resObj));
}
}
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 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(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(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(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_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(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(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(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(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_SOSMED sosmed)
{
try
{
_ctx.TOURIS_TM_SOSMED.Add(sosmed);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
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(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 ApiGridResponse EditDataUser(TOURIS_TV_USER userView)
{
ApiGridResponse res = new ApiGridResponse();
ResultStatus rs = new ResultStatus();
try
{
using (TourismpediaEntities tourisdb = new TourismpediaEntities())
{
TOURIS_TM_USER user = tourisdb.TOURIS_TM_USER.Find(userView.ID);
user.USER_NAME = userView.USER_NAME;
user.USER_MAIL = userView.USER_MAIL;
user.LAST_MODIFIED_BY = userView.LAST_MODIFIED_BY;
user.LAST_MODIFIED_TIME = userView.LAST_MODIFIED_TIME;
tourisdb.Entry(user).State = EntityState.Modified;
tourisdb.SaveChanges();
rs.SetSuccessStatus();
}
res = ResGetDataTable(new object[] { rs }, null);
}
catch (Exception ex)
{
res = ResGetDataTable(null, ex);
}
return(res);
}
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 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));
}
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 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 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 InsertDataUser(TOURIS_TV_USER userView)
{
ApiGridResponse res = new ApiGridResponse();
ResultStatus rs = new ResultStatus();
try
{
TOURIS_TM_USER user = new TOURIS_TM_USER();
using (TourismpediaEntities tourisdb = new TourismpediaEntities())
{
user.USER_NAME = userView.USER_NAME;
user.USER_MAIL = userView.USER_MAIL;
user.CREATED_BY = userView.CREATED_BY;
user.CREATED_TIME = userView.CREATED_TIME;
tourisdb.TOURIS_TM_USER.Add(user);
tourisdb.SaveChanges();
rs.SetSuccessStatus();
}
res = ResGetDataTable(new object[] { rs }, null);
}
catch (Exception ex)
{
res = ResGetDataTable(null, 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 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 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 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 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"));
}
