// GET: INV_ItemConfiguration/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id);
if (iNV_ItemConfiguration == null)
{
return(HttpNotFound());
}
return(View(iNV_ItemConfiguration));
}
// GET: INV_ItemConfiguration/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal();
INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id);
if (iNV_ItemConfiguration != null)
{
iNV_ItemConfiguration.Remarks = "";
iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal()
{
ItemConfigurationID = iNV_ItemConfiguration.ItemConfigurationID,
MainItemID = iNV_ItemConfiguration.MainItemID,
SubItemID = iNV_ItemConfiguration.SubItemID,
Qunatity = iNV_ItemConfiguration.Qunatity,
UserID = iNV_ItemConfiguration.UserID,
Created = iNV_ItemConfiguration.Created,
Modified = iNV_ItemConfiguration.Modified,
Remarks = iNV_ItemConfiguration.Remarks
};
iNV_ItemConfigurationViewModal.SubItems = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList();
}
if (iNV_ItemConfigurationViewModal == null)
{
return(HttpNotFound());
}
var items =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfiguration.MainItemID);
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfiguration.UserID);
return(View(iNV_ItemConfigurationViewModal));
}
public ActionResult DeleteConfirmed(int id)
{
INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id);
try
{
var LisIiNV_ItemConfiguration = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList();
db.INV_ItemConfiguration.RemoveRange(LisIiNV_ItemConfiguration);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("", "You can not Delete this Employee.");
return(View(iNV_ItemConfiguration));
}
return(RedirectToAction("Index"));
}
public JsonResult Retrieve_INV_ItemConfiguration_List(INV_ItemConfiguration iNV_ItemConfiguration)
{
try
{
if (iNV_ItemConfiguration == null)
{
//erroor
}
if (iNV_ItemConfiguration != null)
{
if (iNV_ItemConfiguration.RetrieveType == true)
{
var itemConfigurationList = db.INV_ItemConfiguration.Where(e => e.MainItemID == iNV_ItemConfiguration.MainItemID).OrderByDescending(e => e.ItemConfigurationID).Select(e => new
{
SubItemID = e.SubItemID,
ItemName = db.INV_Item.Where(i => i.ItemID == e.MainItemID).FirstOrDefault().ItemName,
Qunatity = e.Qunatity
}).FirstOrDefault();
return(Json(itemConfigurationList, JsonRequestBehavior.AllowGet));
}
else if (iNV_ItemConfiguration.RetrieveType == false)
{
var itemConfigurationList = db.INV_ItemConfiguration.Where(e => e.MainItemID == iNV_ItemConfiguration.MainItemID).OrderByDescending(e => e.ItemConfigurationID).Select(e => new
{
SubItemID = e.SubItemID,
ItemName = db.INV_Item.Where(i => i.ItemID == e.SubItemID).FirstOrDefault().ItemName,
Qunatity = e.Qunatity,
MainItemID = e.MainItemID
}).ToList();
return(Json(itemConfigurationList, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception exception)
{
//exception handiling
}
return(Json("failure", JsonRequestBehavior.AllowGet));
}
public JsonResult SaveMainItem(INV_ItemConfiguration iNV_ItemConfiguration)
{
try
{
if (iNV_ItemConfiguration != null)
{
//erroor handle
}
if (iNV_ItemConfiguration != null)
{
if (Session["UserID"] != null)
{
iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
var inv_Item = db.INV_Item.Where(e => e.ItemID == iNV_ItemConfiguration.MainItemID).FirstOrDefault();
string getIssueLastNumber;
if (inv_Item != null)
{
var getIssueLast = db.INV_StockHistory.Where(e => e.Remarks == "Return").OrderByDescending(e => e.StockHistoryID).FirstOrDefault();
if (getIssueLast == null)
{
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "01";
#region Check No
INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault();
if (_INV_StockHistoryNo != null)
{
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "02";
}
#endregion Check No
}
else
{
var a = getIssueLast.IssueNumber;
if (a == null)
{
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "01";
#region Check No
INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault();
if (_INV_StockHistoryNo != null)
{
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "02";
}
#endregion Check No
}
else
{
//a = "278201801";
a = a.ToString();
string delimiters = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString();
//bool aaa = a.Contains(delimiters);
string[] newstring = a.Split(new[] { delimiters }, StringSplitOptions.None);
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + (Convert.ToInt32(newstring[1]) + 1);
#region Check No
INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault();
if (_INV_StockHistoryNo != null)
{
getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + (Convert.ToInt32(newstring[1]) + 2);
}
#endregion Check No
}
}
INV_StockHistory new_INV_StockHistory = new INV_StockHistory();
new_INV_StockHistory.ItemID = inv_Item.ItemID;
new_INV_StockHistory.OperationTypeID = 7;
new_INV_StockHistory.ReferenceID = getIssueLastNumber;
new_INV_StockHistory.Quantity = inv_Item.Quantity;
new_INV_StockHistory.UserID = iNV_ItemConfiguration.UserID;
new_INV_StockHistory.Created = DateTime.Now;
new_INV_StockHistory.Modified = DateTime.Now;
new_INV_StockHistory.Remarks = "Return";
new_INV_StockHistory.FinYearID = CommonConfig.GetFinYearID();
new_INV_StockHistory.ReturnNumber = getIssueLastNumber;
db.INV_StockHistory.Add(new_INV_StockHistory);
db.SaveChanges();
inv_Item.Quantity = inv_Item.Quantity + iNV_ItemConfiguration.Qunatity;
db.SaveChanges();
}
}
}
catch (Exception exception)
{
//exception handiling
}
return(Json("failure", JsonRequestBehavior.AllowGet));
}
public ActionResult Create(INV_ItemConfiguration iNV_ItemConfiguration)
{
//if (db.INV_ItemConfiguration.Where(I => I.MainItemID == iNV_ItemConfiguration.MainItemID).Count() > 0)
//{
// ModelState.AddModelError("ItemNameDuplicate", "Selected item is already configured.");
//}
if (iNV_ItemConfiguration.ItemConfigurationID > 0)
{
if (iNV_ItemConfiguration.Remarks == null || iNV_ItemConfiguration.Remarks == "")
{
var items =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
iNV_ItemConfiguration.INV_Items = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList();
ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfiguration.MainItemID);
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfiguration.UserID);
ModelState.AddModelError("", "Enter Remarks");
return(View(iNV_ItemConfiguration));
}
}
if (iNV_ItemConfiguration.INV_Items != null)
{
if (ModelState.IsValid)
{
iNV_ItemConfiguration.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
var ToRemovedbINV_ItemConfiguration = db.INV_ItemConfiguration.Where(i => i.MainItemID == iNV_ItemConfiguration.MainItemID).ToList();
db.INV_ItemConfiguration.RemoveRange(ToRemovedbINV_ItemConfiguration);
db.SaveChanges();
String Err = "";
List <INV_ItemConfiguration> newINV_ItemConfiguration = new List <INV_ItemConfiguration>();
foreach (var item in iNV_ItemConfiguration.INV_Items)
{
if (item.Qunatity <= 0)
{
INV_Item _Subitem = db.INV_Item.Find(item.SubItemID);
if (_Subitem != null)
{
if (Err == "")
{
Err = "Enter Valid Quantity for " + _Subitem.ItemName;
}
else
{
Err += ", Enter Valid Quantity for " + _Subitem.ItemName;
}
}
}
INV_ItemConfiguration new_INV_InvoiceItem = new INV_ItemConfiguration();
new_INV_InvoiceItem.MainItemID = iNV_ItemConfiguration.MainItemID;
new_INV_InvoiceItem.SubItemID = item.SubItemID;
new_INV_InvoiceItem.Qunatity = item.Qunatity;
new_INV_InvoiceItem.Created = DateTime.Now;
new_INV_InvoiceItem.Modified = DateTime.Now;
new_INV_InvoiceItem.UserID = iNV_ItemConfiguration.UserID;
new_INV_InvoiceItem.Remarks = iNV_ItemConfiguration.Remarks;
newINV_ItemConfiguration.Add(new_INV_InvoiceItem);
}
if (Err != "")
{
var items =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName");
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName");
TempData["errorConfig"] = Err;
return(View(iNV_ItemConfiguration));
}
db.INV_ItemConfiguration.AddRange(newINV_ItemConfiguration);
db.SaveChanges();
}
}
var itemsa =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
ViewBag.MainItemID = new SelectList(itemsa, "ItemID", "ItemName");
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName");
INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal();
ViewData["errorConfig"] = TempData["errorConfig"];
return(View("Edit", iNV_ItemConfigurationViewModal));
}
public ActionResult Edit(INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal)
{
if (iNV_ItemConfigurationViewModal.ItemConfigurationID > 0)
{
if (iNV_ItemConfigurationViewModal.Remarks == null || iNV_ItemConfigurationViewModal.Remarks == "")
{
var items =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
iNV_ItemConfigurationViewModal.SubItems = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfigurationViewModal.MainItemID).ToList();
ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfigurationViewModal.MainItemID);
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfigurationViewModal.UserID);
ModelState.AddModelError("", "Enter Remarks");
return(View(iNV_ItemConfigurationViewModal));
}
}
if (iNV_ItemConfigurationViewModal.SubItems.Count > 0)
{
if (ModelState.IsValid)
{
INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(iNV_ItemConfigurationViewModal.ItemConfigurationID);
db.Entry(iNV_ItemConfiguration).State = EntityState.Modified;
iNV_ItemConfiguration.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
String Err = "";
TempData["errorIssue"] = "";
List <INV_ItemConfiguration> newINV_ItemConfiguration = new List <INV_ItemConfiguration>();
foreach (var item in iNV_ItemConfiguration.INV_Items)
{
if (item.Qunatity <= 0)
{
INV_Item _Subitem = db.INV_Item.Find(item.SubItemID);
if (_Subitem != null)
{
if (Err == "")
{
Err = "Enter Valid Quantity for " + _Subitem.ItemName;
}
else
{
Err += ", Enter Valid Quantity for " + _Subitem.ItemName;
}
}
}
INV_ItemConfiguration new_INV_InvoiceItem = new INV_ItemConfiguration();
new_INV_InvoiceItem.MainItemID = iNV_ItemConfiguration.MainItemID;
new_INV_InvoiceItem.SubItemID = item.SubItemID;
new_INV_InvoiceItem.Qunatity = item.Qunatity;
new_INV_InvoiceItem.Created = DateTime.Now;
new_INV_InvoiceItem.Modified = DateTime.Now;
INV_ItemConfiguration dbINV_ItemConfiguration = db.INV_ItemConfiguration.Where(i => i.MainItemID == item.MainItemID & i.SubItemID == item.SubItemID).FirstOrDefault();
if (dbINV_ItemConfiguration == null)
{
newINV_ItemConfiguration.Add(new_INV_InvoiceItem);
}
}
if (Err != "")
{
var items =
db.INV_Item
.Where(i => i.IsLock == true && i.IsConfigurable == true)
.Select(s => new
{
ItemID = s.ItemID,
ItemName = s.ItemName + " - " + s.ItemCode
})
.ToList();
ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName");
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName");
TempData["errorConfig"] = Err;
return(View(iNV_ItemConfiguration));
}
db.INV_ItemConfiguration.AddRange(newINV_ItemConfiguration);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.MainItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true && i.IsConfigurable == true), "ItemID", "ItemName");
ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName");
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfigurationViewModal.UserID);
return(RedirectToAction("Index"));
}
