public List <Dashboard> GetDashboardDetails()
{
List <Dashboard> DashboardDetails = new List <Dashboard>();
try
{
using (var dbcontext = new CustomerReportContext())
{
Dashboard data = new Dashboard();
data.TotalCustomer = dbcontext.TblCustomer.Count();
data.TotalInvoice = dbcontext.TblInvoices.Count();
foreach (var sa in dbcontext.TblInvoices.ToList())
{
data.TotalSales += sa.InvoiceAmount;
}
foreach (var pc in dbcontext.TblPayment.ToList())
{
data.TotalPayCollection += pc.PaymentAmount;
}
//var dep = dbcontext.TblInvoices.Where(x => x.InvoiceAmount).Sum();
//data.TotalInvoice = dep.InvoiceAmount;
//data.TotalInvoice = dbcontext.TblInvoices.Count();
DashboardDetails.Add(data);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return(DashboardDetails);
}
public List <Model.Common.Customer> GetCustomer()
{
List <Model.Common.Customer> Items = new List <Model.Common.Customer>();
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Customer cust;
foreach (var it in dBContext.TblCustomer)
{
cust = new Model.Common.Customer();
cust.CustomerNo = it.CustomerNo;
cust.CustomerName = it.CustomerName;
Items.Add(cust);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public int DeletePayment(string PaymentNo)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.TblPayment emp = new Model.Entity.TblPayment();
Customer DeleteItem = new Customer();
//Add record
{
emp = dBContext.TblPayment.FirstOrDefault(asd => asd.PaymentNo == PaymentNo);
if (emp != null)
{
//emp = new Employes();
//emp.Id = EmployesModel.Id;
dBContext.TblPayment.Remove(emp);
}
}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
//private List<User> users = new List<User>()
//{
// new User{UserId = 1,FirstName="Nisarg",LastName ="prajapati",
// UserName="******",Password="******"}
//};
public List <User> GetLogindetails()
{
List <User> Items = new List <User>();
try
{
using (var dBContext = new CustomerReportContext())
{
User cust;
foreach (var it in dBContext.User)
{
cust = new User();
cust.UserId = it.UserId;
cust.FirstName = it.FirstName;
cust.LastName = it.LastName;
cust.UserName = it.UserName;
cust.Password = it.Password;
cust.Dob = it.Dob;
cust.Gender = it.Gender;
cust.Usertype = it.Usertype;
cust.Region = it.Region;
Items.Add(cust);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public List <Model.Common.Payment> GetPayment()
{
List <Model.Common.Payment> Items = new List <Model.Common.Payment>();
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Payment Pay;
foreach (var it in dBContext.TblPayment)
{
Pay = new Model.Common.Payment();
Pay.PaymentNo = it.PaymentNo;
Pay.PaymentDate = it.PaymentDate;
Pay.PaymentAmount = it.PaymentAmount;
Pay.InvoiceNo = it.InvoiceNo;
Items.Add(Pay);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public Invoice InvoiceById(string InvoiceNo)
{
Invoice Cust = new Invoice();
try
{
using (var dBContext = new CustomerReportContext())
{
var dep = dBContext.TblInvoices.Where(x => x.InvoiceNo == InvoiceNo).SingleOrDefault();
if (dep != null)
{
Cust.InvoiceNo = dep.InvoiceNo;
Cust.CustomerNo = dep.CustomerNo;
Cust.InvoiceDate = dep.InvoiceDate;
Cust.InvoiceAmount = dep.InvoiceAmount;
Cust.PaymentDueDate = dep.PaymentDueDate;
}
return(Cust);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public Userdata GetEditprofileById(int UserId)
{
Userdata Cust = new Userdata();
try
{
using (var dBContext = new CustomerReportContext())
{
var dep = dBContext.User.Where(x => x.UserId == UserId).SingleOrDefault();
if (dep != null)
{
Cust.UserId = dep.UserId;
Cust.FirstName = dep.FirstName;
Cust.LastName = dep.LastName;
Cust.UserName = dep.UserName;
Cust.Password = dep.Password;
Cust.Dob = dep.Dob;
Cust.Gender = dep.Gender;
Cust.Usertype = dep.Usertype;
Cust.Region = dep.Region;
}
return(Cust);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public List <Model.Common.Invoice> GetInvoice()
{
List <Model.Common.Invoice> Items = new List <Model.Common.Invoice>();
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Invoice inv;
foreach (var it in dBContext.TblInvoices)
{
inv = new Model.Common.Invoice();
inv.InvoiceNo = it.InvoiceNo;
inv.CustomerNo = it.CustomerNo;
inv.InvoiceDate = it.InvoiceDate;
inv.InvoiceAmount = it.InvoiceAmount;
inv.PaymentDueDate = it.PaymentDueDate;
Items.Add(inv);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public Payment PaymentById(string PaymentNo)
{
Payment Cust = new Payment();
try
{
using (var dBContext = new CustomerReportContext())
{
var dep = dBContext.TblPayment.Where(x => x.PaymentNo == PaymentNo).SingleOrDefault();
if (dep != null)
{
Cust.PaymentNo = dep.PaymentNo;
Cust.InvoiceNo = dep.InvoiceNo;
Cust.PaymentDate = dep.PaymentDate;
Cust.PaymentAmount = dep.PaymentAmount;
}
return(Cust);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public int AddInvoiceData(Model.Common.Invoice InvoiceModel, string InvoiceNo)
{
List <Model.Common.Invoice> Items = new List <Model.Common.Invoice>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Invoice get;
foreach (var it in dBContext.TblInvoices)
{
get = new Model.Common.Invoice();
get.InvoiceNo = it.InvoiceNo;
get.CustomerNo = it.CustomerNo;
get.InvoiceDate = it.InvoiceDate;
get.InvoiceAmount = it.InvoiceAmount;
get.PaymentDueDate = it.PaymentDueDate;
Items.Add(get);
}
TblInvoices Cust;
//Add record
Cust = new TblInvoices();
Cust.InvoiceNo = InvoiceModel.InvoiceNo;
Cust.CustomerNo = InvoiceModel.CustomerNo;
Cust.InvoiceDate = InvoiceModel.InvoiceDate;
Cust.InvoiceAmount = InvoiceModel.InvoiceAmount;
Cust.PaymentDueDate = Cust.InvoiceDate.AddDays(30);
//dBContext.TblInvoices.Add(Cust);
InvoiceNo = Cust.InvoiceNo;
bool Inv = Items.Any(asd => asd.InvoiceNo == InvoiceNo);
if (Inv == true)
{
returnVal = -1;
}
if (Inv == false)
{
dBContext.TblInvoices.Add(Cust);
returnVal = dBContext.SaveChanges();
}
//returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int UpdateCustomer(Customer CustomerModel, string CustomerNo, string CustomerName)
{
List <Customer> Items = new List <Customer>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Customer get;
foreach (var it in dBContext.TblCustomer)
{
get = new Customer();
get.CustomerNo = it.CustomerNo;
get.CustomerName = it.CustomerName;
Items.Add(get);
}
Model.Entity.TblCustomer Cust = new Model.Entity.TblCustomer();
//Add record
Cust = dBContext.TblCustomer.FirstOrDefault(asd => asd.CustomerNo == CustomerModel.CustomerNo);
//emp = new Employes();
Cust.CustomerNo = CustomerModel.CustomerNo;
Cust.CustomerName = CustomerModel.CustomerName;
dBContext.TblCustomer.Update(Cust);
//CustomerNo = Cust.CustomerNo;
//CustomerName = Cust.CustomerName;
//bool departmentsame = Items.Any(asd => asd.CustomerName == CustomerName);
//bool departmentexist = Items.Any(asd => (asd.CustomerNo == CustomerNo) && (asd.CustomerName == CustomerName));
//if (departmentexist == true)
//{
// returnVal = dBContext.SaveChanges();
//}
//else if (departmentsame == true)
//{
// returnVal = -1;
//}
//else
//{
// returnVal = dBContext.SaveChanges();
//}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int AddCustomerData(Model.Common.Customer CustomerModel, string CustomerNo)
{
List <Model.Common.Customer> Items = new List <Model.Common.Customer>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Customer get;
foreach (var it in dBContext.TblCustomer)
{
get = new Model.Common.Customer();
get.CustomerNo = it.CustomerNo;
get.CustomerName = it.CustomerName;
Items.Add(get);
}
TblCustomer Cust;
//Add record
Cust = new TblCustomer();
Cust.CustomerNo = CustomerModel.CustomerNo;
Cust.CustomerName = CustomerModel.CustomerName;
CustomerNo = Cust.CustomerNo;
bool CustNo = Items.Any(asd => asd.CustomerNo == CustomerNo);
if (CustNo == true)
{
returnVal = -1;
}
if (CustNo == false)
{
dBContext.TblCustomer.Add(Cust);
returnVal = dBContext.SaveChanges();
}
//returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public Userdata Authenticate(Userdata Model)
{
List <Userdata> users = new List <Userdata>();
using (var dbContext = new CustomerReportContext())
{
Userdata cust;
foreach (var it in dbContext.User.ToList())
{
cust = new Userdata();
cust.UserName = it.UserName;
cust.Password = it.Password;
cust.FirstName = it.FirstName;
users.Add(cust);
}
}
var user = users.SingleOrDefault(x => x.UserName == Model.UserName && x.Password == Model.Password);
if (user == null)
{
return(null);
}
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(_appSettings.Key);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new System.Security.Claims.ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.UserId.ToString()),
new Claim(ClaimTypes.Role, "Admin"),
new Claim(ClaimTypes.Version, "V3.1")
}),
Expires = DateTime.UtcNow.AddDays(2),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
user.Token = tokenHandler.WriteToken(token);
user.Password = null;
return(user);
}
public int DeleteCustomer(string CustomerNo)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.TblCustomer emp = new Model.Entity.TblCustomer();
Model.Entity.TblInvoices inv = new Model.Entity.TblInvoices();
//Customer DeleteItem = new Customer();
//Add record
{
emp = dBContext.TblCustomer.FirstOrDefault(asd => asd.CustomerNo == CustomerNo);
inv = dBContext.TblInvoices.FirstOrDefault(asd => asd.CustomerNo == CustomerNo);
if (inv == null)
{
if (emp != null)
{
//emp = new Employes();
//emp.Id = EmployesModel.Id;
dBContext.TblCustomer.Remove(emp);
returnVal = dBContext.SaveChanges();
}
}
else
{
returnVal = -1;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int GetLogin(Model.Entity.Registration RegistrationModel, int Id, string UserName)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.Registration log = new Model.Entity.Registration();
//Model.Common.Registration Login = new Model.Common.Registration();
//Add record
{
//log = dBContext.Registration.SingleOrDefault(asd => asd.Id == Id && asd.UserName == UserName);
//if (log != null)
//{
// LoginRepo Login = new LoginRepo();
// //Login.Id = log.Id;
// //Login.UserName = log.UserName;
// return returnVal = 1;
//}
log = dBContext.Registration.SingleOrDefault(asd => asd.UserName == RegistrationModel.UserName && asd.Password == RegistrationModel.Password);
if (log != null)
{
LoginRepo Login = new LoginRepo();
//Login.Id = log.Id;
//Login.UserName = log.UserName;
return(returnVal = 1);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public Customer CustomerById(string CustomerNo)
{
Customer Cust = new Customer();
try
{
using (var dBContext = new CustomerReportContext())
{
var dep = dBContext.TblCustomer.Where(x => x.CustomerNo == CustomerNo).SingleOrDefault();
if (dep != null)
{
Cust.CustomerNo = dep.CustomerNo;
Cust.CustomerName = dep.CustomerName;
}
return(Cust);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public int Editprofile(Userdata UserModel, string UserName, int UserId)
{
List <Userdata> Items = new List <Userdata>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Userdata get;
foreach (var it in dBContext.User)
{
get = new Userdata();
get.UserId = it.UserId;
get.FirstName = it.FirstName;
get.LastName = it.LastName;
get.UserName = it.UserName;
get.Password = it.Password;
get.Dob = it.Dob;
get.Gender = it.Gender;
get.Usertype = it.Usertype;
get.Region = it.Region;
Items.Add(get);
}
User emp = new User();
//Add record
emp = dBContext.User.FirstOrDefault(asd => asd.UserId == UserModel.UserId);
if (emp != null)
{
//emp = new Employes();
emp.UserId = UserModel.UserId;
emp.FirstName = UserModel.FirstName;
emp.LastName = UserModel.LastName;
emp.UserName = UserModel.UserName;
emp.Password = UserModel.Password;
emp.Dob = UserModel.Dob;
emp.Gender = UserModel.Gender;
emp.Usertype = UserModel.Usertype;
emp.Region = UserModel.Region;
dBContext.User.Update(emp);
UserId = emp.UserId;
UserName = emp.UserName;
}
bool username = Items.Any(asd => asd.UserName == UserName);
bool usernameexist = Items.Any(asd => (asd.UserId == UserId) && (asd.UserName == UserName));
if (usernameexist == true)
{
returnVal = dBContext.SaveChanges();
}
else if (username == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int UpdateInvoice(Invoice InvoiceModel, string InvoiceNo, string InvoiceName)
{
List <Invoice> Items = new List <Invoice>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Invoice get;
foreach (var it in dBContext.TblInvoices)
{
get = new Invoice();
get.InvoiceNo = it.InvoiceNo;
get.CustomerNo = it.CustomerNo;
get.InvoiceDate = it.InvoiceDate;
get.InvoiceAmount = it.InvoiceAmount;
get.PaymentDueDate = it.PaymentDueDate;
Items.Add(get);
}
Model.Entity.TblInvoices Cust = new Model.Entity.TblInvoices();
//Add record
Cust = dBContext.TblInvoices.FirstOrDefault(asd => asd.InvoiceNo == InvoiceModel.InvoiceNo);
//emp = new Employes();
Cust.InvoiceNo = InvoiceModel.InvoiceNo;
Cust.CustomerNo = InvoiceModel.CustomerNo;
Cust.InvoiceDate = InvoiceModel.InvoiceDate;
Cust.InvoiceAmount = InvoiceModel.InvoiceAmount;
Cust.PaymentDueDate = Cust.InvoiceDate.AddDays(30);
dBContext.TblInvoices.Update(Cust);
InvoiceNo = Cust.InvoiceNo;
bool Inv = Items.Any(asd => asd.InvoiceNo == InvoiceNo);
if (Inv == true)
{
returnVal = -1;
}
if (Inv == false)
{
dBContext.TblInvoices.Add(Cust);
returnVal = dBContext.SaveChanges();
}
//CustomerNo = Cust.CustomerNo;
//CustomerName = Cust.CustomerName;
//bool departmentsame = Items.Any(asd => asd.CustomerName == CustomerName);
//bool departmentexist = Items.Any(asd => (asd.CustomerNo == CustomerNo) && (asd.CustomerName == CustomerName));
//if (departmentexist == true)
//{
// returnVal = dBContext.SaveChanges();
//}
//else if (departmentsame == true)
//{
// returnVal = -1;
//}
//else
//{
// returnVal = dBContext.SaveChanges();
//}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int AddPaymentData(Model.Common.Payment PaymentModel, string PaymentNo)
{
List <Payment> Items = new List <Payment>();
List <Invoice> InvItems = new List <Invoice>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Payment get;
foreach (var it in dBContext.TblPayment)
{
get = new Model.Common.Payment();
get.PaymentNo = it.PaymentNo;
get.InvoiceNo = it.InvoiceNo;
get.PaymentDate = it.PaymentDate;
get.PaymentAmount = it.PaymentAmount;
Items.Add(get);
}
TblPayment Cust;
//Add record
Cust = new TblPayment();
Cust.PaymentNo = PaymentModel.PaymentNo;
Cust.InvoiceNo = PaymentModel.InvoiceNo;
Cust.PaymentDate = PaymentModel.PaymentDate;
Cust.PaymentAmount = PaymentModel.PaymentAmount;
dBContext.TblPayment.Add(Cust);
PaymentNo = Cust.PaymentNo;
bool Invoicexist = Items.Any(asd => asd.PaymentNo == PaymentNo);
if (Invoicexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
//using (var ddBContext = new CustomerReportContext())
//{
// Model.Common.Invoice Inv = new Model.Common.Invoice();
// foreach (var iit in ddBContext.TblInvoices)
// {
// Inv.InvoiceNo = iit.InvoiceNo;
// Inv.InvoiceAmount = iit.InvoiceAmount;
// Inv.InvoiceDate = iit.InvoiceDate;
// Inv.PaymentDueDate = iit.PaymentDueDate;
// InvItems.Add(Inv);
// }
// bool InvoicAmount = Items.Any(asd => asd.PaymentAmount > Inv.InvoiceAmount);
// if (InvoicAmount == true)
// {
// returnVal = -2;
// }
//}
//returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int Registration(Userdata UserModel, string UserName)
{
List <Userdata> Items = new List <Userdata>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Userdata get;
foreach (var it in dBContext.User)
{
get = new Userdata();
get.UserId = it.UserId;
get.FirstName = it.FirstName;
get.LastName = it.LastName;
get.UserName = it.UserName;
get.Password = it.Password;
get.Dob = it.Dob;
get.Gender = it.Gender;
get.Usertype = it.Usertype;
get.Region = it.Region;
Items.Add(get);
}
User Cust;
//Add record
if (UserModel.UserId == 0)
{
Cust = new User();
Cust.FirstName = UserModel.FirstName;
Cust.LastName = UserModel.LastName;
Cust.UserName = UserModel.UserName;
Cust.Password = UserModel.Password;
Cust.Dob = UserModel.Dob;
Cust.Gender = UserModel.Gender;
Cust.Usertype = UserModel.Usertype;
Cust.Region = UserModel.Region;
dBContext.User.Add(Cust);
UserName = Cust.UserName;
}
bool username = Items.Any(Items => Items.UserName == UserName);
if (username == true)
{
returnVal = -1;
}
else
{
//dBContext.TblCustomer.Add(Cust);
returnVal = dBContext.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public List <Dashboard> DisplayChart()
{
List <Dashboard> DashboardChart = new List <Dashboard>();
try
{
using (var dbcontext = new CustomerReportContext())
{
//Dashboard data = new Dashboard();
//DateTime Today = DateTime.Today;
//var Month = (Today.Month);
//var Year = (Today.Year);
//data.ChartMonthly = dbcontext.TblCustomer.Count();
//data.TotalInvoice = dbcontext.TblInvoices.Count();
//foreach (var sa in dbcontext.TblInvoices.ToList())
//{
// data.ChartSales += sa.InvoiceAmount;
//}
//foreach (var pc in dbcontext.TblPayment.ToList())
//{
// data.ChartPayment += pc.PaymentAmount;
//}
//DashboardChart.Add(data);
Dashboard chdb;
foreach (var chartdb in dbcontext.TblInvoices.ToList())
{
chdb = new Dashboard();
Boolean Flag = false;
foreach (var chdashboard in DashboardChart.ToList())
{
var it1 = chdashboard.MonthAndYearDate.Date;
var it2 = chartdb.InvoiceDate.Date;
if (it1 == it2)
{
chdashboard.ChartSales += chartdb.InvoiceAmount;
Flag = true;
}
}
if (Flag == false)
{
chdb.MonthAndYearDate = chartdb.InvoiceDate;
chdb.ChartSales = chartdb.InvoiceAmount;
DashboardChart.Add(chdb);
}
}
foreach (var chartdb in dbcontext.TblPayment.ToList())
{
chdb = new Dashboard();
Boolean Flag = false;
foreach (var chdashboard in DashboardChart.ToList())
{
var it1 = chdashboard.MonthAndYearDate.Date;
var it2 = chartdb.PaymentDate.Date;
if (it1 == it2)
{
chdashboard.ChartPayment += chartdb.PaymentAmount;
Flag = true;
}
}
if (Flag == false)
{
chdb.MonthAndYearDate = chartdb.PaymentDate;
chdb.ChartPayment = chartdb.PaymentAmount;
DashboardChart.Add(chdb);
}
}
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
DashboardChart = DashboardChart.OrderBy(asd => asd.MonthAndYearDate).ToList();
return(DashboardChart);
}
public List <Model.Common.Reports> GetReports()
{
List <Model.Common.Reports> Items = new List <Model.Common.Reports>();
try
{
using (var dBContext = new CustomerReportContext())
{
//Model.Common.Reports rep;
//foreach (var it in dBContext.TblCustomer.ToList())
//{
// rep = new Model.Common.Reports();
// rep.CustomerName = it.CustomerName;
// if (rep.CustomerName != null)
// {
// var des = dBContext.TblCustomer.FirstOrDefault(x => x.CustomerName == rep.CustomerName);
// if (des != null)
// {
// rep.CustomerName = des.CustomerName;
// Items.Add(rep);
// }
// }
//}
//foreach (var it in dBContext.TblInvoices.ToList())
//{
// rep = new Model.Common.Reports();
// rep.InvoiceDate = it.InvoiceDate;
// if (rep.InvoiceDate != null)
// {
// var des = dBContext.TblInvoices.FirstOrDefault(x => x.InvoiceDate == rep.InvoiceDate);
// if (des != null)
// {
// rep.InvoiceDate = des.InvoiceDate;
// Items.Add(rep);
// }
// }
//}
//foreach (var it in dBContext.TblInvoices.ToList())
//{
// rep = new Model.Common.Reports();
// rep.InvoiceDate = it.InvoiceDate;
// if (rep.InvoiceDate != null)
// {
// var des = dBContext.TblInvoices.FirstOrDefault(x => x.InvoiceDate == rep.InvoiceDate);
// if (des != null)
// {
// rep.InvoiceDate = des.InvoiceDate;
// Items.Add(rep);
// }
// }
//}
Model.Common.Reports rep;
int i = 0;
foreach (var it in dBContext.TblInvoices.ToList())
{
rep = new Model.Common.Reports();
var Cust = dBContext.TblCustomer.FirstOrDefault(x => x.CustomerNo == it.CustomerNo);
rep.DateOfMonthInvoice = new DateTime(it.InvoiceDate.Year, it.InvoiceDate.Month, 15);
rep.DateOfMonth = rep.DateOfMonthInvoice;
if (Cust != null)
{
rep.CustomerNo = it.CustomerNo;
rep.CustomerName = Cust.CustomerName;
}
rep.NoofInvoice = 1;
Boolean b = false;
foreach (var a in Items)
{
if (a.DateOfMonthInvoice == rep.DateOfMonthInvoice && a.CustomerNo == rep.CustomerNo)
{
a.Sales = it.InvoiceAmount + a.Sales;
a.NoofInvoice = a.NoofInvoice + 1;
b = true;
}
}
if (b == false)
{
rep.Sales = it.InvoiceAmount;
i++;
rep.Num = i;
Items.Add(rep);
}
}
foreach (var PInvoice in dBContext.TblPayment.ToList())
{
rep = new Reports();
if (PInvoice != null)
{
var inv = dBContext.TblInvoices.FirstOrDefault(x => x.InvoiceNo == PInvoice.InvoiceNo);
rep.DateOfMonthPay = new DateTime(PInvoice.PaymentDate.Year, PInvoice.PaymentDate.Month, 15);
rep.DateOfMonth = rep.DateOfMonthPay;
if (inv != null)
{
var Cust = dBContext.TblCustomer.FirstOrDefault(x => x.CustomerNo == inv.CustomerNo);
if (Cust != null)
{
rep.CustomerNo = Cust.CustomerNo;
rep.CustomerName = Cust.CustomerName;
}
}
}
Boolean b = false;
foreach (var a in Items)
{
if ((a.DateOfMonth == rep.DateOfMonthPay || a.DateOfMonthPay == rep.DateOfMonthPay) && a.CustomerNo == rep.CustomerNo)
{
if (PInvoice != null)
{
a.PayCollection = PInvoice.PaymentAmount + a.PayCollection;
}
b = true;
}
}
if (b == false)
{
if (PInvoice != null)
{
rep.PayCollection = PInvoice.PaymentAmount;
}
Items.Add(rep);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public int UpdatePayment(Payment PaymentModel, string PaymentNo, string PaymentName)
{
List <Payment> Items = new List <Payment>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Payment get;
foreach (var it in dBContext.TblPayment)
{
get = new Payment();
get.PaymentNo = it.PaymentNo;
get.InvoiceNo = it.InvoiceNo;
get.PaymentDate = it.PaymentDate;
get.PaymentAmount = it.PaymentAmount;
Items.Add(get);
}
Model.Entity.TblPayment Cust = new Model.Entity.TblPayment();
//Add record
Cust = dBContext.TblPayment.FirstOrDefault(asd => asd.PaymentNo == PaymentModel.PaymentNo);
//emp = new Employes();
Cust.PaymentNo = PaymentModel.PaymentNo;
Cust.InvoiceNo = PaymentModel.InvoiceNo;
Cust.PaymentDate = PaymentModel.PaymentDate;
Cust.PaymentAmount = PaymentModel.PaymentAmount;
dBContext.TblPayment.Update(Cust);
PaymentNo = Cust.PaymentNo;
bool Invoicexist = Items.Any(asd => asd.PaymentNo == PaymentNo);
if (Invoicexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
//CustomerNo = Cust.CustomerNo;
//CustomerName = Cust.CustomerName;
//bool departmentsame = Items.Any(asd => asd.CustomerName == CustomerName);
//bool departmentexist = Items.Any(asd => (asd.CustomerNo == CustomerNo) && (asd.CustomerName == CustomerName));
//if (departmentexist == true)
//{
// returnVal = dBContext.SaveChanges();
//}
//else if (departmentsame == true)
//{
// returnVal = -1;
//}
//else
//{
// returnVal = dBContext.SaveChanges();
//}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
