public string GetBidLoadRateUpgradeList(string ValidFrom, string ValidTo)
{
string strReturn = string.Empty;
string outputJson = string.Empty;
StringBuilder sb = new StringBuilder();
try
{
strReturn = BL_tblPropertyBiddingRateM.GetBidLoadRateUpgradeList(Convert.ToInt32(Session["PropId"]), ValidFrom, ValidTo);
return(strReturn);
}
catch (Exception ex)
{
return(null);
}
}
public ActionResult UpdateUpgrade(etblPropertyBidUpgradeM eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
if (eObj.dtEffectiveDate.Date >= DateTime.Now.AddDays(-7).Date&& eObj.dtEffectiveDate.Date < DateTime.Now.Date)
{
result = new { st = 0, msg = "Data for past dates cannot be provided." };
}
eObj.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
eObj.dtActionDate = DateTime.Now;
int j = BL_tblPropertyBiddingRateM.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 Updates(string date, string id)
{
etblPropertyBidUpgradeM obj = new etblPropertyBidUpgradeM();
obj = BL_tblPropertyBiddingRateM.GetSingleRecordById(clsUtils.ConvertyyyymmddtoDateTime(date), Convert.ToInt32(Session["PropId"]), Convert.ToInt32(id));
if (obj.dtEffectiveDate != null)
{
ViewData["Date"] = String.Format("{0:dd/MM/yyyy}", obj.dtEffectiveDate);
}
else
{
obj.dtEffectiveDate = clsUtils.ConvertyyyymmddtoDateTime(date);
ViewData["Date"] = String.Format("{0:dd/MM/yyyy}", obj.dtEffectiveDate);
}
return(PartialView("_PropertyBidUpgradeM", obj));
}
public ActionResult AddUpdate(etblPropertyBiddingRateM eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
eObj.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
DateTime datefrom = clsUtils.ConvertddmmyyyytoDateTime(eObj.datefrom);
DateTime dateto = clsUtils.ConvertddmmyyyytoDateTime(eObj.dateto);
int RPID = (int)eObj.iRPId;
int RoomId = (int)eObj.iRoomId;
string ValidCheck = BL_tblPropertyBiddingRateM.CheckRatePlanValidity(RPID, datefrom, dateto);
if (ValidCheck != "a")
{
result = new { st = 0, msg = ValidCheck };
return(Json(result, JsonRequestBehavior.AllowGet));
}
string ValidCheck2 = BL_tblPropertyBiddingRateM.CheckRoomRatePlanPrice(RoomId, RPID, datefrom, dateto);
if (ValidCheck2 != "a")
{
result = new { st = 0, msg = ValidCheck2 };
return(Json(result, JsonRequestBehavior.AllowGet));
}
var res = new List <string>();
for (var date = datefrom; date <= dateto; date = date.AddDays(1))
{
res.Add(date.ToString());
}
DataTable PropertyBiddingRateM = new DataTable();
DataColumn col1 = null;
col1 = new DataColumn("dtEffectiveDate", typeof(DateTime));
PropertyBiddingRateM.Columns.Add(col1);
col1 = new DataColumn("iRoomId", typeof(Int64));
PropertyBiddingRateM.Columns.Add(col1);
col1 = new DataColumn("iRPId", typeof(Int32));
PropertyBiddingRateM.Columns.Add(col1);
DataTable PropertyBidUpgradeM = new DataTable();
DataColumn col = null;
col = new DataColumn("dtEffectiveDate", typeof(DateTime));
PropertyBidUpgradeM.Columns.Add(col);
col = new DataColumn("iRoomId", typeof(Int64));
PropertyBidUpgradeM.Columns.Add(col);
col = new DataColumn("dUpgradeCharge", typeof(Decimal));
PropertyBidUpgradeM.Columns.Add(col);
col = new DataColumn("sUpgradeType", typeof(string));
PropertyBidUpgradeM.Columns.Add(col);
foreach (var item in res)
{
DataRow dr = PropertyBiddingRateM.NewRow();
dr["dtEffectiveDate"] = item;
dr["iRoomId"] = eObj.iRoomId;
dr["iRPId"] = eObj.iRPId;
PropertyBiddingRateM.Rows.Add(dr);
}
if (eObj.selectedRoomPrices != null)
{
JArray jArray = (JArray)JsonConvert.DeserializeObject(eObj.selectedRoomPrices.Replace("\\", "\""));
if (jArray != null)
{
foreach (var ddate in res)
{
foreach (var item in jArray)
{
if (item["value"].ToString().Trim() != "")
{
try
{
if (Convert.ToDecimal(item["value"]) > 0)
{
try
{
int a = Convert.ToInt32(item["value"]);
}
catch (Exception)
{
result = new { st = 0, msg = "Upgrade amount should be a valid integer greater than 1." };
return(Json(result, JsonRequestBehavior.AllowGet));
}
DataRow dr = PropertyBidUpgradeM.NewRow();
dr["dtEffectiveDate"] = ddate;
dr["iRoomId"] = Convert.ToInt64(item["roomid"]);
dr["dUpgradeCharge"] = Convert.ToDecimal(Convert.ToInt32(item["value"]));
dr["sUpgradeType"] = "WIS";
PropertyBidUpgradeM.Rows.Add(dr);
}
else
{
DataRow dr = PropertyBidUpgradeM.NewRow();
dr["dtEffectiveDate"] = ddate;
dr["iRoomId"] = Convert.ToInt64(item["roomid"]);
dr["dUpgradeCharge"] = DBNull.Value;
dr["sUpgradeType"] = "BTB";
PropertyBidUpgradeM.Rows.Add(dr);
}
}
catch (Exception E)
{
result = new { st = 0, msg = "Upgrade amount should be a valid integer greater than 1." };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
}
}
}
}
int j = BL_tblPropertyBiddingRateM.AddUpdateRecord(eObj, PropertyBiddingRateM, PropertyBidUpgradeM);
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));
}
