// GET: RecieveMasters/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RecieveMaster recieveMaster = await db.RecieveMasters.FindAsync(id);
if (recieveMaster == null)
{
return(HttpNotFound());
}
return(View(recieveMaster));
}
public async Task <ActionResult> Edit([Bind(Include = "rid,rDate,memberId,Remarks,billId")] RecieveMaster recieveMaster, FormCollection form)
{
if (ModelState.IsValid)
{
string obillid = form["obillid"].ToString();
if (!String.IsNullOrEmpty(obillid))
{
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 = "N";
db.SaveChanges();
}
}
}
string bllid = form["billId"].ToString();
if (!String.IsNullOrEmpty(bllid))
{
string[] oill = bllid.Split(',');
foreach (var obi in oill)
{
int bi = Convert.ToInt32(obi);
var billd = db.BillRegisters.Find(bi);
if (billd != null)
{
billd.paid = "Y";
db.SaveChanges();
}
}
}
recieveMaster.billId = bllid.ToString();
db.Entry(recieveMaster).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.memberId = new SelectList(db.MemberCompanyInfo, "memberId", "Organization_Name", recieveMaster.memberId);
return(View(recieveMaster));
}
// GET: RecieveMasters/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RecieveMaster recieveMaster = await db.RecieveMasters.FindAsync(id);
if (recieveMaster == null)
{
return(HttpNotFound());
}
ViewBag.memberId = new SelectList(db.MemberCompanyInfo, "memberId", "Organization_Name", recieveMaster.memberId);
ViewBag.bill = db.BillRegisters.Where(s => s.memberId == recieveMaster.memberId && s.paid == "N")
.Select(s => s.BillID).ToList();
ViewBag.HeaderId = new SelectList(db.Headers.Where(s => s.HeaderType == "Income"), "HeaderId", "HeaderName", "Select Head");
return(View(recieveMaster));
}
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> DeleteConfirmed(int id)
{
RecieveDetail recievedetail = await db.RecieveDetail.FindAsync(id);
if (recievedetail != null)
{
db.RecieveDetail.Remove(recievedetail);
}
RecieveMaster recieveMaster = await db.RecieveMasters.FindAsync(id);
string billid = recieveMaster.billId.ToString();
if (billid != "0")
{
if (!String.IsNullOrEmpty(billid))
{
string[] obill = billid.Split(',');
foreach (var obi in obill)
{
int bi = Convert.ToInt32(obi);
var bllid = db.BillRegisters.Find(bi);
if (bllid != null)
{
bllid.paid = "N";
db.SaveChanges();
}
}
}
}
db.RecieveMasters.Remove(recieveMaster);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
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 }
});
}
