public ActionResult <List <CustomerTxHistoryReportModel> > GetCustomerTransactionHistory(string CustomerId)
{
List <CustomerTxHistoryTE> TxHistoryDataList = new List <CustomerTxHistoryTE>();
List <CustomerTxHistoryReportModel> modelList = new List <CustomerTxHistoryReportModel>();
TxHistoryDataList = context.customertxhistory.Where(x => x.Customerid.ToString() == CustomerId).ToList();
if (TxHistoryDataList.Count() > 0)
{
CustomerNameService nameService = new CustomerNameService(context);
foreach (var data in TxHistoryDataList)
{
CustomerTxHistoryReportModel model = new CustomerTxHistoryReportModel();
model.Customername = nameService.GetCustomerName(data.Customerid);
model.Billnumber = data.Billnumber;
model.Paidamount = data.Paidamount;
model.Paymentmode = data.Paymentmode;
model.Paiddate = data.Paiddate;
modelList.Add(model);
}
return(Ok(modelList));
}
else
{
return(Ok("No Records Found"));
}
}
public ActionResult <List <ProdMonthCustomerProfitReportModel> > GetStoreProfit([FromForm] ViewTemplateModelTwo data)
{
bool IsFromDateValid = false;
bool IsEndDateValid = false;
DateTime FromDate;
string CompleteFromDateString = "";
DateTime EndDate;
string CompleteEndDateString = "";
DateTime dt;
List <ProdMonthCustomerProfitReportModel> ReportModelList = new List <ProdMonthCustomerProfitReportModel>();
string Result = "";
bool NotFound = false;
if (data.FromDate != null && data.EndDate != null)
{
DateService DateService1 = new DateService();
CompleteFromDateString = DateService1.GetCompleteFromDate(data.FromDate);
IsFromDateValid = DateTime.TryParse(CompleteFromDateString, out dt);
DateService DateService2 = new DateService();
CompleteEndDateString = DateService2.GetCompleteEndDate(data.EndDate);
IsEndDateValid = DateTime.TryParse(CompleteEndDateString, out dt);
if (IsFromDateValid && IsEndDateValid)
{
FromDate = Convert.ToDateTime(CompleteFromDateString);
EndDate = Convert.ToDateTime(CompleteEndDateString);
CustomerNameService nameService = new CustomerNameService(context);
if (data.MobileNumber == null)
{
var BillCollectionData = context.billscollections.Where(x => x.Billdate >= FromDate && x.Billdate <= EndDate)
.Select(x => new ProdMonthCustomerProfitReportModel()
{
Billnumber = x.Billnumber.ToString(),
Customername = nameService.GetCustomerName(x.Customerid),
Profit = x.Billprofit,
Date = x.Billdate.ToString()
}).ToList <ProdMonthCustomerProfitReportModel>();
if (BillCollectionData.Count() > 0)
{
ReportModelList = BillCollectionData;
}
else
{
NotFound = true;
Result = "Not Found";
}
}
else
{
var BillCollectionData = context.billscollections.Where(x => x.Customerid.ToString() == data.Customerid &&
x.Billdate >= FromDate && x.Billdate <= EndDate)
.Select(x => new ProdMonthCustomerProfitReportModel()
{
Billnumber = x.Billnumber.ToString(),
Customername = nameService.GetCustomerName(x.Customerid),
Profit = x.Billprofit,
Date = x.Billdate.ToString()
}).ToList <ProdMonthCustomerProfitReportModel>();
if (BillCollectionData.Count() > 0)
{
ReportModelList = BillCollectionData;
}
else
{
NotFound = true;
Result = "Not Found";
}
}
}
}
if (NotFound)
{
return(Ok(Result));
}
else
{
return(Ok(ReportModelList));
}
}
