// GET: Member/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberCompanyInfo memberCompanyInfo = await db.MemberCompanyInfo.FindAsync(id); if (memberCompanyInfo == null) { return(HttpNotFound()); } //var TotalBalance = from bs in db.BillRegisters // join bd in db.Billdetail on bs.BillID equals bd.BillID // where bs.memberId == id && bs.paid == "N" // select new // { // total =db.Billdetail.Sum(s=>s.Amount) // }; //double tot = TotalBalance.Sum(i => i.total); var TotalBill = db.BillRegisters.Where(a => a.memberId == id).ToList(); var TotalRecive = db.RecieveMasters.Where(a => a.memberId == id).ToList(); double TotalBalance = TotalBill.Sum(i => i.total) - TotalRecive.Sum(i => i.total); ViewBag.Balance = TotalBalance; //ViewBag.nMonth = TotalBalance.Count(); return(View(memberCompanyInfo)); }
// GET: Member/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberCompanyInfo memberCompanyInfo = await db.MemberCompanyInfo.FindAsync(id); if (memberCompanyInfo == null) { return(HttpNotFound()); } ViewBag.AreaId = new SelectList(db.Area, "AreaId", "Area_Name", memberCompanyInfo.AreaId); ViewBag.btypeid = new SelectList(db.BusinessType, "btypeid", "btype", memberCompanyInfo.btypeid); ViewBag.orgId = new SelectList(db.OrganizationTypes, "orgId", "OrgType", memberCompanyInfo.orgId); ViewBag.mtypeId = new SelectList(db.MemberTypes, "mtypeId", "MemType", memberCompanyInfo.mtypeId); ViewBag.disid = new SelectList(db.Districts, "disid", "District_Name", "disid", memberCompanyInfo.disid); //string intrid = db.Introducer.Where(s => s.REFID == memberCompanyInfo.memberId).FirstOrDefault().ToString(); string intrid = null; intrid = db.Introducer .Where(s => s.REFID == memberCompanyInfo.mid) .Select(s => s.MEMBERID).FirstOrDefault(); ViewBag.Introducer = db.MemberCompanyInfo.Where(s => s.mid == intrid).SingleOrDefault(); return(View(memberCompanyInfo)); }
public async Task <ActionResult> DeleteConfirmed(int id) { MemberCompanyInfo memberCompanyInfo = await db.MemberCompanyInfo.FindAsync(id); db.MemberCompanyInfo.Remove(memberCompanyInfo); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: Member/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberCompanyInfo memberCompanyInfo = await db.MemberCompanyInfo.FindAsync(id); if (memberCompanyInfo == null) { return(HttpNotFound()); } return(View(memberCompanyInfo)); }
public async Task <ActionResult> Edit([Bind(Include = "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,disid,mid")] MemberCompanyInfo memberCompanyInfo, HttpPostedFileBase file, FormCollection frm) { if (ModelState.IsValid) { db.Entry(memberCompanyInfo).State = EntityState.Modified; 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)) { var intr_id = db.Introducer.Where(s => s.REFID == memberCompanyInfo.mid).Count(); if (intr_id == 0) { Introducer intd = new Introducer(); intd.REFID = memberCompanyInfo.mid; intd.MEMBERID = int_mid; db.Introducer.Add(intd); db.SaveChanges(); } } return(RedirectToAction("Index")); } if (!ModelState.IsValid) { var modelStateErrors = this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors); //Response.Write(errors.ToString()); // Breakpoint, Log or examine the list with Exceptions. } ViewBag.AreaId = new SelectList(db.Area, "AreaId", "Area_Name", memberCompanyInfo.AreaId); ViewBag.btypeid = new SelectList(db.BusinessType, "btypeid", "btype", memberCompanyInfo.btypeid); ViewBag.orgId = new SelectList(db.OrganizationTypes, "orgId", "OrgType", memberCompanyInfo.orgId); ViewBag.mtypeId = new SelectList(db.MemberTypes, "mtypeId", "MemType", memberCompanyInfo.mtypeId); ViewBag.disid = new SelectList(db.Districts, "disid", "District_Name", "disid", memberCompanyInfo.disid); return(View(memberCompanyInfo)); }
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)); }