public ActionResult <List <BillsDatasTE> > ModifiedBills()
{
string Result = "";
var ModifiedBillsData = _context.billscollections.Where(x => x.Isbillmodified == true);
List <BillsDatasTE> ModifiedBills = new List <BillsDatasTE>();
if (ModifiedBillsData != null)
{
foreach (var BillData in ModifiedBillsData)
{
BillsDatasTE bill = new BillsDatasTE()
{
Billnumber = BillData.Billnumber,
Customerid = BillData.Customerid
};
ModifiedBills.Add(bill);
}
return(Ok(ModifiedBills));
}
else
{
Result = "No Pending Bills Availble yet!";
return(Ok(Result));
}
}
public ActionResult <string> StorePDF([FromForm] PDFData formData)
{
string Base64 = formData.Base64;
byte[] byteArray = Convert.FromBase64String(Base64);
//Calculating Bill profit after dedcution of Discount %
int Accurateprofit = formData.Billprofit - formData.Deduction;
BillsDatasTE Billdata = new BillsDatasTE()
{
Billnumber = formData.Billnumber,
Billamount = formData.Billamount,
Deduction = formData.Deduction,
Payableamount = formData.Payableamount,
Billprofit = Accurateprofit,
Billbytearray = byteArray,
Billdate = DateTime.Now,
Ispaid = false,
Customerid = formData.Customerid
};
_context.Add(Billdata);
_context.SaveChanges();
BillsPendingTE billPending = new BillsPendingTE()
{
Pendingamount = formData.Payableamount,
Billnumber = formData.Billnumber,
Iscompleted = false,
Customerid = formData.Customerid,
};
_context.Add(billPending);
_context.SaveChanges();
int maxID = _context.billscollections.Max(x => x.Id);
byte[] byteArray2 = _context.billscollections.Single(x => x.Id == maxID).Billbytearray;
string Base642 = Convert.ToBase64String(byteArray);
return(Ok(Base642));
}
