private void DoWork(object state)
{
_logger.LogInformation("Background Service is working. Am available");
if (DateTime.Now.DayOfWeek == DayOfWeek.Saturday)
{
if (haverun2 != DateTime.Now)
{
using (var db = new TrippleNTDBContext())
{
var reco = new Reconciliation();
var enddate = DateTime.Now.AddDays(-1).Date;
var comp = db.Company.Where(o => o.Status == "Acvtive").ToList();
foreach (var item in comp)
{
reco.Amount = db.Donations.Where(o => o.ComapanyId == item.CompanyId && o.Status == "NT" && o.DateDonated.Date <= enddate).Sum(o => o.Amount);
reco.StartPeriod = DateTime.Now.AddDays(-7);
reco.EndPeriod = DateTime.Now.AddDays(-1);
reco.CompanyId = item.CompanyId;
reco.Status = "Pending";
var msg = "Hello, " + item.Name + ", <br> Your donation reconciliation of NGN" + string.Format("{0:n}", reco.Amount) + " for this week is now ready. Kindly log in to make payment. <br> Thank you for your continuous co-operation and for your contribution to changing the world.<br><br>#ChangeTheWorldWithYourSpareChange <br><br>Regards,<br> Admin Edufund";
Utility.SendMail.Send("Welcome to EduFund", msg, item.Email, _configuration);
}
haverun2 = DateTime.Now;
}
}
}
}
public AddCompanyResponse addCompIndvidualModel(AddCompanyIndPayload comp, IConfiguration _config, IHostingEnvironment env)
{
try
{
using (var db = new TrippleNTDBContext())
{
var checkcompany = db.Company.Where(o => o.PhoneNumber == comp.phoneNumber || o.Email == comp.email || o.Rcno == comp.rcNo).FirstOrDefault();
if (checkcompany != null)
{
return(checkcompany.PhoneNumber == comp.phoneNumber? new AddCompanyResponse {
status = "failed", msg = "Phone Number Already Exists"
} :comp.rcNo == checkcompany.Rcno ? new AddCompanyResponse {
status = "failed", msg = "Invalid Company Reg Number"
}: new AddCompanyResponse {
status = "failed", msg = "Email Already Exists"
});
}
var newcomp = new Company();
newcomp.Name = comp.companyName;
newcomp.Email = comp.email;
newcomp.PhoneNumber = comp.phoneNumber;
newcomp.Type = 1;
newcomp.RegDate = DateTime.Now;
newcomp.Location = comp.location;
newcomp.State = comp.state;
db.Company.Add(newcomp);
db.SaveChanges();
var password = comp.password;
var staff = new CompanyStaff();
staff.CompanyId = newcomp.CompanyId;
staff.DateCreated = DateTime.Now;
staff.UseStatus = false;
staff.Password = Utility.Encryptor.EncodePasswordMd5(password);
staff.UserType = "Admin";
db.CompanyStaff.Add(staff);
var staff1 = new CompanyStaff();
staff.CompanyId = newcomp.CompanyId;
staff1.DateCreated = DateTime.Now;
staff1.UseStatus = false;
staff1.Password = Utility.Encryptor.GeneratePassword(6);
staff1.UserType = "User";
db.CompanyStaff.Add(staff);
db.SaveChanges();
var msg = "Hello, " + comp.companyName + ", <br> We are glad to have you on our EduFund crowdfunding Platform. <br> Kindly See your credentials below <br><b>User Id: " + newcomp.PhoneNumber + "</b><br> <b> Password: "******" </b><br><br>#ChangeTheWorldWithYourSpareChange <br><br>Regards,<br> Admin Edufund";
Utility.SendMail.Send("Welcome to EduFund", msg, newcomp.Email, _config);
return(new AddCompanyResponse {
status = "success", msg = "Company Created Successfully"
});
}
}
catch (Exception ex)
{
new Utility.LogWriter(ex.Message + " " + ex.InnerException, env);
return(new AddCompanyResponse {
status = "failed", msg = "Something Went Wrong Try again Later"
});
}
}
public donateResponse donate(donatePayload donate, IConfiguration _config, IHostingEnvironment env)
{
try
{
using (var db = new TrippleNTDBContext()) {
var reco = db.Reconciliation.Where(o => o.CompanyId == donate.companyId && o.Status == "Pending").FirstOrDefault();
if (reco != null)
{
return new donateResponse {
status = "failed", msg = "Cannot commit donations becuase you have pending reconcilation payment "
}
}
;
var donation = new Donations();
donation.DateDonated = DateTime.Now;
donation.CompanyStaffId = donate.userId;
donation.ComapanyId = donate.companyId;
donation.Amount = donate.amount;
donation.Donor = donate.phoneNumber;
donation.Status = "NR";
db.Donations.Add(donation);
db.SaveChanges();
var donor = db.Donors.Find(donate.phoneNumber);
if (donor == null)
{
var d = new Donors();
d.PhoneNumber = donate.phoneNumber;
db.Donors.Add(d);
db.SaveChanges();
}
var msg = "Hello, thank you for your donation, Edufund appreciates your commitment to changing the world with your 'SPARE CHANGE'. Your can view your donation badge here https://bit.ly/fRruwQE";
var a = SendSMS.Send(donate.phoneNumber, msg, _config);
return(new donateResponse {
status = "success", msg = "Donation was Successful. Thank You"
});
}
}
catch (Exception ex)
{
new Utility.LogWriter(ex.Message + " " + ex.InnerException, env);
return(new donateResponse {
status = "failed", msg = "Something went wrong try again Later"
});
}
}
public List <getDonationsResponse> getNotReconciledForCompany(long companyId)
{
try
{
using (var db = new TrippleNTDBContext())
{
var donations = db.Donations.Where(o => o.ComapanyId == companyId && o.Status == "NR").Select(o => new getDonationsResponse {
amount = o.Amount, dateDonated = o.DateDonated.ToString("dd-mmm-yyyy"), status = "Not Reconciled", donor = o.Donor.Substring(0, 2) + "*****" + o.Donor.Substring(8), userId = o.CompanyStaffId
}).ToList();
return(donations);
}
}
catch (Exception ex)
{
return(null);
}
}
public List <getUsersByCompanyResponse> getUserByCompany(long companyId, IHostingEnvironment env)
{
try
{
using (var db = new TrippleNTDBContext())
{
var users = db.CompanyStaff.Where(o => o.CompanyId == companyId).Select(o => new getUsersByCompanyResponse {
userId = o.UserId, status = o.Status, useStatus = o.UseStatus, role = o.UserType, regDate = o.DateCreated.ToString("dd-mmm-yyyy"), password = o.Password
}).ToList();
return(users);
}
}
catch (Exception ex)
{
return(null);
}
}
public object NewRecord(Reconciliation rcd)
{
try
{
using (var db = new TrippleNTDBContext())
{
db.Reconciliation.Add(rcd);
db.SaveChanges();
return(new reconcileResponse {
value = 1
});
}
}
catch (Exception ex)
{
return(new reconcileResponse {
value = 0
});
}
}
public PaymentResponse NewRecord(PaymentPayload rcd)
{
try
{
using (var db = new TrippleNTDBContext())
{
var reco = db.Reconciliation.Find(rcd.ReconcileId);
if (reco == null)
{
return new PaymentResponse {
status = "failed", msg = "Reconciliation ID not Found"
}
}
;
var p = new Payments();
p.ReconcileId = rcd.ReconcileId;
p.Reference = rcd.Reference;
p.DateOfPayment = DateTime.Now;
p.UserId = rcd.UserId;
p.CompanyId = rcd.CompanyId;
p.Amount = rcd.amount;
db.Payments.Add(p);
reco.Status = "Paid";
db.Reconciliation.Attach(reco);
db.Entry(reco).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
var lstunreco = db.Donations.Where(o => o.ComapanyId == rcd.CompanyId && o.DateDonated.Date <= reco.EndPeriod.Date && o.Status == "NR").ToList();
lstunreco.ForEach(o => o.Status = "R");
db.SaveChanges();
return(new PaymentResponse {
status = "success", msg = "Payment Successful"
});
}
}
catch (Exception ex)
{
return(new PaymentResponse {
status = "failed", msg = "Something went wrong try again later"
});
}
}
public static loginResponse Login(loginPayload payload, IHostingEnvironment env)
{
try
{
using (var db = new TrippleNTDBContext())
{
if (payload.username.Length <= 7)
{
var userid = Convert.ToInt64(payload.username);
var user = db.CompanyStaff.Find(userid);
if (user.Status == "Disabled")
{
return new loginResponse {
status = "failed", msg = "You are not Authirized on this system"
}
}
;
if (user == null)
{
return new loginResponse {
status = "failed", msg = "Invalid Username or Password"
}
}
;
else
{
return user.Password == Utility.Encryptor.EncodePasswordMd5(payload.password)? new loginResponse {
status = "success", msg = "Login Successful", role = user.UserType, id = user.UserId.ToString(), companyId = user.CompanyId.ToString(), companyName = db.Company.Find(user.CompanyId).Name, firsttime = user.UseStatus
}
} : new loginResponse {
status = "failed", msg = "Invalid Username or Password", role = "", id = "", companyId = "", companyName = "", firsttime = false
};
}
else
{
var company = db.Company.Where(o => o.PhoneNumber == payload.username).FirstOrDefault();
if (company == null)
{
return new loginResponse {
status = "failed", msg = "Invalid Username or Password"
}
}
;
else
{
var password = Utility.Encryptor.EncodePasswordMd5(payload.password);
var user = db.CompanyStaff.Where(o => o.CompanyId == company.CompanyId && o.UserType == "Admin" && o.Password == password).FirstOrDefault();
return(user.Password == Utility.Encryptor.EncodePasswordMd5(payload.password) ? new loginResponse {
status = "success", msg = "Login Successful", role = user.UserType, id = user.UserId.ToString(), companyId = user.CompanyId.ToString(), companyName = db.Company.Find(user.CompanyId).Name, firsttime = user.UseStatus
} : new loginResponse {
status = "failed", msg = "Invalid Username or Password", role = "", id = "", companyId = "", companyName = "", firsttime = false
});
}
}
}
}
catch (Exception ex)
{
new Utility.LogWriter(ex.Message + " " + ex.InnerException, env);
return(new loginResponse {
status = "failed", msg = "Something went wrong try again later"
});
}
}
