public ActionResult Create(DBhouseMv dBhouseMv)
{
if (ModelState.IsValid)
{
tbld_distribution_house tbldDistributionHouse = new tbld_distribution_house
{
DB_Id = dBhouseMv.DbId,
DBName = dBhouseMv.DbName,
DBCode = dBhouseMv.DbCode,
DBDescription = dBhouseMv.DbDescription,
OfficeAddress = dBhouseMv.OfficeAddress,
WarehouseAddress = dBhouseMv.WarehouseAddress,
OwnerName = dBhouseMv.OwnerName,
OwnerMoble = dBhouseMv.OwnerMoble,
EmailAddress = dBhouseMv.EmailAddress,
CreateDate = DateTime.Now,
ModifiedDate = DateTime.Now,
Cluster_id = dBhouseMv.ClusterId,
Zone_id = dBhouseMv.ZoneId,
PriceBuandle_id = dBhouseMv.PriceBuandleId,
DeliveryModuleStatus = dBhouseMv.DeliveryModuleStatus,
Status = dBhouseMv.Status,
MV = dBhouseMv.Mv,
NMV = dBhouseMv.Nmv,
Remark = dBhouseMv.Remark,
};
Db.tbld_distribution_house.Add(tbldDistributionHouse);
Db.SaveChanges();
int dBid = tbldDistributionHouse.DB_Id;
tblt_System tbltSystem = new tblt_System
{
DBid = dBid,
CurrentDate = DateTime.Now.Date,
NextDate = DateTime.Now.Date.AddDays(1),
PreviousDate = DateTime.Now.Date.AddDays(-1),
UpdateDate = DateTime.Now
};
Db.tblt_System.Add(tbltSystem);
Db.SaveChanges();
TempData["alertbox"] = "success";
TempData["alertboxMsg"] = dBhouseMv.DbName + " Create Successfully";
return(RedirectToAction("Index"));
}
ViewBag.Cluster = new SelectList(Db.tbld_cluster.ToList(), "id", "name");
ViewBag.Zone = new SelectList(Db.tbld_business_zone.Where(x => x.biz_zone_category_id == 4).ToList(), "id", "biz_zone_name");
ViewBag.PriceBuandle = new SelectList(Db.tbld_bundle_price.ToList(), "Id", "Name");
ViewBag.isactive = new SelectList(Db.status.ToList(), "status_Id", "status_code");
return(View(dBhouseMv));
}
public ActionResult DeleteConfirmed(int id)
{
tbld_distribution_house tbldDistributionHouse = Db.tbld_distribution_house.Find(id);
if (tbldDistributionHouse != null)
{
Db.tbld_distribution_house.Remove(tbldDistributionHouse);
}
Db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbld_distribution_house tbldDistributionHouse = Db.tbld_distribution_house.Find(id);
if (tbldDistributionHouse == null)
{
return(HttpNotFound());
}
return(View(tbldDistributionHouse));
}
public ActionResult Edit(DBhouseMv dBhouseMv)
{
if (ModelState.IsValid)
{
tbld_distribution_house tbldDistributionHouse = new tbld_distribution_house
{
DB_Id = dBhouseMv.DbId,
DBName = dBhouseMv.DbName,
DBCode = dBhouseMv.DbCode,
DBDescription = dBhouseMv.DbDescription,
OfficeAddress = dBhouseMv.OfficeAddress,
WarehouseAddress = dBhouseMv.WarehouseAddress,
OwnerName = dBhouseMv.OwnerName,
OwnerMoble = dBhouseMv.OwnerMoble,
EmailAddress = dBhouseMv.EmailAddress,
CreateDate = dBhouseMv.CreateDate,
ModifiedDate = DateTime.Now,
Cluster_id = dBhouseMv.ClusterId,
Zone_id = dBhouseMv.ZoneId,
PriceBuandle_id = dBhouseMv.PriceBuandleId,
DeliveryModuleStatus = dBhouseMv.DeliveryModuleStatus,
Status = dBhouseMv.Status,
MV = dBhouseMv.Mv,
NMV = dBhouseMv.Nmv,
Remark = dBhouseMv.Remark,
LastReplacement = dBhouseMv.LastReplacement
};
if (dBhouseMv.IsReplacement == true)
{
tbldDistributionHouse.LastReplacement = DateTime.Today;
}
Db.Entry(tbldDistributionHouse).State = EntityState.Modified;
Db.SaveChanges();
TempData["alertbox"] = "success";
TempData["alertboxMsg"] = dBhouseMv.DbName + " Edit Successfully";
return(RedirectToAction("Index"));
}
ViewBag.Cluster = new SelectList(Db.tbld_cluster.ToList(), "id", "name");
ViewBag.Zone = new SelectList(Db.tbld_business_zone.Where(x => x.biz_zone_category_id == 4).ToList(), "id", "biz_zone_name");
ViewBag.PriceBuandle = new SelectList(Db.tbld_bundle_price.ToList(), "Id", "Name");
ViewBag.isactive = new SelectList(Db.status.ToList(), "status_Id", "status_code");
return(View(dBhouseMv));
}
// GET: DBhouse/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbld_distribution_house tbldDistributionHouse = Db.tbld_distribution_house.Find(id);
if (tbldDistributionHouse != null)
{
DBhouseMv dBhouseMv = new DBhouseMv
{
DbId = tbldDistributionHouse.DB_Id,
DbName = tbldDistributionHouse.DBName,
DbCode = tbldDistributionHouse.DBCode,
DbDescription = tbldDistributionHouse.DBDescription,
OfficeAddress = tbldDistributionHouse.OfficeAddress,
WarehouseAddress = tbldDistributionHouse.WarehouseAddress,
OwnerName = tbldDistributionHouse.OwnerName,
OwnerMoble = tbldDistributionHouse.OwnerMoble,
EmailAddress = tbldDistributionHouse.EmailAddress,
CreateDate = tbldDistributionHouse.CreateDate,
ModifiedDate = tbldDistributionHouse.ModifiedDate,
ClusterId = tbldDistributionHouse.Cluster_id,
ZoneId = tbldDistributionHouse.Zone_id,
PriceBuandleId = tbldDistributionHouse.PriceBuandle_id,
DeliveryModuleStatus = tbldDistributionHouse.DeliveryModuleStatus,
Status = tbldDistributionHouse.Status,
Mv = tbldDistributionHouse.MV,
Nmv = tbldDistributionHouse.NMV,
LastReplacement = tbldDistributionHouse.LastReplacement,
Remark = tbldDistributionHouse.Remark
};
dBhouseMv.ModifiedDate = DateTime.Now;
ViewBag.Cluster = new SelectList(Db.tbld_cluster.ToList(), "id", "name");
ViewBag.Zone = new SelectList(Db.tbld_business_zone.Where(x => x.biz_zone_category_id == 4).ToList(), "id", "biz_zone_name");
ViewBag.PriceBuandle = new SelectList(Db.tbld_bundle_price.ToList(), "Id", "Name");
ViewBag.isactive = new SelectList(Db.status.ToList(), "status_Id", "status_code");
return(View(dBhouseMv));
}
return(RedirectToAction("Index"));
}