public JsonResult SaveOrder(BillVm O) { bool status = false; if (ModelState.IsValid) { //Order order = new Order { OrderNo = O.OrderNo, OrderDate = O.OrderDate, Description = O.Description }; BillRegister billregister = new BillRegister { BillDate = O.billdate, Remarks = O.remarks, memberId = O.memberid, paid = "N" }; db.BillRegisters.Add(billregister); db.SaveChanges(); foreach (var i in O.BillDetail) { // // i.TotalAmount = Billdetail billdetail = new Billdetail(); billdetail.BillID = billregister.BillID; billdetail.HeaderId = i.headerid; billdetail.Amount = i.amount; db.Billdetail.Add(billdetail); db.SaveChanges(); } status = true; } else { status = false; } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Create(FormCollection form) { int temp = 0; // Thread.Sleep(1000); if (ModelState.IsValid) { List <MemberCompanyInfo> memberinfo = db.MemberCompanyInfo.Where(s => s.status != "P").ToList(); List <MonthlyBillSetUP> billsetup = db.MonthlyBillSetUPs.ToList(); // List<MemberCompanyInfo> memberinfo = db.MemberCompanyInfo.SqlQuery("Select * from MemberCompanyInfo Where status='P'").ToList(); // List<MonthlyBillSetUP> billsetup = db.MonthlyBillSetUPs.ToList(); foreach (var member in memberinfo) { BillRegister billregister = new BillRegister(); billregister.BillDate = Convert.ToDateTime(form["BillDate"]); billregister.memberId = member.memberId; billregister.paid = "N"; billregister.Remarks = form["Remarks"].ToString(); db.BillRegisters.Add(billregister); db.SaveChanges(); Billdetail billdetail = new Billdetail(); foreach (var bs in billsetup) { billdetail.BillID = billregister.BillID; billdetail.Amount = bs.Amount; billdetail.HeaderId = bs.HeaderId; db.Billdetail.Add(billdetail); db.SaveChanges(); } temp = 1; } } // var result = new { // res="Data Saved" //}; //var result1 = new //{ // res = "Error" //}; //if (temp == 1) //{ // return Json(result); //} //else //{ // return Json(result1); //} return(View()); }
public ActionResult Mass(FormCollection frm) { string obillid = frm["BillID"]; string odate = frm["edate"]; string[] obill = obillid.Split(','); foreach (var obi in obill) { int bi = Convert.ToInt32(obi); var billid = db.BillRegisters.Find(bi); if (billid != null) { billid.paid = "Y"; db.SaveChanges(); RecieveMaster rc = new RecieveMaster(); rc.memberId = billid.memberId; rc.rDate = Convert.ToDateTime(odate); rc.billId = billid.BillID.ToString(); //rc.total = billid.total; // rc.Remarks = "Mass Received"; rc.CMonth = billid.BillDate.Month.ToString("MMMM"); db.RecieveMasters.Add(rc); db.SaveChanges(); int rid = rc.rid; var billdetail = db.Billdetail.Where(a => a.BillID == bi); foreach (var bild in billdetail) { RecieveDetail rd = new RecieveDetail(); rd.rid = rid; rd.HeaderId = bild.HeaderId; rd.Amount = bild.Amount; db.RecieveDetail.Add(rd); } db.SaveChanges(); } } // Response.Write(billid); //return View(); return(RedirectToAction("Index", "MassCollection")); }
public async Task <ActionResult> Create([Bind(Include = "mid,memberId,membershipDate,Organization_Name,Organization_Address,Phone,Trade_License,Tin_Number,AreaId,btypeid,orgId,mtypeId,InCorporationDate,isVoter,status,Applicant_Name,Designation,Father_Name,Mother_Name,Present_address,Permanent_Address,National_Id,Mobile_No,Tin_No")] MemberCompanyInfo memberCompanyInfo, HttpPostedFileBase file, FormCollection frm) { if (ModelState.IsValid) { db.MemberCompanyInfo.Add(memberCompanyInfo); await db.SaveChangesAsync(); if (file != null) { string pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine( Server.MapPath("~/MemberImg/"), memberCompanyInfo.mid.ToString() + ".jpg"); //memberCompanyInfo.photo_path = path; // file is uploaded file.SaveAs(path); // save the image path path to the database or you can send image // directly to database // in-case if you want to store byte[] ie. for DB } string int_mid = frm["int_mid"].ToString(); if (!string.IsNullOrEmpty(int_mid)) { Introducer intd = new Introducer(); intd.REFID = memberCompanyInfo.mid; intd.MEMBERID = int_mid; db.Introducer.Add(intd); db.SaveChanges(); } //return RedirectToAction("Index"); } ViewBag.AreaId = new SelectList(db.Area, "AreaId", "Area_Name", memberCompanyInfo.AreaId); ViewBag.btypeid = new SelectList(db.BusinessType, "btypeid", "btype", memberCompanyInfo.btypeid); return(View(memberCompanyInfo)); }
public JsonResult SaveOrder(RecieveVm O) { bool status = false; if (ModelState.IsValid) { //Order order = new Order { OrderNo = O.OrderNo, OrderDate = O.OrderDate, Description = O.Description }; string billiid = ""; string cmonth = ""; int t = 0; //foreach (var k in O.billid) //{ // if (t == 0) // { // billiid = k.ToString(); // t = 1; // } // else // billiid += "," + k.ToString(); //} // t = 0; foreach (var k in O.CMonth) { if (t == 0) { cmonth = k.ToString(); t = 1; } else { cmonth += "," + k.ToString(); } } RecieveMaster recievMaster = new RecieveMaster { rDate = O.recivedate, Remarks = O.remarks, memberId = O.memberid, billId = billiid, CMonth = cmonth }; db.RecieveMasters.Add(recievMaster); db.SaveChanges(); foreach (var i in O.ReciveDetail) { // // i.TotalAmount = RecieveDetail recievedetail = new RecieveDetail(); recievedetail.rid = recievMaster.rid; recievedetail.HeaderId = i.headerid; recievedetail.Amount = i.amount; db.RecieveDetail.Add(recievedetail); db.SaveChanges(); Session["rid"] = recievMaster.rid; } //foreach(var j in O.billid) //{ // int bi = int.Parse(j); // var billid = db.BillRegisters.Find(bi); // if (billid!=null) // { // billid.paid = "Y"; // db.SaveChanges(); // } //} status = true; } else { status = false; } var TotalBill = db.BillRegisters.Where(a => a.memberId == O.memberid).ToList(); var TotalRecive = db.RecieveMasters.Where(a => a.memberId == O.memberid).ToList(); double TotalBalance = TotalBill.Sum(i => i.total) - TotalRecive.Sum(i => i.total); return(new JsonResult { Data = new { status = status, balance = TotalBalance } }); }