public string BindGrid(string cdate)
{
object result = null;
string strReturn = string.Empty;
try
{
DataSet ds = new DataSet();
ds = BL_tblPropertyBasicBiddingMap.GetDataforBidRateInventory(Convert.ToInt32(Session["PropId"]), cdate);
DataTable dtdays = ds.Tables[1];
DataTable dtvalue = ds.Tables[0];
DataTable dtrooms = ds.Tables[2];
string days = getweekdaysJson(dtdays);
string values = dtvalue.Rows[0]["A"].ToString();
string rooms = getroomsJson(dtrooms);
int roomcount = dtrooms.Rows.Count + 11;
result = new { st = 1, rooms = rooms, days = days, values = values, count = roomcount };
}
catch (Exception)
{
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public ActionResult UpdateBasicBidding(etblPropertyBasicBiddingMapForOverview eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
if (eObj.Self.dtEffectiveDate.Date < DateTime.Now.AddDays(-7).Date)
{
result = new { st = 0, msg = "Please provide discounts for this date and discount type in Bidding => Bulk Update screen first as this screen can only update discounts." };
}
else if (eObj.Self.dtEffectiveDate.Date >= DateTime.Now.AddDays(-7).Date&& eObj.Self.dtEffectiveDate.Date < DateTime.Now.Date)
{
result = new { st = 0, msg = "Data for past dates cannot be provided." };
}
else if (eObj.Self.dBasicDiscount > 100)
{
result = new { st = 0, msg = "Base discount cannot be more than 100." };
}
else
{
eObj.Self.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.Self.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
eObj.Self.dtActionDate = DateTime.Now;
int j = BL_tblPropertyBasicBiddingMap.UpdateRecord(eObj);
if (j == 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 Basic(string date, string typ, string pctype)
{
etblPropertyBasicBiddingMapForOverview obj = new etblPropertyBasicBiddingMapForOverview();
obj = BL_tblPropertyBasicBiddingMap.GetSingleRecordById(clsUtils.ConvertyyyymmddtoDateTime(date), Convert.ToInt32(Session["PropId"]), Convert.ToInt32(typ), pctype);
//if (obj.dtEffectiveDate != null)
//{
// obj.EffectiveDate = String.Format("{0:dd/MM/yyyy}", obj.dtEffectiveDate);
//}
//else
//{
obj.Self.dtEffectiveDate = clsUtils.ConvertyyyymmddtoDateTime(date);
obj.Self.EffectiveDate = String.Format("{0:dd/MM/yyyy}", obj.Self.dtEffectiveDate);
//}
return(PartialView("_PropertyBasicBiddingMap", obj));
}
/// <summary>
///
/// </summary>
/// <param name="BookingDate"></param>
/// <param name="ArrivalDate"></param>
/// <param name="LOS"></param>
/// <param name="Rooms"></param>
/// <param name="Occupancy"></param>
/// <param name="Type">0: Both , 1: Public, 2:Corporate</param>
/// <returns></returns>
public string BindGrid(string BookingDate, string ArrivalDate, string LOS, string Rooms, string Occupancy, string Type)
{
object result = null;
string strResultJson = string.Empty;
try
{
var type = Convert.ToInt32(Type);
DataSet publicDataset = new DataSet();
DataSet corporateDataset = new DataSet();
string publicValues = string.Empty;
string publicErrors = string.Empty;
string corporateValues = string.Empty;
string corporateErrors = string.Empty;
string overallValues = string.Empty;
string overallErrors = string.Empty;
if (string.IsNullOrEmpty(BookingDate))
{
throw new ArgumentNullException("BookingDate");
}
if (string.IsNullOrEmpty(ArrivalDate))
{
throw new ArgumentNullException("ArrivalDate");
}
var propertyId = Convert.ToInt32(Session["PropId"]);
//if (type == 0)
//{
// Parallel.Invoke(() =>
// {
// publicDataset = BL_tblPropertyBasicBiddingMap.GetDataforBidSimulator(propertyId, BookingDate, ArrivalDate, LOS, Rooms, Occupancy, 1);
// },
// () =>
// {
// corporateDataset = BL_tblPropertyBasicBiddingMap.GetDataforBidSimulator(propertyId, BookingDate, ArrivalDate, LOS, Rooms, Occupancy, 2);
// });
// DataTable dtcorporateValue = corporateDataset.Tables[0];
// DataTable dtCorporateError = publicDataset.Tables[3];
// corporateValues = dtcorporateValue.Rows[0]["A"].ToString();
// corporateErrors = getErrorsJson(dtCorporateError);
//}
//else
//{
// publicDataset = BL_tblPropertyBasicBiddingMap.GetDataforBidSimulator(propertyId, BookingDate, ArrivalDate, LOS, Rooms, Occupancy, type);
//}
string sType = type == 1 ? "P" : type == 2 ? "C" : "B";
publicDataset = BL_tblPropertyBasicBiddingMap.ListSimulatorDataV2(propertyId, BookingDate, ArrivalDate, LOS, Rooms, Occupancy, sType);
DataTable dtPublicValue = publicDataset.Tables[0];
DataTable dtdays = publicDataset.Tables[1];
DataTable dtPublicRooms = publicDataset.Tables[2];
DataTable dtPublicError = publicDataset.Tables[3];
string days = getweekdaysJson(dtdays);
int roomcount = dtPublicRooms.Rows.Count + 12;
string rooms = getroomsJson(dtPublicRooms);
if (sType == "B")
{
roomcount += 10;
}
publicValues = dtPublicValue.Rows[0]["A"].ToString();
publicErrors = getErrorsJson(dtPublicError);
result = new
{
st = 1,
rooms = rooms,
days = days,
count = roomcount,
publicValues = publicValues,
publicErrors = publicErrors,
both = type == 0
};
}
catch (Exception)
{
}
strResultJson = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strResultJson);
}
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 BidDatesWithType = new DataTable();
DataColumn col = null;
col = new DataColumn("dtEffectiveDate", typeof(DateTime));
BidDatesWithType.Columns.Add(col);
col = new DataColumn("cType", typeof(Int64));
BidDatesWithType.Columns.Add(col);
DataTable BidDatesWithTypeForRoom = new DataTable();
DataColumn col1 = null;
col1 = new DataColumn("dtEffectiveDate", typeof(DateTime));
BidDatesWithTypeForRoom.Columns.Add(col1);
col1 = new DataColumn("cType", typeof(Int64));
BidDatesWithTypeForRoom.Columns.Add(col1);
JArray jArray = (JArray)JsonConvert.DeserializeObject(data.Replace("\\", "\""));
//var res = new List<string>();
//for (var date = StartDate; date <= EndDate; date = date.AddDays(1))
// res.Add(date.ToString());
//if (jArray != null)
//{
// foreach (var ddate in res)
// {
// foreach (var item in jArray)
// {
// DataRow dr = BidDatesWithType.NewRow();
// dr["dtEffectiveDate"] = ddate;
// dr["cType"] = Convert.ToInt32(item["Type"]);
// BidDatesWithType.Rows.Add(dr);
// }
// }
//}
if (jArray != null)
{
for (var date = StartDate; date <= EndDate; date = date.AddDays(1))
{
foreach (var item in jArray)
{
if (item["Type"].ToString().Contains("_"))
{
DataRow dr = BidDatesWithTypeForRoom.NewRow();
dr["dtEffectiveDate"] = date.ToString();
dr["cType"] = Convert.ToInt32(item["Type"].ToString().Split('_')[1]);
BidDatesWithTypeForRoom.Rows.Add(dr);
}
else
{
DataRow dr = BidDatesWithType.NewRow();
dr["dtEffectiveDate"] = date.ToString();
dr["cType"] = Convert.ToInt32(item["Type"]);
BidDatesWithType.Rows.Add(dr);
}
}
}
}
int j = BL_tblPropertyBasicBiddingMap.UpdateAllBidRecord(Convert.ToInt32(Session["PropId"]), ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId, BidDatesWithType, BidDatesWithTypeForRoom, 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);
}
