public master_lodgement_reimbursment alter_master_lodgement_reimbursment()
{
try
{
master_lodgement_reimbursment prev_master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == master_lodgement_reimbursment.id);
prev_master_lodgement_reimbursment.amount = master_lodgement_reimbursment.amount;
prev_master_lodgement_reimbursment.bank = master_lodgement_reimbursment.bank;
prev_master_lodgement_reimbursment.date = master_lodgement_reimbursment.date;
prev_master_lodgement_reimbursment.from_date = master_lodgement_reimbursment.from_date;
prev_master_lodgement_reimbursment.islocked = master_lodgement_reimbursment.islocked;
prev_master_lodgement_reimbursment.isverified = master_lodgement_reimbursment.isverified;
prev_master_lodgement_reimbursment.shop = master_lodgement_reimbursment.shop;
prev_master_lodgement_reimbursment.teller_number = master_lodgement_reimbursment.teller_number;
prev_master_lodgement_reimbursment.to_date = master_lodgement_reimbursment.to_date;
prev_master_lodgement_reimbursment.transaction = master_lodgement_reimbursment.transaction;
prev_master_lodgement_reimbursment.transaction_category = master_lodgement_reimbursment.transaction_category;
prev_master_lodgement_reimbursment.transaction_type = master_lodgement_reimbursment.transaction_type;
prev_master_lodgement_reimbursment.weekno = master_lodgement_reimbursment.weekno;
db.SubmitChanges();
return(master_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public master_lodgement_reimbursment find_master_lodgement_reimbursment_By_AppId(string Appid)
{
try
{
master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.app_id == Appid);
return(master_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public master_lodgement_reimbursment find_master_lodgement_reimbursment_By_ID(int id)
{
try
{
master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == id);
return(master_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public master_lodgement_reimbursment delete_master_lodgement_reimbursment()
{
try
{
master_lodgement_reimbursment prev_master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == master_lodgement_reimbursment.id);
db.master_lodgement_reimbursments.DeleteOnSubmit(prev_master_lodgement_reimbursment);
return(master_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public bool initializeParameters(shop shop, string message, master_lodgement_reimbursment trans)
{
if (message.Contains("{lodgement_analysis}"))
{
string lodgementstring = "";
lodgementstring = "NGN" + trans.amount.ToString("#,0.00") + " to our " + trans.bank1.code + " A/C";
message = message.Replace("{lodgement_analysis}", lodgementstring);
}
if (message.Contains("{reimbursment_analysis}"))
{
string reimbursmentstring = "";
reimbursmentstring = "NGN" + trans.amount.ToString("#,0.00");
message = message.Replace("{reimbursment_analysis}", reimbursmentstring);
}
messages = message;
return(initializeParameters(shop, message, new object()));
}
public bool SaveMasterLodgementTransaction(master_lodgement_reimbursment newmlr, master_transaction newmastertransaction, master_balance_sheet masterbalance)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
newmastertransaction.app_id = Application().app_id;
newmlr.app_id = Application().app_id;
db.master_transactions.InsertOnSubmit(newmastertransaction);
db.SubmitChanges();
newmlr.transaction = new CRUD.master_transaction_crud().find_master_transaction_By_AppId(newmastertransaction.app_id).id;
newmlr.transaction_type = (newmastertransaction.transaction_category.type == true) ? 1 : 0;
newmlr.transaction_category = newmastertransaction.trans_category;
db.master_lodgement_reimbursments.InsertOnSubmit(newmlr);
master_balance_sheet prev_master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.id == masterbalance.id);
prev_master_balance_sheet.credit_balance = masterbalance.credit_balance;
prev_master_balance_sheet.netbalance = masterbalance.netbalance;
prev_master_balance_sheet.online_credit = masterbalance.online_credit;
prev_master_balance_sheet.sales_balance = masterbalance.sales_balance;
db.SubmitChanges();
scope.Complete();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public master_lodgement_reimbursment_crud(master_lodgement_reimbursment master_lodgement_reimbursment_)
{
this.master_lodgement_reimbursment_ = master_lodgement_reimbursment_;
}
private void AddnewLodgementReimbursementTransaction(shop shop, transaction_category tran, PaymentNotificationRequest pnr, BettingSuiteDataContext db)
{
DateTime date = DateTime.Today;
master_balance_sheet masterbalance = new CRUD.master_balance_sheet_crud().getMasterBalanceByShopId(shop.id);
if (masterbalance == null)
{
masterbalance = new master_balance_sheet
{
shop = shop.id,
credit_balance = 0,
online_credit = 0,
sales_balance = 0,
netbalance = 0,
};
masterbalance = new CRUD.master_balance_sheet_crud(masterbalance).insert_master_balance_sheet();
}
master_transaction reversalmastertransaction = new master_transaction();
master_lodgement_reimbursment newmlr = new master_lodgement_reimbursment
{
amount = pnr.Amount,
bank = 0,//interswitch id,
date = date,
shop = shop.id,
teller_number = pnr.PaymentLogId.ToString(),
islocked = true,
isverified = true,
payment_type = 5,
transaction_category = tran.id,
};
login lodin = db.logins.Single(a => a.username == "InterSwitch");
master_transaction newmastertransaction = new master_transaction
{
amount = Math.Abs(pnr.Amount),
balance_before = (masterbalance != null) ? masterbalance.sales_balance : 0,
balance_after = (masterbalance != null) ? getbal(masterbalance.sales_balance, pnr.Amount, tran) : pnr.Amount,
shop = shop.id,
trans_category = tran.id,
trans_timestamp = DateTime.Now,
trans_type = (tran.type == true) ? 1 : 0,
posted_by = lodin.id,// interswitch id,
description = pnr.PaymentReference + " Posted For " + date.ToShortDateString(),
details = (tran.code == "L") ? "Lodgement For " + date.ToShortDateString() : "Lodgement Reversal For " + date.ToShortDateString()
};
masterbalance.sales_balance = (masterbalance != null) ? getbal(masterbalance.sales_balance, newmastertransaction.amount, tran) : newmastertransaction.amount;
masterbalance.netbalance = (masterbalance != null) ? getbal(masterbalance.netbalance, newmastertransaction.amount, tran) : newmastertransaction.amount;
bool loadtran = new Utilities.TransactionHelper().SaveMasterLodgementTransaction(newmlr, newmastertransaction, masterbalance);
if (loadtran)
{
try
{
bool mailvalidity = new Utilities.Mail_Validity_Helper().getMailSendingStatus();
SMS_Vendor_Validity_Helper valhelp = new SMS_Vendor_Validity_Helper();
sms_vendor vendor = valhelp.getVendorsByName("50kobo");
bool smsvalidity = (DateTime.Today <= vendor.expiry_date) ? true : false;
if (newmlr.bank1.code != "CASH")
{
sms message;
if (tran.code == "L")
{
if (smsvalidity)
{
sm mm = new CRUD.sms_crud().findByCode("CA");
message = new sms();
if (message.initializeParameters(shop, mm.subject.Trim() + "\r\n" + mm.content.Trim() + "\r\n" + mm.conclusion.Trim(), newmlr))
{
message.CustomizeAndSendSMS();
}
}
if (mailvalidity)
{
mail mail = new CRUD.mail_crud().findByCode("LA");
MailClient client = new MailClient();
client.SendLodgementReimbursementMail(shop, mail, newmastertransaction);
}
}
else if (tran.code == "R")
{
if (smsvalidity)
{
sm mm = new CRUD.sms_crud().findByCode("DA");
message = new sms();
if (message.initializeParameters(shop, mm.subject + "\r\n" + mm.content + "\r\n" + mm.conclusion, newmlr))
{
message.CustomizeAndSendSMS();
}
}
if (mailvalidity)
{
mail mail = new CRUD.mail_crud().findByCode("RA");
MailClient client = new MailClient();
client.SendLodgementReimbursementMail(shop, mail, newmastertransaction);
}
}
}
}
catch (Exception)
{
}
}
else
{
}
}
