public ActionResult RoomInventory(string roomid, string date)
{
etblPropertyRoomInventory obj = new etblPropertyRoomInventory();
obj = BL_tblPropertyRoomInventory.GetSingleRecordById(Convert.ToInt32(roomid), clsUtils.ConvertyyyymmddtoDateTime(date));
if (obj.iPropId != 0)
{
if (obj.dtInventoryDate != null)
{
obj.InventoryDate = String.Format("{0:dd/MM/yyyy}", obj.dtInventoryDate);
}
if (obj.bStopSell == true)
{
obj.sStopSell = "Yes";
}
else
{
obj.sStopSell = "No";
}
}
else
{
obj.dtInventoryDate = clsUtils.ConvertyyyymmddtoDateTime(date);
obj.InventoryDate = String.Format("{0:dd/MM/yyyy}", obj.dtInventoryDate);
obj.iRoomId = Convert.ToInt64(roomid);
}
return(PartialView("_RoomInventory", obj));
}
public string BindGrid(string cdate)
{
object result = null;
string strReturn = string.Empty;
try
{
DataSet ds = new DataSet();
ds = BL_tblPropertyRoomInventory.GetDataforPropertyRateInventory(Convert.ToInt32(Session["PropId"]), cdate);
DataTable dtrooms = ds.Tables[0];
DataTable dtdays = ds.Tables[2];
DataTable dtvalue = ds.Tables[1];
if (dtrooms.Rows.Count > 1)
{
string rooms = getroomsJson(dtrooms);
string days = getweekdaysJson(dtdays);
string values = dtvalue.Rows[0]["A"].ToString();
int roomcount = dtrooms.Rows.Count;
result = new { st = 1, rooms = rooms, days = days, values = values, count = roomcount };
}
else
{
result = new { st = 0, msg = "There are no rooms and rate plans available for this property." };
}
}
catch (Exception)
{
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public string UpdateCloseOut(string data, string startdate, bool type)
{
object result = null;
string strReturn = string.Empty;
try
{
DateTime StartDate = OneFineRateAppUtil.clsUtils.ConvertmmddyyyytoDateTime(startdate);
DateTime EndDate = StartDate.AddDays(14);
DataTable PropertyRoomInventory = new DataTable();
DataColumn col = null;
col = new DataColumn("dtInventoryDate", typeof(DateTime));
PropertyRoomInventory.Columns.Add(col);
col = new DataColumn("iRoomId", typeof(Int64));
PropertyRoomInventory.Columns.Add(col);
DataTable PropertyRoomRatePlanInventoryMap = new DataTable();
DataColumn col1 = null;
col1 = new DataColumn("dtInventoryDate", typeof(DateTime));
PropertyRoomRatePlanInventoryMap.Columns.Add(col1);
col1 = new DataColumn("iRoomId", typeof(Int64));
PropertyRoomRatePlanInventoryMap.Columns.Add(col1);
col1 = new DataColumn("iRPId", typeof(Int64));
PropertyRoomRatePlanInventoryMap.Columns.Add(col1);
var res = new List <string>();
for (var date = StartDate; date <= EndDate; date = date.AddDays(1))
{
res.Add(date.ToString());
}
JArray jArray = (JArray)JsonConvert.DeserializeObject(data.Replace("\\", "\""));
if (jArray != null)
{
foreach (var ddate in res)
{
foreach (var item in jArray)
{
if (item["Type"].ToString() == "R")
{
DataRow dr = PropertyRoomInventory.NewRow();
dr["dtInventoryDate"] = ddate;
dr["iRoomId"] = Convert.ToInt64(item["rid"]);
PropertyRoomInventory.Rows.Add(dr);
}
if (item["Type"].ToString() == "P")
{
DataRow dr = PropertyRoomRatePlanInventoryMap.NewRow();
dr["dtInventoryDate"] = ddate;
dr["iRoomId"] = Convert.ToInt64(item["rid"]);
dr["iRPId"] = Convert.ToInt32(item["rpid"]);
PropertyRoomRatePlanInventoryMap.Rows.Add(dr);
}
}
}
}
int j = BL_tblPropertyRoomInventory.AddUpdateRecord(Convert.ToInt32(Session["PropId"]), ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, PropertyRoomInventory, PropertyRoomRatePlanInventoryMap, type);
if (j == 1)
{
result = new { st = 1, msg = "Closed Out successfully." };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
