public commission_transaction alter_commission_transaction()
{
try
{
commission_transaction prev_commission_transaction = db.commission_transactions.SingleOrDefault(a => a.id == commission_transaction.id);
prev_commission_transaction.amount = commission_transaction.amount;
prev_commission_transaction.balance_before = commission_transaction.balance_before;
prev_commission_transaction.balance_after = commission_transaction.balance_after;
prev_commission_transaction.posted_by = commission_transaction.posted_by;
prev_commission_transaction.shop = commission_transaction.shop;
prev_commission_transaction.trans_category = commission_transaction.trans_category;
prev_commission_transaction.trans_timestamp = commission_transaction.trans_timestamp;
prev_commission_transaction.trans_type = commission_transaction.trans_type;
db.SubmitChanges();
return(commission_transaction);
}
catch (Exception)
{
return(null);
}
}
public StatementHelper(commission_transaction trans)
{
Date_ = trans.trans_timestamp.ToShortDateString();
Debit_ = (trans.trans_type == 1) ? trans.amount.ToString() : string.Empty;
Credit_ = (trans.trans_type == 0) ? trans.amount.ToString() : string.Empty;
Balance_ = trans.balance_after.ToString();
Details_ = (trans.details != string.Empty || trans.details != null) ? trans.details : trans.transaction_category.description;
ctrans_ = trans;
}
private void LodgeCommission(master_transaction master_transaction, transaction_category tran)
{
commission_balance balance = db.commission_balances.SingleOrDefault(a => a.shop == master_transaction.shop);
if (balance == null)
{
balance = new commission_balance
{
shop = master_transaction.shop.Value,
balance = 0
};
}
transaction_category commtran = null;
if (tran.code == "CR")
{
commtran = db.transaction_categories.SingleOrDefault(a => a.code == "CTR");
}
else if (tran.code == "C")
{
commtran = db.transaction_categories.SingleOrDefault(a => a.code == "CT");
}
commission_transaction ctran = new commission_transaction
{
amount = master_transaction.amount,
balance_after = getbal(balance.balance, master_transaction.amount, commtran),
balance_before = balance.balance,
description = master_transaction.details,
details = master_transaction.details,
posted_by = master_transaction.posted_by,
shop = master_transaction.shop,
trans_category = commtran.id,
trans_timestamp = master_transaction.trans_timestamp,
trans_type = commtran.type == true ? 1 : 0
};
balance.balance = getbal(balance.balance, master_transaction.amount, commtran).Value;
using (TransactionScope scope = new TransactionScope())
{
if (balance.app_id == null)
{
balance.app_id = getAppID().app_id;
db.commission_balances.InsertOnSubmit(balance);
}
ctran.app_id = getAppID().app_id;
db.commission_transactions.InsertOnSubmit(ctran);
db.SubmitChanges();
scope.Complete();
}
}
public commission_transaction find_commission_transaction_By_AppId(string Appid)
{
try
{
commission_transaction = db.commission_transactions.SingleOrDefault(a => a.app_id == Appid);
return(commission_transaction);
}
catch (Exception)
{
return(null);
}
}
public commission_transaction find_commission_transaction_By_ID(int id)
{
try
{
commission_transaction = db.commission_transactions.SingleOrDefault(a => a.id == id);
return(commission_transaction);
}
catch (Exception)
{
return(null);
}
}
public commission_transaction delete_commission_transaction()
{
try
{
commission_transaction prev_commission_transaction = db.commission_transactions.SingleOrDefault(a => a.id == commission_transaction.id);
db.commission_transactions.DeleteOnSubmit(prev_commission_transaction);
return(commission_transaction);
}
catch (Exception)
{
return(null);
}
}
public bool SendCommissionLodgementReimbursementMail(shop shop, WgbSalesUpload.mail mail, commission_transaction newmastertransaction)
{
try
{
admin_user user = new CRUD.admin_users_crud().find_admin_user_By_ID(shop.agent.Value);
string body = mail.content;
if (user != null && user.email != "" && user.email != string.Empty && user.email != null)
{
string accountName = ((user.firstname != null) ? user.firstname.ToUpperInvariant() : "") + " " + ((user.middlename != null) ? user.middlename.ToUpperInvariant() : "") + " " + ((user.lastname != null) ? user.lastname.ToUpperInvariant() : "");
string balance = "";
if (newmastertransaction != null && shop.master_balance_sheets.Count > 0)
{
balance = newmastertransaction.amount.ToString();
}
body = body.Replace("{shop_code}", shop.shop_code);
body = body.Replace("{account_name}", (accountName != null) ? accountName : "UNAVAILABLE");
body = body.Replace("{amount}", balance);
body = body.Replace("{curr_debt_bal}", newmastertransaction.balance_after.ToString());
body = body.Replace("{bank_acct}", getbankaccounts());
SendBulkMail(user.email, mail.name, body);
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public bool SaveMasterCommissionLodgementTransaction(commission_lodgement_reimbursment newmlr, commission_transaction newmastertransaction, commission_balance commissionbalance)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
newmastertransaction.app_id = Application().app_id;
newmlr.app_id = Application().app_id;
db.commission_transactions.InsertOnSubmit(newmastertransaction);
db.SubmitChanges();
newmlr.transaction = new CRUD.commission_transaction_crud().find_commission_transaction_By_AppId(newmastertransaction.app_id).id;
newmlr.transaction_type = (newmastertransaction.transaction_category.type == true) ? 1 : 0;
newmlr.transaction_category = newmastertransaction.trans_category;
db.commission_lodgement_reimbursments.InsertOnSubmit(newmlr);
commission_balance prev_master_balance_sheet = db.commission_balances.SingleOrDefault(a => a.id == commissionbalance.id);
prev_master_balance_sheet.balance = commissionbalance.balance;
db.SubmitChanges();
scope.Complete();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public commission_transaction_crud(commission_transaction commission_transaction_)
{
this.commission_transaction_ = commission_transaction_;
}
