public ActionResult AddUpdate(etblPropertyRoomInventory eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
eObj.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
eObj.dtActionDate = DateTime.Now;
string s = BL_bulk.SaveInventory(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, Convert.ToInt32(Session["PropId"]), eObj.dtInventoryDate.ToString("MM/dd/yyyy").Replace("-", "/"), eObj.iRoomId.ToString(), "", eObj.iAvailableInventory.ToString(), eObj.bStopSell ? "On" : "Off", eObj.iCutOff.ToString(), "", "", "", "", "", "", "", "", "", "");
if (s == "a")
{
result = new { st = 1, msg = "Updated successfully." };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public string SaveInventory(edata obj)
{
//string dates = "", roomid = "", plan = "", Inv = "", StopSell = "", CutOff = "", CloseOut = "", Min = "", Max = "", CTA = "", CTD = "", single = "", doble = "", triple = "", quad = "", quin = "";
object result = null;
string strReturn = string.Empty;
try
{
strReturn = BL_bulk.SaveInventory(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, Convert.ToInt32(Session["PropId"]), string.IsNullOrEmpty(obj.dates) ? "" : obj.dates, string.IsNullOrEmpty(obj.roomid) ? "" : obj.roomid, string.IsNullOrEmpty(obj.plan) ? "" : obj.plan, string.IsNullOrEmpty(obj.Inv) ? "" : obj.Inv, string.IsNullOrEmpty(obj.StopSell) ? "" : obj.StopSell, string.IsNullOrEmpty(obj.CutOff) ? "" : obj.CutOff, string.IsNullOrEmpty(obj.CloseOut) ? "" : obj.CloseOut, string.IsNullOrEmpty(obj.Min) ? "" : obj.Min, string.IsNullOrEmpty(obj.Max) ? "" : obj.Max, string.IsNullOrEmpty(obj.CTA) ? "" : obj.CTA, string.IsNullOrEmpty(obj.CTD) ? "" : obj.CTD, string.IsNullOrEmpty(obj.single) ? "" : obj.single, string.IsNullOrEmpty(obj.doble) ? "" : obj.doble, string.IsNullOrEmpty(obj.triple) ? "" : obj.triple, string.IsNullOrEmpty(obj.quad) ? "" : obj.quad, string.IsNullOrEmpty(obj.quin) ? "" : obj.quin);
if (strReturn == "a")
{
result = new { st = 1, msg = strReturn };
}
else
{
result = new { st = 2, msg = strReturn };
}
}
catch (Exception ex)
{
OneFineRateAppUtil.clsUtils.SendErrorMail(ex);
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public ActionResult ExportExcel()
{
DataSet ds = BL_bulk.GetBiddingDump(Convert.ToInt32(Session["PropId"]));
XLWorkbook wb = null;
try
{
using (wb = new XLWorkbook())
{
for (int i = 0; i < ds.Tables.Count; i++)
{
wb.Worksheets.Add(ds.Tables[i], GetSheetName(i));
foreach (IXLWorksheet workSheet in wb.Worksheets)
{
foreach (IXLTable tab in workSheet.Tables)
{
workSheet.Table(tab.Name).ShowAutoFilter = false;
workSheet.Columns().AdjustToContents();
}
}
}
}
}
catch (Exception)
{
Response.Write("<script>alert('Something went wrong !!!')</script>");
}
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=Report.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
System.Web.HttpContext.Current.ApplicationInstance.CompleteRequest();
}
if (TempData["StartDate"] != null && TempData["StartDate"].ToString().Trim() != "")
{
ViewData["StartDate"] = TempData["StartDate"];
}
else
{
ViewData["StartDate"] = "";
}
return(View("Index"));
}
public string GetRoomAndRatePlan(string OnlyBase)
{
object result = null;
string strReturn = string.Empty;
try
{
strReturn = BL_bulk.GetRoomAndRatePlanForBulk(Convert.ToInt32(Session["PropId"]), Convert.ToBoolean(OnlyBase));
result = new { st = 1, msg = strReturn };
}
catch (Exception ex)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public ActionResult AddUpdate(eRoomRatePrice_Ph eObj)
{
string strReturn = string.Empty;
object result = null;
try
{
if (ModelState.IsValid)
{
if ((eObj.SingleRate == null || eObj.SingleRate == 0) && (eObj.DoubleRate == null || eObj.DoubleRate == 0) && (eObj.TripleRate == null || eObj.TripleRate == 0) && (eObj.QuadrupleRate == null || eObj.QuadrupleRate == 0) && (eObj.QuintrupleRate == null || eObj.QuintrupleRate == 0))
{
result = new { st = 0, msg = "Please enter at least one Rate." };
return(Json(result, JsonRequestBehavior.AllowGet));
}
eObj.dtFrom = clsUtils.ConvertddmmyyyytoDateTime(eObj.FromDate);
eObj.dtTo = clsUtils.ConvertddmmyyyytoDateTime(eObj.ToDate);
var res = new List <string>();
for (var date = eObj.dtFrom; date <= eObj.dtTo; date = date.AddDays(1))
{
res.Add(date.ToString());
}
DataTable DateRoomPlan = new DataTable();
DataColumn col1 = null;
col1 = new DataColumn("dtInventoryDate", typeof(DateTime));
DateRoomPlan.Columns.Add(col1);
col1 = new DataColumn("iRoomId", typeof(Int64));
DateRoomPlan.Columns.Add(col1);
col1 = new DataColumn("iRPId", typeof(Int32));
DateRoomPlan.Columns.Add(col1);
foreach (var ddate in res)
{
DataRow drDateRoom = DateRoomPlan.NewRow();
drDateRoom["dtInventoryDate"] = ddate;
drDateRoom["iRoomId"] = eObj.RoomId;
drDateRoom["iRPId"] = eObj.PlanId;
DateRoomPlan.Rows.Add(drDateRoom);
}
Decimal single = eObj.SingleRate.ToString() == "" ? Convert.ToDecimal("0") : Convert.ToDecimal(eObj.SingleRate);
Decimal doble = eObj.DoubleRate.ToString() == "" ? Convert.ToDecimal("0") : Convert.ToDecimal(eObj.DoubleRate);
Decimal triple = eObj.TripleRate.ToString() == "" ? Convert.ToDecimal("0") : Convert.ToDecimal(eObj.TripleRate);
Decimal quad = eObj.QuadrupleRate.ToString() == "" ? Convert.ToDecimal("0") : Convert.ToDecimal(eObj.QuadrupleRate);
Decimal quin = eObj.QuintrupleRate.ToString() == "" ? Convert.ToDecimal("0") : Convert.ToDecimal(eObj.QuintrupleRate);
strReturn = BL_bulk.SaveInventoryRoomRatePlanPrices_Ph(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, Convert.ToInt32(Session["PropId"].ToString()), DateRoomPlan, single, doble, triple, quad, quin);
if (strReturn == "a")
{
result = new { st = 1, msg = strReturn };
}
else
{
result = new { st = 2, msg = strReturn };
}
}
else
{
string errormsg = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
errormsg += error.ErrorMessage;
errormsg += "</br>";
}
}
result = new { st = 0, msg = errormsg };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time" };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult AddUpdate(eInventoryPlan_Ph eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
eObj.dtFrom = clsUtils.ConvertddmmyyyytoDateTime(eObj.FromDate);
eObj.dtTo = clsUtils.ConvertddmmyyyytoDateTime(eObj.ToDate);
var res = new List <string>();
for (var date = eObj.dtFrom; date <= eObj.dtTo; date = date.AddDays(1))
{
res.Add(date.ToString());
}
List <PNames> RoomIds = new List <PNames>();
DataTable DateRoom = new DataTable();
DataColumn col = null;
col = new DataColumn("dtInventoryDate", typeof(DateTime));
DateRoom.Columns.Add(col);
col = new DataColumn("iRoomId", typeof(Int64));
DateRoom.Columns.Add(col);
int PropId = 0;
if (Session["PropId"] != null)
{
PropId = Convert.ToInt32(Session["PropId"]);
}
if (eObj.RoomType == true)
{
RoomIds = BL_tblPropertyRoomMap.GetAllPropertyRoomNames(PropId);
foreach (var ddate in res)
{
foreach (var item in RoomIds)
{
DataRow drDateRoom = DateRoom.NewRow();
drDateRoom["dtInventoryDate"] = ddate;
drDateRoom["iRoomId"] = item.Id;
DateRoom.Rows.Add(drDateRoom);
}
}
}
else
{
foreach (var ddate in res)
{
DataRow drDateRoom = DateRoom.NewRow();
drDateRoom["dtInventoryDate"] = ddate;
drDateRoom["iRoomId"] = eObj.RoomId;
DateRoom.Rows.Add(drDateRoom);
}
}
int i = BL_bulk.SaveInventoryPlan_Ph(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, Convert.ToInt32(Session["PropId"].ToString()), eObj.Action, DateRoom);
if (i == 1)
{
result = new { st = 1, msg = "Updated successfully" };
}
else
{
result = new { st = 0, msg = "Kindly try after some time" };
}
}
else
{
string errormsg = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
errormsg += error.ErrorMessage;
errormsg += "</br>";
}
}
result = new { st = 0, msg = errormsg };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time" };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult AddUpdateRatePlan(etblPropertyRoomRatePlanInventoryMap eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
eObj.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
eObj.dtActionDate = DateTime.Now;
if (eObj.SelectedOccupancies != null)
{
JArray jArray = (JArray)JsonConvert.DeserializeObject(eObj.SelectedOccupancies.Replace("\\", "\""));
if (jArray != null)
{
List <etblPropertyParkingMap> lstPropertyParkingMap = new List <etblPropertyParkingMap>();
foreach (var item in jArray)
{
if (Convert.ToInt32(item["type"]) == 1)
{
eObj.dSingleRate = Convert.ToDecimal(item["value"]);
}
if (Convert.ToString(item["type"]) == "2")
{
eObj.dDoubleRate = Convert.ToDecimal(item["value"]);
}
if (Convert.ToString(item["type"]) == "3")
{
eObj.dTripleRate = Convert.ToDecimal(item["value"]);
}
if (Convert.ToString(item["type"]) == "4")
{
eObj.dQuadrupleRate = Convert.ToDecimal(item["value"]);
}
if (Convert.ToString(item["type"]) == "5")
{
eObj.dQuintrupleRate = Convert.ToDecimal(item["value"]);
}
}
}
}
string strReturn = BL_bulk.SaveInventory(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, Convert.ToInt32(Session["PropId"]), eObj.dtInventoryDate.ToString("MM/dd/yyyy").Replace("-", "/"), eObj.iRoomId.ToString(), eObj.iRoomId.ToString() + "-" + eObj.iRPId.ToString(), "", "", "", eObj.bCloseOut ? "On" : "Off", eObj.iMinLengthStay.ToString(), eObj.iMaxLengthStay.ToString(), eObj.bCTA ? "On" : "Off", eObj.bCTD ? "On" : "Off", eObj.dSingleRate.ToString(), eObj.dDoubleRate.ToString(), eObj.dTripleRate.ToString(), eObj.dQuadrupleRate.ToString(), eObj.dQuintrupleRate.ToString());
if (strReturn == "a")
{
result = new { st = 1, msg = "Updated successfully." };
}
else if (strReturn.StartsWith("["))
{
result = new { st = 0, msg = "Rate Plan is not valid for this date." };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
else
{
string errormsg = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
errormsg += error.ErrorMessage;
errormsg += "</br>";
}
}
result = new { st = 0, msg = errormsg };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
