public void EditAssetPurchase(A_PurchaseBill apurchase)
{
string sql = " update A_PurchaseBill set " +
" DepartmentId=@DepartmentId,VendorId=@VendorId, BillNo=@BillNo, BillDate=@BillDate, BillDateBS=@BillDateBS," +
" TotalAmount=@TotalAmount, " +
" VatApplicable=@VatApplicable,VatAmount=@VatAmount,VATPercent=@VATPercent," +
" DiscountAmount=@DiscountAmount,DiscountPercent=@DiscountPercent,TaxableAmount=@TaxableAmount,TotalWithVat=@TotalWithVat," +
" LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate,Remarks=@Remarks" +
" where PurchaseBillId=@PurchaseBillId";
using (var db = DbHelper.GetDBConnection())
{
db.Query(sql, apurchase);
db.Close();
}
}
public int AddAssetPurchase(A_PurchaseBill apurchase)
{
string sql = " insert into A_PurchaseBill (" +
" DepartmentId,VendorId, BillNo, BillDate, BillDateBS, TotalAmount,VatApplicable,VatPercent,VatAmount, IsVerified,Remarks," +
" DiscountAmount,DiscountPercent,TaxableAmount,TotalWithVat,VerifiedBy, VerifiedDate, EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy," +
" DeletedDate, BillSerialNo" +
")" +
" values " +
" (" +
"@DepartmentId,@VendorId, @BillNo, @BillDate, @BillDateBS, @TotalAmount, @VatApplicable,@VatPercent,@VatAmount, @IsVerified,@Remarks," +
" @DiscountAmount,@DiscountPercent,@TaxableAmount,@TotalWithVat,@VerifiedBy, @VerifiedDate, @EnteredBy, @EnteredDate, 0, null, 0, 0," +
" null, @BillSerialNo" +
") SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
int a = db.Query <int>(sql, apurchase).SingleOrDefault();
db.Close();
return(a);
}
}
public ActionResult Create()
{
A_PurchaseBill sn = (db.GetBillSerialNo());
if (sn == null)
{
ViewBag.BSN = 1;
}
else
{
int sn1 = Convert.ToInt32(sn.BillSerialNo) + 1;
ViewBag.BSN = sn1;
}
int depid = Convert.ToInt32(Session["DepartmentId"]);
ViewBag.VendorId = new SelectList(ddl.getVendorList(depid), "Id", "Name");
ViewBag.CategoryList = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.CategoryId = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.AssetItemList = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
ViewBag.AssetItemId = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
return(View());
}
//[ValidateAntiForgeryToken]
public ActionResult Create(FormCollection frm, string[] hddrowindex)
{
int depid = Convert.ToInt32(Session["DepartmentId"]);
int uid = Convert.ToInt32(Session["UserId"]);
var cdate = DateTime.Now;
int purchaseid = 0;
int totalcount = Convert.ToInt32(frm["hddrowindex"]);
try
{
//For bill Section
A_PurchaseBill pbill = new A_PurchaseBill();
pbill.BillDate = frm["BillDate"];
pbill.BillDateBS = frm["BillDateBS"];
pbill.BillNo = frm["BillNo"];
pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]);
pbill.VendorId = Convert.ToInt32(frm["VendorId"]);
pbill.Remarks = frm["Remarks"];
pbill.DepartmentId = depid;
pbill.EnteredBy = uid;
pbill.EnteredDate = cdate;
pbill.IsVerified = 1;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]);
pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.DiscountPercent = Convert.ToInt32(frm["DiscountPercent"]);
pbill.DiscountAmount = Convert.ToDecimal(frm["DiscountAmount"]);
pbill.TaxableAmount = Convert.ToDecimal(frm["TaxableAmount"]);
if (frm["VatApplicable"] == "Yes")
{
pbill.VatApplicable = 1;
pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]);
pbill.VatPercent = Convert.ToInt32(frm["VatPercent"]);
}
else
{
pbill.VatApplicable = 0;
pbill.VatAmount = 0;
pbill.VatPercent = 0;
}
purchaseid = db.AddAssetPurchase(pbill);
//Purchase Item Add
if (hddrowindex != null)
{
for (int i = 1; i <= totalcount; i++)
{
if (i == Convert.ToInt32(frm["" + i]))
{
A_PurchaseItem pitem = new A_PurchaseItem();
pitem.DepartmentId = depid;
pitem.PurchaseBillId = purchaseid;
pitem.AssetItemId = Convert.ToInt32(frm["AssetItemId-" + i]);
pitem.PurchaseQuantity = 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.AddAssetPurchaseItem(pitem);
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
//int depid = Convert.ToInt32(Session["DepartmentId"]);
ViewBag.VendorId = new SelectList(ddl.getVendorList(depid), "Id", "Name");
ViewBag.CategoryList = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.CategoryId = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name");
ViewBag.AssetItemList = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
ViewBag.AssetItemId = new SelectList(ddl.getAssetItemList(depid), "Id", "Name");
return(View());
}
}
