public void EditAssetPurchaseItem(FA_PurchaseItem purchaseitem)
{
string sql = " update FA_PurchaseItem set " +
" OrganizationId=@OrganizationId, PurchaseId=@PurchaseId, " +
" AssetItemId=@AssetItemId, PurchaseQuantity=@PurchaseQuantity, Rate=@Rate, Total=@Total," +
" RegisterToAsset=@RegisterToAsset, IsDeleted =@IsDeleted, " +
" LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate" +
" where PurchaseItemId=@PurchaseItemId";
using (var db = DbHelper.GetDBConnection())
{
db.Query <int>(sql, purchaseitem).SingleOrDefault();
}
}
public ActionResult SavePurchaseitem(string PurchaseItemId = "", string PurchaseId = "", string AssetItemId = "", string UnitId = "", string PurchaseQuantity = "", string Rate = "", string Total = "", string RegisterToAsset = "")
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
FA_PurchaseItem pitem;//
if (string.IsNullOrEmpty(PurchaseItemId) || PurchaseItemId == "0")
{
pitem = new FA_PurchaseItem();
pitem.PurchaseId = Convert.ToInt32(PurchaseId);
pitem.OrganizationId = orgid;// orgid;
pitem.AssetItemId = Convert.ToInt32(AssetItemId);
pitem.PurchaseQuantity = Convert.ToInt32(PurchaseQuantity);
pitem.Rate = Convert.ToDecimal(Rate);
pitem.Total = Convert.ToDecimal(Total);
pitem.RegisterToAsset = RegisterToAsset == "N" ? false : true;
pitem.EnteredBy = uid;
pitem.IsDeleted = false;
pitem.EnteredDate = DateTime.Now;
int pid = db.AddAssetPurchaseItem(pitem);
return(Json(new { result = pid }));
}
else
{
pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(PurchaseItemId));
pitem.PurchaseId = Convert.ToInt32(PurchaseId);
pitem.OrganizationId = orgid;// orgid;
pitem.AssetItemId = Convert.ToInt32(AssetItemId);
pitem.PurchaseQuantity = Convert.ToInt32(PurchaseQuantity);
pitem.Rate = Convert.ToDecimal(Rate);
pitem.Total = Convert.ToDecimal(Total);
pitem.RegisterToAsset = RegisterToAsset == "N" ? false : true;
//pitem.Rate = Convert.ToDecimal(Rate);
//pitem.Total = Convert.ToDecimal(Total);
pitem.LastUpdatedBy = uid;
pitem.IsDeleted = false;
pitem.LastUpdatedDate = DateTime.Now;
db.EditAssetPurchaseItem(pitem);
return(Json(new { result = PurchaseItemId }));
}
}
public int AddAssetPurchaseItem(FA_PurchaseItem purchaseitem)
{
string sql = " insert into FA_PurchaseItem (" +
"OrganizationId, PurchaseId, AssetItemId, PurchaseQuantity, Rate, Total," +
" RegisterToAsset, ReturnedQuantity, ReturnedBy, ReturnedDate, IsVerified, VerifiedBy," +
" VerifiedDate, EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted," +
" DeletedDate, DeletedBy" +
")" +
" values " +
" (" +
"@OrganizationId, @PurchaseId, @AssetItemId, @PurchaseQuantity, @Rate, @Total," +
" @RegisterToAsset, 0, 0, null, @IsVerified, @VerifiedBy," +
" @VerifiedDate, @EnteredBy, @EnteredDate, 0, null, 0," +
" null, 0 " +
") SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
int a = db.Query <int>(sql, purchaseitem).SingleOrDefault();
return(a);
}
}
public ActionResult Create(FormCollection frm, string[] hddrowindex)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
FA_Purchase pbill = new FA_Purchase();
FA_PurchaseItem pitem;//= new INV_SoldItem();
int purchaseid = 0;
var cdate = DateTime.Now;
try
{
if (frm["PurchaseId"] == "0")
{
pbill = new FA_Purchase();
pbill.OrganizationId = orgid;
pbill.VendorId = string.IsNullOrEmpty(frm["VendorId"]) ? 0 : Convert.ToInt32(frm["VendorId"]);
pbill.BillNo = frm["BillNo"];
pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]);
pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]);
ViewBag.BSN2 = Convert.ToInt32(frm["BillSerialNo"]) + 1;
pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null);
pbill.BillDateBS = frm["BillDateBS"];
pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]);
//pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]);
pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
if (frm["VatApplicable"] == "Yes")
{
pbill.VatApplicable = true;
pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]);
pbill.VATPercent = Convert.ToInt32(frm["VATPercent"]);
}
else
{
pbill.VatApplicable = false;
pbill.VatAmount = 0;
pbill.VATPercent = 0;
}
pbill.DiscountAmount = 0;// Convert.ToDecimal(frm["DiscountAmount"]);
pbill.EnteredBy = uid;
pbill.EnteredDate = cdate;
pbill.IsVerified = true;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
purchaseid = db.AddAssetPurchase(pbill);
//purchaseid = db.AddInvetoryPurchase(pbill);
}
else
{
purchaseid = Convert.ToInt32(frm["PurchaseId"]);
pbill = db.GetPurchaseById(orgid, purchaseid);
//pbill.OrganizationId = orgid;
pbill.VendorId = string.IsNullOrEmpty(frm["VendorId"]) ? 0 : Convert.ToInt32(frm["VendorId"]);
pbill.BillNo = frm["BillNo"];
pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]);
ViewBag.BSN2 = Convert.ToInt32(frm["BillSerialNo"]) + 1;
pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null);
pbill.BillDateBS = frm["BillDateBS"];
pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]);
//pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]);
pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
if (frm["VatApplicable"] == "Yes")
{
pbill.VatApplicable = true;
pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]);
pbill.VATPercent = Convert.ToInt32(frm["VATPercent"]);
}
else
{
pbill.VatApplicable = false;
pbill.VatAmount = 0;
pbill.VATPercent = 0;
}
pbill.DiscountAmount = 0;
pbill.LastUpdatedBy = uid;
pbill.LastUpdatedDate = cdate;
pbill.IsDeleted = false;
db.EditAssetPurchase(pbill);
}
if (hddrowindex != null)
{
//INV_SoldItem item;
foreach (var indx in hddrowindex)
{
if (frm["PurchaseItemId-" + indx] == "0")
{
pitem = new FA_PurchaseItem();
pitem.OrganizationId = orgid;
pitem.PurchaseId = purchaseid;
pitem.AssetItemId = Convert.ToInt32(frm["AssetItemId-" + indx]);
pitem.PurchaseQuantity = Convert.ToInt32(frm["PurchaseQuantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.RegisterToAsset = string.IsNullOrEmpty(frm["RegisterToAsset-" + indx]) ? false : true;
pitem.IsReturned = false;
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.EnteredBy = uid;
pitem.EnteredDate = cdate;
pitem.OrganizationId = orgid;
db.AddAssetPurchaseItem(pitem);
}
else
{
pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(frm["PurchaseItemId-" + indx]));
pitem.OrganizationId = orgid;
pitem.PurchaseId = purchaseid;
pitem.AssetItemId = Convert.ToInt32(frm["AssetItemId-" + indx]);
pitem.PurchaseQuantity = Convert.ToInt32(frm["PurchaseQuantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.RegisterToAsset = string.IsNullOrEmpty(frm["RegisterToAsset-" + indx]) ? false : true;
pitem.IsReturned = false;
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.LastUpdatedBy = uid;
pitem.LastUpdatedDate = cdate;
pitem.OrganizationId = orgid;
db.EditAssetPurchaseItem(pitem);
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.CategoryList = ddl.GetAssetCategoryList(orgid);
ViewBag.AssetItemList = ddl.GetAssetItemList(orgid);
ViewBag.UnitList = ddl.GetUnitList(orgid);
ViewBag.VendorId = new SelectList(ddl.GetInvVenodrList(orgid), "Id", "Name");
ViewBag.OrganizationId = orgid;
return(View());
}
}
