public ActionResult Create(tbl_SellerDetails tbl_sellerdetails)
{
if (ModelState.IsValid)
{
tbl_sellerdetails.CreatedBy = User.Identity.Name;
tbl_sellerdetails.CreatedDate = DateTime.Now;
tbl_sellerdetails.IsActive = true;
if (Request.Form["ProductCategories"] != null)
{
foreach (var categoryId in Request.Form["ProductCategories"].Split(','))
{
int cid = Convert.ToInt32(categoryId);
tbl_ProductCategory entity = (from c in db.tbl_ProductCategory
where c.Category_Id == cid
select c
).First();
tbl_sellerdetails.tbl_ProductCategory.Add(entity);
}
}
db.tbl_SellerDetails.AddObject(tbl_sellerdetails);
//Audit
db.tbl_AuditTrail.AddObject(new tbl_AuditTrail
{
Action = "CREATE",
ActionItem = "Seller",
UserName = User.Identity.Name,
ActionDate = DateTime.Now
});
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.City = new SelectList(db.tbl_City, "City_Id", "City_Name", tbl_sellerdetails.City);
ViewBag.SellerType_Id = new SelectList(db.tbl_SellerType, "SellerType_Id", "Seller_Type", tbl_sellerdetails.SellerType_Id);
ViewBag.State = new SelectList(db.tbl_State, "State_Id", "State_Name", tbl_sellerdetails.State);
ViewBag.ProductCategories = new SelectList(db.tbl_ProductCategory, "Category_Id", "Category_Name");
return View(tbl_sellerdetails);
}
/// <summary>
/// Deprecated Method for adding a new object to the tbl_SellerDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotbl_SellerDetails(tbl_SellerDetails tbl_SellerDetails)
{
base.AddObject("tbl_SellerDetails", tbl_SellerDetails);
}
/// <summary>
/// Create a new tbl_SellerDetails object.
/// </summary>
/// <param name="seller_Id">Initial value of the Seller_Id property.</param>
/// <param name="sellerType_Id">Initial value of the SellerType_Id property.</param>
/// <param name="state">Initial value of the State property.</param>
/// <param name="city">Initial value of the City property.</param>
/// <param name="createdBy">Initial value of the CreatedBy property.</param>
/// <param name="createdDate">Initial value of the CreatedDate property.</param>
public static tbl_SellerDetails Createtbl_SellerDetails(global::System.Int32 seller_Id, global::System.Int32 sellerType_Id, global::System.Int32 state, global::System.Int32 city, global::System.String createdBy, global::System.DateTime createdDate)
{
tbl_SellerDetails tbl_SellerDetails = new tbl_SellerDetails();
tbl_SellerDetails.Seller_Id = seller_Id;
tbl_SellerDetails.SellerType_Id = sellerType_Id;
tbl_SellerDetails.State = state;
tbl_SellerDetails.City = city;
tbl_SellerDetails.CreatedBy = createdBy;
tbl_SellerDetails.CreatedDate = createdDate;
return tbl_SellerDetails;
}
public ActionResult Edit(tbl_SellerDetails tbl_sellerdetails)
{
tbl_sellerdetails.ModifiedBy = User.Identity.Name;
tbl_sellerdetails.ModifiedDate = DateTime.Now;
tbl_sellerdetails.CreatedBy = User.Identity.Name;
if (ModelState.IsValid)
{
String sql = String.Format("DELETE FROM [tbl_SellerProductCategories] WHERE Seller_Id={0}",tbl_sellerdetails.Seller_Id);
db.ExecuteStoreCommand(sql);
if (Request.Form["ProductCategories"] != null)
{
foreach (var categoryId in Request.Form["ProductCategories"].Split(','))
{
int cid = Convert.ToInt32(categoryId);
tbl_ProductCategory entity = (from c in db.tbl_ProductCategory
where c.Category_Id == cid
select c
).First();
tbl_sellerdetails.tbl_ProductCategory.Add(entity);
}
}
if( tbl_sellerdetails.EntityState == System.Data.EntityState.Detached)
db.tbl_SellerDetails.Attach(tbl_sellerdetails);
db.ObjectStateManager.ChangeObjectState(tbl_sellerdetails, EntityState.Modified);
//Audit
db.tbl_AuditTrail.AddObject(new tbl_AuditTrail
{
Action = "EDIT",
ActionItem = "Seller",
UserName = User.Identity.Name,
ActionDate = DateTime.Now
});
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.City = new SelectList(db.tbl_City, "City_Id", "City_Name", tbl_sellerdetails.City);
ViewBag.SellerType_Id = new SelectList(db.tbl_SellerType, "SellerType_Id", "Seller_Type", tbl_sellerdetails.SellerType_Id);
ViewBag.State = new SelectList(db.tbl_State, "State_Id", "State_Name", tbl_sellerdetails.State);
ViewBag.ProductCategories = new SelectList(db.tbl_ProductCategory, "Category_Id", "Category_Name");
ViewBag.SelectedProductCategories = tbl_sellerdetails.tbl_ProductCategory.Select(t => t.Category_Id).ToArray();
return View(tbl_sellerdetails);
}
