public ActionResult Save(Models.InventoryModel data) { try { DateTime ToDate1; if (data.StartMonth > data.EndMonth) { ToDate1 = new DateTime(DateTime.Today.Year +1, data.EndMonth, data.EndDay); } else { ToDate1 = new DateTime(DateTime.Today.Year, data.EndMonth, data.EndDay); } CLayer.Inventory d = new CLayer.Inventory() { AccommodationId = data.AccommodationId, InventoryId = data.InventoryId, Quantity = data.Quantity, FromDate = new DateTime(DateTime.Today.Year, data.StartMonth, data.StartDay), ToDate = ToDate1 }; long AccId = BLayer.Inventory.save(d); return RedirectToAction("index", new { id = data.AccommodationId }); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return RedirectToAction("index", new { id = data.AccommodationId }); } }
public long APIUpdate(CLayer.Inventory inventory) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, inventory.AccommodationId)); param.Add(Connection.GetParameter("pQuantity", DataPlug.DataType._Int, inventory.Quantity)); param.Add(Connection.GetParameter("pFromDate", DataPlug.DataType._Date, inventory.FromDate)); param.Add(Connection.GetParameter("pToDate", DataPlug.DataType._Date, inventory.ToDate)); object result = Connection.ExecuteQueryScalar("SP_inventory_Save", param); return(Connection.ToLong(result)); }
public ActionResult Save(Models.InventoryModel data) { try { DateTime ToDate1; DateTime FromDate1; int days = DateTime.DaysInMonth(2014, data.StartMonth); if (days < data.StartDay) { data.StartDay = days; } FromDate1 = new DateTime(DateTime.Today.Year, data.StartMonth, data.StartDay); days = DateTime.DaysInMonth(2014, data.EndMonth); if (days < data.EndDay) { data.EndDay = days; } //if (data.StartMonth > data.EndMonth) // ToDate1 = new DateTime(2015, data.EndMonth, data.EndDay); //else ToDate1 = new DateTime(2014, data.EndMonth, data.EndDay); //{ //ToDate1 = new DateTime(DateTime.Today.Year +1, data.EndMonth, data.EndDay); //} //else //{ // ToDate1 = new DateTime(DateTime.Today.Year, data.EndMonth, data.EndDay); //} CLayer.Inventory d = new CLayer.Inventory() { AccommodationId = data.AccommodationId, InventoryId = data.InventoryId, Quantity = data.Quantity, FromDate = new DateTime(DateTime.Today.Year, data.StartMonth, data.StartDay), ToDate = ToDate1 }; long AccId = BLayer.Inventory.save(d); return(RedirectToAction("index", new { id = data.AccommodationId })); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(RedirectToAction("index", new { id = data.AccommodationId })); } }
public ActionResult Details(long InventoryId) { Models.InventoryModel search = new Models.InventoryModel(); CLayer.Inventory get = BLayer.Inventory.GetOnebyInventoryId(InventoryId); if (get != null) { search = new Models.InventoryModel { AccommodationId = get.AccommodationId, InventoryId = get.InventoryId, Quantity = get.Quantity, StartDay = get.FromDate.Day, EndDay = get.ToDate.Day, StartMonth = get.FromDate.Month, EndMonth = get.ToDate.Month }; } return(PartialView("_Details", search)); }
public CLayer.Inventory GetOnAccommodationId(long InventoryId) { CLayer.Inventory Inverntory = new CLayer.Inventory(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pInventoryId", DataPlug.DataType._BigInt, InventoryId)); DataTable dt = Connection.GetTable("inventory_GetOnInventoryId", param); foreach (DataRow dr in dt.Rows) { if (dt.Rows.Count > 0) { Inverntory = new CLayer.Inventory(); Inverntory.AccommodationId = Connection.ToLong(dr["AccommodationId"]); Inverntory.InventoryId = Connection.ToLong(dr["InventoryId"]); Inverntory.Quantity = Connection.ToInteger(dr["Quantity"]); Inverntory.FromDate = Connection.ToDate(dr["FromDate"]); Inverntory.ToDate = Connection.ToDate(dr["ToDate"]); } } return(Inverntory); }
public static long APIsave(CLayer.Inventory invenData) { DataLayer.Inventory task = new DataLayer.Inventory(); return(task.APIUpdate(invenData)); }