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_balance find_commission_balance_By_ShopId(int ShopId)
{
try
{
commission_balance = db.commission_balances.SingleOrDefault(a => a.shop == ShopId);
return(commission_balance);
}
catch (Exception)
{
return(null);
}
}
public commission_balance find_commission_balance_By_AppId(string Appid)
{
try
{
commission_balance = db.commission_balances.SingleOrDefault(a => a.app_id == Appid);
return(commission_balance);
}
catch (Exception)
{
return(null);
}
}
public commission_balance find_commission_balance_By_ID(int id)
{
try
{
commission_balance = db.commission_balances.SingleOrDefault(a => a.id == id);
return(commission_balance);
}
catch (Exception)
{
return(null);
}
}
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_balance delete_commission_balance()
{
try
{
commission_balance prev_commission_balance = db.commission_balances.SingleOrDefault(a => a.id == commission_balance.id);
db.commission_balances.DeleteOnSubmit(prev_commission_balance);
return(commission_balance);
}
catch (Exception)
{
return(null);
}
}
public commission_balance alter_commission_balance()
{
try
{
commission_balance prev_commission_balance_sheet = db.commission_balances.SingleOrDefault(a => a.id == commission_balance.id);
prev_commission_balance_sheet.balance = commission_balance.balance;
db.SubmitChanges();
return(commission_balance);
}
catch (Exception)
{
return(null);
}
}
public commission_balance_crud(commission_balance commission_balance_)
{
this.commission_balance_ = commission_balance_;
}
