// 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));
}
