public void EditInventoryPurchaseItem(INV_PurchaseItem purchaseitem)
{
string sql = " Update INV_PurchaseItem set" +
" DepartmentId=@DepartmentId, ItemId=@ItemId, PurchaseQuantity=@PurchaseQuantity, Rate=@Rate, Total=@Total," +
" LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate, IsDeleted=@IsDeleted, DeletedBy=@DeletedBy, DeletedDate=@DeletedDate" +
" where PurchaseItemId=@PurchaseItemId";
using (var db = DbHelper.GetDBConnection())
{
db.Query(sql, purchaseitem);
db.Close();
}
}
public void EditInvetoryPurchaseItem(INV_PurchaseItem purchaseitem)
{
string sql = " update INV_PurchaseItem set " +
" PurchaseId=@PurchaseId,ItemId=@ItemId,UnitId=@UnitId,Quantity=@Quantity ,Rate=@Rate,Total=@Total," +
//" ReturnedUnitId=@ReturnedUnitId ,ReturnedQuantity=@ReturnedQuantity," +
//" ReturnedVerified=@ReturnedVerified, ReturnedDate=@ReturnedDate,ReturnedBy=@ReturnedBy,ReturnRemarks, IsVerified,VerifiedBy," +
// " VerifiedDate ,"+
"IsVerified = @Isverified, VerifiedBy = @VerifiedBy, VerifiedDate=@VerifiedDate," +
" IsDeleted=@IsDeleted," + //,DeletedBy=@DeletedBy, DeletedDate, EnteredDate,EnteredBy," +
" LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate,OrganizationId=@OrganizationId" +
" where PurchaseitemId=@PurchaseitemId";
using (var db = DbHelper.GetDBConnection())
{
db.Query <int>(sql, purchaseitem).SingleOrDefault();
}
}
public ActionResult SavePurchaseitem(string PurchaseItemId = "", string PurchaseId = "", string ItemId = "", string UnitId = "", string Quantity = "", string Rate = "", string Total = "")
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
INV_PurchaseItem pitem;//
if (string.IsNullOrEmpty(PurchaseItemId) || PurchaseItemId == "0")
{
pitem = new INV_PurchaseItem();
pitem.PurchaseId = Convert.ToInt32(PurchaseId);
pitem.OrganizationId = orgid;// orgid;
pitem.ItemId = Convert.ToInt32(ItemId);
pitem.UnitId = Convert.ToInt32(UnitId);
pitem.Quantity = Convert.ToInt32(Quantity);
pitem.Rate = Convert.ToDecimal(Rate);
pitem.Total = Convert.ToDecimal(Total);
pitem.EnteredBy = uid;
pitem.IsDeleted = false;
pitem.EnteredDate = DateTime.Now;
int itemId = Convert.ToInt32(ItemId);
int quantity = Convert.ToInt32(Quantity);
int sid = db.AddStockItem(itemId, quantity, orgid);
int pid = db.AddInvetoryPurchaseItem(pitem);
return(Json(new { result = pid }));
}
else
{
pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(PurchaseItemId));
pitem.PurchaseId = Convert.ToInt32(PurchaseId);
pitem.OrganizationId = orgid;// orgid;
pitem.ItemId = Convert.ToInt32(ItemId);
pitem.UnitId = Convert.ToInt32(UnitId);
pitem.Quantity = Convert.ToInt32(Quantity);
pitem.Rate = Convert.ToDecimal(Rate);
pitem.Total = Convert.ToDecimal(Total);
pitem.LastUpdatedBy = uid;
pitem.IsDeleted = false;
pitem.LastUpdatedDate = DateTime.Now;
db.EditInvetoryPurchaseItem(pitem);
return(Json(new { result = PurchaseItemId }));
}
}
public int AddInvetoryPurchaseItem(INV_PurchaseItem purchaseitem)
{
string sql = " insert into INV_PurchaseItem(" +
"PurchaseId,ItemId,UnitId,Quantity ,Rate,Total,ReturnedUnitId ,ReturnedQuantity," +
" ReturnedVerified, ReturnedDate,ReturnedBy,ReturnRemarks, IsVerified,VerifiedBy," +
" VerifiedDate , IsDeleted,DeletedBy, DeletedDate, EnteredDate,EnteredBy," +
" LastUpdatedBy, LastUpdatedDate,OrganizationId" +
")" +
" values " +
" (@PurchaseId,@ItemId,@UnitId,@Quantity ,@Rate,@Total,@ReturnedUnitId,@ReturnedQuantity," +
" @ReturnedVerified, @ReturnedDate,@ReturnedBy,@ReturnRemarks, @IsVerified,@VerifiedBy," +
" @VerifiedDate ,@IsDeleted,@DeletedBy, @DeletedDate, @EnteredDate,@EnteredBy," +
" @LastUpdatedBy, @LastUpdatedDate,@OrganizationId) SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
int a = db.Query <int>(sql, purchaseitem).SingleOrDefault();
return(a);
}
}
public int AddInventoryPurchaseItem(INV_PurchaseItem purchaseitem)
{
string sql = " insert into INV_PurchaseItem(" +
"DepartmentId, PurchaseBillId, ItemId, PurchaseQuantity, Rate, UnitId, Total," +
" IsVerified, VerifiedBy," +
" VerifiedDate, EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted," +
" DeletedDate, DeletedBy" +
")" +
" values(" +
"@DepartmentId, @PurchaseBillId, @ItemId, @PurchaseQuantity, @Rate, @UnitId, @Total," +
" @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();
db.Close();
return(a);
}
}
//[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
INV_PurchaseBill pbill = new INV_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.AddInventoryPurchase(pbill);
//Purchase Item Add
if (hddrowindex != null)
{
for (int i = 1; i <= totalcount; i++)
{
if (i == Convert.ToInt32(frm["" + i]))
{
INV_PurchaseItem pitem = new INV_PurchaseItem();
pitem.DepartmentId = depid;
pitem.PurchaseBillId = purchaseid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + i]);
pitem.PurchaseQuantity = Convert.ToDecimal(frm["Quantity-" + i]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]);
pitem.UnitId = Convert.ToInt32(frm["UnitId-" + 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.AddInventoryPurchaseItem(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.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 ActionResult Create(FormCollection frm, string[] hddrowindex)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
INV_PurchaseBill pbill = new INV_PurchaseBill();
INV_PurchaseItem pitem; //= new INV_SoldItem();
int purchaseid = 0;
var cdate = DateTime.Now;
try
{
//var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"]));
if (frm["PurchaseId"] == "0")
{
db.EditInvetoryPurchase(pbill);
pbill.VendorId = Convert.ToInt32(frm["VendorId"]);
pbill.BillNo = frm["BillNo"];
pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]);
pbill.Remarks = frm["Remarks"];
pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null);
pbill.BillDateBS = frm["BillDateBS"];
pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]);
pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false;
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.ShippingCharge = 0; // frm[""];
pbill.DiscountAmount = 0; // Convert.ToDecimal(frm["DiscountAmount"]);
//pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.OrganizationId = orgid;
pbill.EnteredBy = uid;
pbill.EnteredDate = cdate;
pbill.IsVerified = true;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
purchaseid = db.AddInvetoryPurchase(pbill);
}
else
{
purchaseid = Convert.ToInt32(frm["PurchaseId"]);
pbill = db.GetPurchaseBillById(orgid, purchaseid);
pbill.VendorId = Convert.ToInt32(frm["VendorId"]);
pbill.BillNo = frm["BillNo"];
pbill.Remarks = frm["Remarks"];
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.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false;
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.ShippingCharge = 0; // frm[""];
pbill.DiscountAmount = 0; // Convert.ToDecimal(frm["DiscountAmount"]);
//pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.OrganizationId = orgid;
pbill.EnteredBy = uid;
pbill.EnteredDate = cdate;
pbill.IsVerified = true;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
db.EditInvetoryPurchase(pbill);
}
if (hddrowindex != null)
{
//INV_SoldItem item;
foreach (var indx in hddrowindex)
{
if (frm["PurchaseItemId-" + indx] == "0")
{
pitem = new INV_PurchaseItem();
pitem.PurchaseId = purchaseid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]);
pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]);
pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.IsReturned = false;
//pitem.ReturnedUnitId = frm[""];
//pitem.ReturnedQuantity = frm[""];
//pitem.ReturnedVerified = frm[""];
//pitem.ReturnedDate = frm[""];
//pitem.ReturnedBy = frm[""];
//pitem.ReturnRemarks = frm[""];
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.EnteredBy = uid;
pitem.EnteredDate = cdate;
pitem.OrganizationId = orgid;
db.AddInvetoryPurchaseItem(pitem);
}
else
{
pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(frm["PurchaseItemId-" + indx]));
pitem.PurchaseId = purchaseid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]);
pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]);
pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.IsReturned = false;
//pitem.ReturnedUnitId = frm[""];
//pitem.ReturnedQuantity = frm[""];
//pitem.ReturnedVerified = frm[""];
//pitem.ReturnedDate = frm[""];
//pitem.ReturnedBy = frm[""];
//pitem.ReturnRemarks = frm[""];
pitem.IsVerified = true;
pitem.VerifiedBy = uid;
pitem.VerifiedDate = cdate;
pitem.IsDeleted = false;
pitem.EnteredBy = uid;
pitem.EnteredDate = cdate;
pitem.OrganizationId = orgid;
db.EditInvetoryPurchaseItem(pitem);
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.CategoryList = ddl.GetCategoryList(orgid);
ViewBag.ItemList = ddl.GetItemList(orgid, 0);
ViewBag.UnitList = ddl.GetUnitList(orgid);
ViewBag.VendorId = new SelectList(ddl.GetInvVenodrList(orgid), "Id", "Name");
ViewBag.OrganizationId = orgid;
//ex.Message;
return(View());
}
}
public ActionResult Edit(FormCollection frm, string[] hddrowindex)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
int pid = Convert.ToInt32(frm["PurchaseId"]);
DateTime cdate = DateTime.Now;
INV_PurchaseBill pbill = db.GetPurchaseBillById(orgid, pid);
INV_PurchaseItem pitem;//= new INV_SoldItem();
//var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"]));
try
{
pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false;
pbill.VendorId = Convert.ToInt32(frm["VendorId"]);
pbill.BillNo = frm["BillNo"];
pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null);
pbill.BillDateBS = frm["BillDateBS"];
pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]);
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.ShippingCharge = 0;// frm[""];
pbill.DiscountAmount = Convert.ToDecimal(frm["DiscountAmount"]);
pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]);
pbill.OrganizationId = orgid;
pbill.LastUpdatedBy = uid;
pbill.LastUpdatedDate = cdate;
pbill.IsVerified = true;
pbill.VerifiedBy = uid;
pbill.VerifiedDate = cdate;
pbill.IsDeleted = false;
db.DeleteAllInvetoryItem(pid, uid, DateTime.Now);
db.EditInvetoryPurchase(pbill);
if (hddrowindex != null)
{
//INV_SoldItem item;
foreach (var indx in hddrowindex)
{
if (frm["PurchaseItemId-" + indx] == "0")
{
pitem = new INV_PurchaseItem();
pitem.PurchaseId = pid;
pitem.OrganizationId = orgid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]);
pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]);
pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.EnteredBy = (User as CustomPrincipal).UserId;
pitem.IsDeleted = false;
pitem.EnteredDate = DateTime.Now;
db.AddInvetoryPurchaseItem(pitem);
}
else
{
pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(frm["PurchaseItemId-" + indx]));
pitem.PurchaseId = pid;
pitem.OrganizationId = orgid;
pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]);
pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]);
pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]);
pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]);
pitem.Total = Convert.ToDecimal(frm["Total-" + indx]);
pitem.LastUpdatedBy = uid;
pitem.IsDeleted = false;
pitem.LastUpdatedDate = DateTime.Now;
db.EditInvetoryPurchaseItem(pitem);
}
}
}
}
catch (Exception ex)
{
return(RedirectToAction("Edit", new { id = pid }));
}
return(RedirectToAction("Index"));
}
