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