public ActionResult Create1(FormCollection frm, string[] hddrowindex)
{
A_AssetRepo aar = new A_AssetRepo();
int depid = Convert.ToInt32(Session["DepartmentId"]);
int uid = Convert.ToInt32(Session["UserId"]);
var cdate = DateTime.Now;
int num = 0;
int totalcount = Convert.ToInt32(frm["hddrowindex"]);
try
{
//Purchase Item Add
if (hddrowindex != null)
{
for (int i = 1; i <= totalcount; i++)
{
if (i == Convert.ToInt32(frm["" + i]))
{
INV_DistributionItem pitem = new INV_DistributionItem();
pitem.DepartmentId = Convert.ToInt32(frm["DepartmentId"]);
//pitem.DistributionBillId = purchaseid;
int tokenId = Convert.ToInt32(frm["TokenId"]);
pitem.ItemId = Convert.ToInt32(frm["ItemId"]);
pitem.SalesQuantity = Convert.ToDecimal(frm["SalesQuantity"]);
//pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]);
pitem.UnitId = Convert.ToInt32(frm["UnitId"]);
//pitem.Total = Convert.ToDecimal(frm["Total-" + i]);
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.EnteredBy = uid;
pitem.EnteredDate = cdate;
num = db.AddInventoryDistributionItem(pitem);
if (num > 0)
{
aar.ApprovedRequestTokenStore(tokenId, uid, cdate);
}
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
//int depid = Convert.ToInt32(Session["DepartmentId"]);
ViewBag.DepartmentId = new SelectList(ddl.getDepartmentList(), "Id", "Name");
ViewBag.CategoryList = new SelectList(ddl.getCategoryList(depid), "Id", "Name");
ViewBag.CategoryId = new SelectList(ddl.getCategoryList(depid), "Id", "Name");
ViewBag.ItemList = new SelectList(ddl.getItemList(depid), "Id", "Name");
ViewBag.UnitList = new SelectList(ddl.getUnitList(depid), "Id", "Name");
ViewBag.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name");
return(View());
}
}
public void EditInventoryDistributionItem(INV_DistributionItem distributionitem)
{
string sql = " Update INV_DistributionItem set" +
" DepartmentId=@DepartmentId, ItemId=@ItemId, SalesQuantity=@SalesQuantity, Rate=@Rate, Total=@Total," +
" LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate, IsDeleted=@IsDeleted, DeletedBy=@DeletedBy, DeletedDate=@DeletedDate" +
" where DistributionItemId=@DistributionItemId";
using (var db = DbHelper.GetDBConnection())
{
db.Query(sql, distributionitem);
db.Close();
}
}
public int AddInventoryDistributionItem(INV_DistributionItem distributionitem)
{
string sql = " insert into INV_DistributionItem(DepartmentId, ItemId, SalesQuantity, UnitId, IsVerified," +
"VerifiedBy,VerifiedDate,IsDeleted,EnteredBy,EnteredDate) " +
"Values(@DepartmentId, @ItemId, @SalesQuantity, @UnitId, @IsVerified, " +
"@VerifiedBy, @VerifiedDate,@IsDeleted,@EnteredBy,@EnteredDate)SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
int a = db.Query <int>(sql, distributionitem).SingleOrDefault();
db.Close();
return(a);
}
}
//[ValidateAntiForgeryToken]
public ActionResult Edit(FormCollection frm, string[] hddrowindex)
{
int depid = Convert.ToInt32(Session["DepartmentId"]);
int uid = Convert.ToInt32(Session["UserId"]);
var cdate = DateTime.Now;
int distributionid = Convert.ToInt32(frm["DistributionBillId"]);
int totalcount = Convert.ToInt32(frm["hddrowindex"]);
try
{
//For bill Section
INV_DistributionBill pbill = new INV_DistributionBill();
pbill.DepartmentId = depid;
pbill.LastUpdatedBy = uid;
pbill.LastUpdatedDate = cdate;
pbill.IsVerified = 1;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
db.EditInventoryDistributionItemDelete(cdate, uid, distributionid);
//db.EditInventoryDistribution(pbill);
//Purchase Item Add
if (hddrowindex != null)
{
INV_DistributionItem pitem = new INV_DistributionItem();
for (int i = 1; i <= totalcount; i++)
{
if (frm["DistributionItemId-" + i] == "0")
{
if (i == Convert.ToInt32(frm["" + i]))
{
pitem.DepartmentId = depid;
pitem.DistributionBillId = distributionid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + i]);
pitem.SalesQuantity = Convert.ToDecimal(frm["Quantity-" + i]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]);
pitem.Total = Convert.ToDecimal(frm["Total-" + i]);
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.EnteredBy = uid;
pitem.EnteredDate = cdate;
db.AddInventoryDistributionItem(pitem);
}
}
else
{
if (i == Convert.ToInt32(frm["" + i]))
{
pitem.DepartmentId = depid;
//pitem.PurchaseBillId = purchaseid;
pitem.DistributionItemId = Convert.ToInt32(frm["PurchaseItemId-" + i]);
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + i]);
pitem.SalesQuantity = Convert.ToDecimal(frm["Quantity-" + i]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]);
pitem.Total = Convert.ToDecimal(frm["Total-" + i]);
//pitem.IsVerified = true;
//pitem.VerifiedBy = uid;
//pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.DeletedBy = 0;
pitem.DeletedDate = null;
pitem.LastUpdatedBy = uid;
pitem.LastUpdatedDate = cdate;
db.EditInventoryDistributionItem(pitem);
}
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
//int depid = Convert.ToInt32(Session["DepartmentId"]);
ViewBag.CategoryList = new SelectList(ddl.getCategoryList(depid), "Id", "Name");
ViewBag.CategoryId = new SelectList(ddl.getCategoryList(depid), "Id", "Name");
ViewBag.ItemList = new SelectList(ddl.getItemList(depid), "Id", "Name");
ViewBag.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name");
return(View());
}
}
