public ActionResult AddEditRate(RateModel rate)
{
Rate objRate;
if (ModelState.IsValid)
{
if (rate.rateID > 0)
{
objRate = db.Rates.Where(o => o.rateID == rate.rateID).SingleOrDefault();
}
else
{
objRate = new Rate();
}
objRate.startTime = Convert.ToDateTime(rate.startTime);
objRate.endTime = Convert.ToDateTime(rate.endTime);
objRate.rateCode = rate.rateCode;
objRate.title = rate.title;
objRate.amount = rate.amount;
objRate.color = rate.color;
objRate.bufferTime = rate.bufferTime;
objRate.alertInterval = rate.alertInterval;
objRate.storeID = rate.SelectedStoreId;
objRate.ratetype = rate.SelectedRateId;
objRate.active = rate.active;
objRate.isPrepay = rate.isPrepay;
if (objRate.rateID > 0)
{
objRate.updatedBy = 1;
objRate.updatedDate = DateTime.Now;
db.Entry(objRate).State = EntityState.Modified;
db.SaveChanges();
}
else
{
objRate.createdBy = 1233;
objRate.Createddate = DateTime.Now;
db.Rates.Add(objRate);
}
db.SaveChanges();
//Users/LoadDataForDataTable
return(RedirectToAction("ManageRate"));
}
else
{
#region loadstores
List <Store> stores = (from data in db.Stores
select data).ToList();
Store objStores = new Store();
objStores.storeName = "Select";
objStores.storeID = 0;
stores.Insert(0, objStores);
rate.Stores = stores.Select(a => new SelectListItem
{
Text = a.storeName,
Value = a.storeID.ToString()
});
#endregion
#region loadRates
List <POSEntity.RateType> rates = (from data in db.RateTypes
select data).ToList();
POSEntity.RateType objRateType = new POSEntity.RateType();
objRateType.Title = "Select";
objRateType.RateTypeid = 0;
rates.Insert(0, objRateType);
rate.RateTypes = rates.Select(a => new SelectListItem
{
Text = a.Title,
Value = a.RateTypeid.ToString()
});
#endregion
return(View(rate));
}
}
public ActionResult AddEditRate(String id)
{
int _companyid = ClientSession.CompanyID;
Random rand = new Random();
int _newValue = rand.Next();
RateModel mod = new RateModel();
#region loadstores
List <Store> stores = (from data in db.Stores
select data).ToList();
Store objStores = new Store();
objStores.storeName = "Select";
objStores.storeID = 0;
stores.Insert(0, objStores);
mod.Stores = stores.Select(a => new SelectListItem
{
Text = a.storeName,
Value = a.storeID.ToString()
});
#endregion
#region loadRates
List <POSEntity.RateType> rates = (from data in db.RateTypes
select data).ToList();
POSEntity.RateType objRateType = new POSEntity.RateType();
objRateType.Title = "Select";
objRateType.RateTypeid = 0;
rates.Insert(0, objRateType);
mod.RateTypes = rates.Select(a => new SelectListItem
{
Text = a.Title,
Value = a.RateTypeid.ToString()
});
#endregion
Rate objRate;
int _hdnrateId = Convert.ToInt32(id);
if (_hdnrateId > 0)
{
objRate = db.Rates.Where(o => o.rateID == _hdnrateId).SingleOrDefault();
mod.startTime = Convert.ToDateTime(objRate.startTime).ToShortTimeString();
mod.endTime = Convert.ToDateTime(objRate.endTime).ToShortTimeString();
mod.SelectedStoreId = Convert.ToInt32(objRate.storeID);
mod.SelectedRateId = Convert.ToInt32(objRate.ratetype);
mod.rateCode = objRate.rateCode;
}
else
{
objRate = new Rate();
mod.startTime = DateTime.Now.ToShortTimeString();
mod.endTime = DateTime.Now.ToShortTimeString();
mod.rateCode = _companyid + "-" + _newValue;
}
//PopulateStoresDropDownList(mod.storeID);
mod.rateID = _hdnrateId;
mod.title = objRate.title;
mod.amount = Convert.ToDecimal(objRate.amount);
mod.color = objRate.color;
mod.bufferTime = Convert.ToInt32(objRate.bufferTime);
mod.alertInterval = Convert.ToInt32(objRate.alertInterval);
//mod.terminationDate = Convert.ToDateTime(objStore.terminationDate).ToShortDateString() == "1/1/0001" ? "" : Convert.ToDateTime(objStore.terminationDate).ToShortDateString();
mod.isPrepay = Convert.ToBoolean(objRate.isPrepay);
mod.active = Convert.ToBoolean(objRate.active);
return(View(mod));
}