public ActionResult SaveSoldBulkitem(string SoldItemId = "", string SoldBillId = "", string ItemId = "", string UnitId = "", string Quantity = "", string Rate = "", string Total = "", string FirstItemId = "", string LastItemId = "", string FirstId = "", string LastId = "") { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; int uid = (User as CustomPrincipal).UserId; INV_SoldItem solditem;// if ((string.IsNullOrEmpty(SoldItemId) || SoldItemId == "0") || ((string.IsNullOrEmpty(FirstItemId) || FirstItemId == "0") && (string.IsNullOrEmpty(LastItemId) || LastItemId == "0"))) { solditem = new INV_SoldItem(); int firstId = Convert.ToInt32(FirstId); int lastId = Convert.ToInt32(LastId); //int firstItemId = Convert.ToInt32(FirstItemId); //int lastItemId = Convert.ToInt32(LastItemId); solditem.SoldBillId = Convert.ToInt32(SoldBillId); solditem.OrganizationId = orgid;// orgid; solditem.ItemId = Convert.ToInt32(ItemId); solditem.UnitId = Convert.ToInt32(UnitId); solditem.Quantity = Convert.ToInt32(Quantity); solditem.Rate = Convert.ToDecimal(Rate); solditem.Total = Convert.ToDecimal(Total); solditem.EnteredBy = uid; solditem.IsDeleted = false; solditem.EnteredDate = DateTime.Now; int soldid = db.AddInvetorySoldBulkItem(solditem, firstId, lastId); int lastItemId = ddl.GetLastItemNo(); int totstudent = lastId - firstId; int firstItemId = lastItemId - totstudent; db.AddUpdateInvetorySoldBulkItem(solditem, firstItemId, lastItemId); return(Json(new { result = soldid, firstitemId = firstItemId, lastitemId = lastItemId })); } else { solditem = db.GetSoldItemById(orgid, Convert.ToInt32(SoldItemId)); solditem.SoldBillId = Convert.ToInt32(SoldBillId); solditem.OrganizationId = orgid;// orgid; solditem.ItemId = Convert.ToInt32(ItemId); solditem.UnitId = Convert.ToInt32(UnitId); solditem.Quantity = Convert.ToInt32(Quantity); solditem.Rate = Convert.ToDecimal(Rate); solditem.Total = Convert.ToDecimal(Total); solditem.LastUpdatedBy = uid; solditem.IsDeleted = false; solditem.LastUpdatedDate = DateTime.Now; db.EditInvetorySoldItem(solditem); return(Json(new { result = SoldItemId })); } }
public void AddUpdateInvetorySoldBulkItem(INV_SoldItem solditem, int firstItemId, int lastItemId) { string sql = " Update INV_SoldItem set OrganizationId=@OrganizationId, ItemId=@ItemId, UnitId=@UnitId,Quantity=@Quantity," + " Rate=@Rate,Total=@Total,EnteredBy=@EnteredBy,EnteredDate=@EnteredDate,IsDeleted=@IsDeleted, " + " DeletedBy=0,DeletedDate=null,LastUpdatedBy=0" + " where SoldItemId>" + firstItemId + "and SoldItemId<=" + lastItemId; using (var db = DbHelper.GetDBConnection()) { //using (var trsn = db.BeginTransaction()) //{ db.Query <int>(sql, solditem).SingleOrDefault(); // trsn.Commit(); //} } }
public void EditInvetorySoldItem(INV_SoldItem solditem) { string sql = " Update INV_SoldItem set ItemId=@ItemId, UnitId=@UnitId, Quantity=@Quantity,Rate=@Rate," + " Total=@Total,LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate,IsDeleted=@IsDeleted, " + " DeletedBy=0,DeletedDate=null" + " where SoldItemId=@SoldItemId"; using (var db = DbHelper.GetDBConnection()) { //using (var trsn = db.BeginTransaction()) //{ db.Query <int>(sql, solditem).SingleOrDefault(); // trsn.Commit(); //} } }
public int AddInvetorySoldItem(INV_SoldItem solditem) { string sql = " insert into INV_SoldItem (SoldBillId, ItemId,UnitId, Quantity, Rate, Total,OrganizationId,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,IsDeleted,DeletedBy,DeletedDate)" + " values " + " (@SoldBillId, @ItemId,@UnitId, @Quantity, @Rate, @Total, @OrganizationId,@EnteredBy,@EnteredDate,0,null,0,0,null) SELECT CAST(SCOPE_IDENTITY() as int)"; using (var db = DbHelper.GetDBConnection()) { //using (var trsn = db.BeginTransaction()) //{ int id = db.Query <int>(sql, solditem).SingleOrDefault(); db.Close(); return(id); //trsn.Commit(); //} } }
public ActionResult Create(FormCollection frm, string[] hddrowindex) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; INV_SoldBill soldbill = new INV_SoldBill(); INV_SoldItem solditem;//= new INV_SoldItem(); int soldid = 0; //var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if (frm["SoldBillId"] == "0") { soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); if (frm["IsStaff"] == "No") { var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if (student.CurrentClassId != null) { soldbill.ClassId = student.CurrentClassId; } if (student.CurrentSectionId != null) { soldbill.SectionId = student.CurrentSectionId; } soldbill.StudentId = Convert.ToInt32(frm["StudentId"]); soldbill.IsStaff = false; } else { soldbill.StaffId = Convert.ToInt32(frm["StaffId"]); soldbill.IsStaff = true; } soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; soldid = db.AddInvetorySold(soldbill); } else { soldid = Convert.ToInt32(frm["SoldBillId"]); soldbill.SoldBillId = soldid; soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); if (frm["IsStaff"] == "No") { var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if (student.CurrentClassId != null) { soldbill.ClassId = student.CurrentClassId; } if (student.CurrentSectionId != null) { soldbill.SectionId = student.CurrentSectionId; } soldbill.StudentId = Convert.ToInt32(frm["StudentId"]); soldbill.IsStaff = false; } else { soldbill.StaffId = Convert.ToInt32(frm["StaffId"]); soldbill.IsStaff = true; } soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; db.EditInvetorySold(soldbill); } if (hddrowindex != null) { //INV_SoldItem item; foreach (var indx in hddrowindex) { if (frm["SoldItemId-" + indx] == "0") { solditem = new INV_SoldItem(); solditem.SoldBillId = soldid; solditem.OrganizationId = orgid;// orgid; solditem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); solditem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); solditem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); solditem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); solditem.Total = Convert.ToDecimal(frm["Total-" + indx]); solditem.EnteredBy = (User as CustomPrincipal).UserId; solditem.IsDeleted = false; solditem.EnteredDate = DateTime.Now; db.AddInvetorySoldItem(solditem); } } } ViewBag.CategoryList = ddl.GetCategoryList(orgid); ViewBag.ItemList = ddl.GetItemList(orgid, 0); ViewBag.UnitList = ddl.GetUnitList(orgid); ViewBag.BatchId = new SelectList(ddl.GetBatchList(orgid), "Id", "Name"); ViewBag.ClassId = new SelectList(ddl.GetClassList(orgid), "Id", "Name"); ViewBag.SectionId = new SelectList(ddl.GetSectionList(orgid), "Id", "Name"); ViewBag.StaffId = new SelectList(ddl.GetStaffList(orgid), "Id", "Name"); ViewBag.StudentId = new SelectList(ddl.GetStudentList(orgid, 0, 0, 0), "Id", "Name"); ViewBag.OrganizationId = orgid; 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 soldid = Convert.ToInt32(frm["SoldBillId"]); INV_SoldBill soldbill = db.GetSoldBillById(orgid, soldid); INV_SoldItem solditem;//= new INV_SoldItem(); //var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); try { soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid;// orgid; soldbill.BillDateBS = frm["BillDateBS"]; //soldbill.BillNo = frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); if (frm["IsStaff"] == "No") { var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if (student.CurrentClassId != null) { soldbill.ClassId = student.CurrentClassId; } if (student.CurrentSectionId != null) { soldbill.SectionId = student.CurrentSectionId; } soldbill.StudentId = Convert.ToInt32(frm["StudentId"]); soldbill.IsStaff = false; } else { soldbill.StaffId = Convert.ToInt32(frm["StaffId"]); soldbill.IsStaff = true; } soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; db.EditInvetorySold(soldbill); db.DeleteAllInvetoryItem(soldid, uid, DateTime.Now); if (hddrowindex != null) { //INV_SoldItem item; foreach (var indx in hddrowindex) { if (frm["SoldItemId-" + indx] == "0") { solditem = new INV_SoldItem(); solditem.SoldBillId = soldid; solditem.OrganizationId = orgid; solditem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); solditem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); solditem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); solditem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); solditem.Total = Convert.ToDecimal(frm["Total-" + indx]); solditem.EnteredBy = (User as CustomPrincipal).UserId; solditem.IsDeleted = false; solditem.EnteredDate = DateTime.Now; db.AddInvetorySoldItem(solditem); } else { solditem = db.GetSoldItemById(orgid, Convert.ToInt32(frm["SoldItemId-" + indx])); solditem.SoldBillId = soldid; solditem.OrganizationId = orgid; solditem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); solditem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); solditem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); solditem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); solditem.Total = Convert.ToDecimal(frm["Total-" + indx]); solditem.LastUpdatedBy = uid; solditem.IsDeleted = false; solditem.LastUpdatedDate = DateTime.Now; db.EditInvetorySoldItem(solditem); } } } } catch { return(RedirectToAction("Edit", new { id = soldid })); } return(RedirectToAction("Index")); }
public ActionResult BulkCreate(FormCollection frm, string[] hddrowindex) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; INV_SoldBill soldbill = new INV_SoldBill(); INV_SoldItem solditem;//= new INV_SoldItem(); int soldid = 0; //var studentArray = $("#StudentId").val(); string StudentId = frm["StudentId"]; //string first = frm["FirstId"]; //string last = frm["LastId"]; int i = 0; //var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if ((frm["FirstId"] == "" && frm["LastId"] == "")) { if (frm["SectionId"] == "") { soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); soldbill.ClassId = Convert.ToInt32(frm["ClassId"]); soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; //soldid = db.AddInvetorySold(soldbill); //soldid = db.AddInvetoryBulkSold(soldbill, orgid); //int lastNo = ddl.GetLastNo(); //int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(frm["ClassId"])); //int firstNo = lastNo - totstudent; //db.AddUpdateInvetoryBulkSold(soldbill, firstNo, lastNo); if (StudentId == null) { soldid = db.AddInvetoryBulkSold(soldbill, orgid); int lastNo = ddl.GetLastNo(); int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(frm["ClassId"])); int firstNo = lastNo - totstudent; db.AddUpdateInvetoryBulkSold(soldbill, firstNo, lastNo); //return Json(new { result = soldid, firstno = firstNo, lastno = lastNo }); } else { string[] stuId = StudentId.Split(','); foreach (var item in stuId) { db.AddInvetoryBulkSold(soldbill, orgid, Convert.ToInt32(stuId[i])); i++; } int count = i; //int soldid = 0; int lastNo = ddl.GetLastNo(); //int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(ClassId)); int firstNo = lastNo - count; db.AddUpdateInvetoryBulkSold(soldbill, firstNo, lastNo); //return Json(new { result = soldid, firstno = firstNo, lastno = lastNo }); } } else { soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); soldbill.ClassId = Convert.ToInt32(frm["ClassId"]); soldbill.SectionId = Convert.ToInt32(frm["SectionId"]); soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; //soldid = db.AddInvetorySold(soldbill); //soldid = db.AddInvetoryBulkSold1(soldbill, orgid); //int lastNo = ddl.GetLastNo(); //int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(frm["ClassId"]), Convert.ToInt32(frm["SectionId"])); //int firstNo = lastNo - totstudent; //db.AddUpdateInvetoryBulkSold1(soldbill, firstNo, lastNo); if (StudentId == null) { soldid = db.AddInvetoryBulkSold1(soldbill, orgid); int lastNo = ddl.GetLastNo(); int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(frm["ClassId"]), Convert.ToInt32(frm["SectionId"])); int firstNo = lastNo - totstudent; db.AddUpdateInvetoryBulkSold1(soldbill, firstNo, lastNo); //return Json(new { result = soldid, firstno = firstNo, lastno = lastNo }); } else { string[] stuId = StudentId.Split(','); foreach (var item in stuId) { db.AddInvetoryBulkSold2(soldbill, orgid, Convert.ToInt32(stuId[i]), Convert.ToInt32(frm["SectionId"])); i++; } int count = i; //int soldid = 0; int lastNo = ddl.GetLastNo(); //int totstudent = ddl.GetStudentTotal(orgid, Convert.ToInt32(ClassId)); int firstNo = lastNo - count; db.AddUpdateInvetoryBulkSold1(soldbill, firstNo, lastNo); //return Json(new { result = soldid, firstno = firstNo, lastno = lastNo }); } } } else { if (frm["SectionId"] == "") { soldid = Convert.ToInt32(frm["SoldBillId"]); int firstNo = Convert.ToInt32(frm["FirstId"]); int lastNo = Convert.ToInt32(frm["LastId"]); soldbill.SoldBillId = soldid; soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); soldbill.ClassId = Convert.ToInt32(frm["ClassId"]); //soldbill.SectionId = Convert.ToInt32(frm["SectionId"]); soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; db.AddUpdateInvetoryBulkSold(soldbill, firstNo, lastNo); //db.EditInvetorySold(soldbill); } else { soldid = Convert.ToInt32(frm["SoldBillId"]); int firstNo = Convert.ToInt32(frm["FirstId"]); int lastNo = Convert.ToInt32(frm["LastId"]); soldbill.SoldBillId = soldid; soldbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); soldbill.OrganizationId = orgid; // orgid; soldbill.BillDateBS = frm["BillDateBS"]; soldbill.BillNo = (db.GetBillNo(orgid)).ToString("D5"); // frm["BillNo"]; soldbill.GroupNo = frm["GroupNo"]; soldbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); soldbill.ClassId = Convert.ToInt32(frm["ClassId"]); soldbill.SectionId = Convert.ToInt32(frm["SectionId"]); soldbill.IsDeleted = false; soldbill.EnteredBy = (User as CustomPrincipal).UserId; soldbill.EnteredDate = DateTime.Now; db.AddUpdateInvetoryBulkSold1(soldbill, firstNo, lastNo); } } if (hddrowindex != null) { //INV_SoldItem item; foreach (var indx in hddrowindex) { if (frm["SoldItemId-" + indx] == "" || (frm["FirstItemId-" + indx] == "" && frm["LastItemId-" + indx] == "")) { if (StudentId == null) { solditem = new INV_SoldItem(); solditem.SoldBillId = soldid; int lastId = ddl.GetLastNo(); int totstudent1 = ddl.GetStudentTotal(orgid, Convert.ToInt32(frm["ClassId"])); int firstId = lastId - totstudent1; solditem.OrganizationId = orgid;// orgid; solditem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); solditem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); solditem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); solditem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); solditem.Total = Convert.ToDecimal(frm["Total-" + indx]); solditem.EnteredBy = (User as CustomPrincipal).UserId; solditem.IsDeleted = false; solditem.EnteredDate = DateTime.Now; //db.AddInvetorySoldItem(solditem); db.AddInvetorySoldBulkItem(solditem, firstId, lastId); int lastItemId = ddl.GetLastItemNo(); int totstudent = lastId - firstId; int firstItemId = lastItemId - totstudent; db.AddUpdateInvetorySoldBulkItem(solditem, firstItemId, lastItemId); } else { solditem = new INV_SoldItem(); solditem.SoldBillId = soldid; int lastId = ddl.GetLastNo(); int totstudent1 = Convert.ToInt32(frm["TotStudent"]); int firstId = lastId - totstudent1; solditem.OrganizationId = orgid;// orgid; solditem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); solditem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); solditem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); solditem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); solditem.Total = Convert.ToDecimal(frm["Total-" + indx]); solditem.EnteredBy = (User as CustomPrincipal).UserId; solditem.IsDeleted = false; solditem.EnteredDate = DateTime.Now; //db.AddInvetorySoldItem(solditem); db.AddInvetorySoldBulkItem(solditem, firstId, lastId); int lastItemId = ddl.GetLastItemNo(); int totstudent = lastId - firstId; int firstItemId = lastItemId - totstudent; db.AddUpdateInvetorySoldBulkItem(solditem, firstItemId, lastItemId); } } } } ViewBag.CategoryList = ddl.GetCategoryList(orgid); ViewBag.ItemList = ddl.GetItemList(orgid, 0); ViewBag.UnitList = ddl.GetUnitList(orgid); ViewBag.BatchId = new SelectList(ddl.GetBatchList(orgid), "Id", "Name"); ViewBag.ClassId = new SelectList(ddl.GetClassList(orgid), "Id", "Name"); ViewBag.SectionId = new SelectList(ddl.GetSectionList(orgid), "Id", "Name"); ViewBag.StaffId = new SelectList(ddl.GetStaffList(orgid), "Id", "Name"); ViewBag.StudentId = new SelectList(ddl.GetStudentList(orgid, 0, 0, 0), "Id", "Name"); ViewBag.OrganizationId = orgid; return(View()); }