Example #1
0
        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));
        }