public bool SaveMasterLodgementTransaction(shop_lodgement_reimbursment newmlr, shop_transaction newmastertransaction, shop_balance_sheet masterbalance)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
newmastertransaction.app_id = Application().app_id;
db.shop_transactions.InsertOnSubmit(newmastertransaction);
db.SubmitChanges();
newmlr.transaction = new CRUD.shop_transaction_crud().find_shop_transaction_By_AppId(newmastertransaction.app_id).id;
db.shop_lodgement_reimbursments.InsertOnSubmit(newmlr);
shop_balance_sheet prev_master_balance_sheet = db.shop_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 shop_balance_sheet find_shop_balance_sheet_By_AppId(string Appid)
{
try
{
shop_balance_sheet = db.shop_balance_sheets.SingleOrDefault(a => a.App_id == Appid);
return(shop_balance_sheet);
}
catch (Exception)
{
return(null);
}
}
public shop_balance_sheet find_shop_balance_sheet_By_ID(int id)
{
try
{
shop_balance_sheet = db.shop_balance_sheets.SingleOrDefault(a => a.id == id);
return(shop_balance_sheet);
}
catch (Exception)
{
return(null);
}
}
public shop_balance_sheet delete_shop_balance_sheet()
{
try
{
shop_balance_sheet prev_shop_balance_sheet = db.shop_balance_sheets.SingleOrDefault(a => a.id == shop_balance_sheet.id);
db.shop_balance_sheets.DeleteOnSubmit(prev_shop_balance_sheet);
return(shop_balance_sheet);
}
catch (Exception)
{
return(null);
}
}
public shop_balance_sheet alter_shop_balance_sheet()
{
try
{
shop_balance_sheet prev_shop_balance_sheet = db.shop_balance_sheets.SingleOrDefault(a => a.id == shop_balance_sheet.id);
prev_shop_balance_sheet.credit_balance = shop_balance_sheet.credit_balance;
prev_shop_balance_sheet.netbalance = shop_balance_sheet.netbalance;
prev_shop_balance_sheet.online_credit = shop_balance_sheet.online_credit;
prev_shop_balance_sheet.sales_balance = shop_balance_sheet.sales_balance;
prev_shop_balance_sheet.online_credit = shop_balance_sheet.online_credit;
prev_shop_balance_sheet.sales_balance = shop_balance_sheet.sales_balance;
db.SubmitChanges();
return(shop_balance_sheet);
}
catch (Exception)
{
return(null);
}
}
public int VerifyExPenses(List <shop_expense> ShopExpenses, bool verifymode)
{
int returnValue = 0;
try
{
using (TransactionScope scope = new TransactionScope())
{
transaction_category tran = new CRUD.transaction_category_crud().find_transaction_category_By_code((verifymode)?"E":"ER");
foreach (shop_expense shopexp in ShopExpenses)
{
shop_expense expenses = db.shop_expenses.SingleOrDefault(a => a.id == shopexp.id);
if (expenses.isverified != verifymode)
{
expenses.islocked = verifymode;
expenses.isverified = verifymode;
shop_balance_sheet mastsheet;
shop_balance_sheet sheet = (new CRUD.shop_balance_sheet_crud().getBalanceForShop(shopexp.shop.Value));
if (sheet == null)
{
mastsheet = new shop_balance_sheet
{
App_id = Application().app_id,
credit_balance = 0,
netbalance = 0,
online_credit = 0,
sales_balance = 0,
shop = shopexp.shop.Value
};
}
else
{
mastsheet = sheet;
}
shop_transaction transaction = new shop_transaction
{
app_id = Application().app_id,
amount = shopexp.amount.Value,
balance_before = mastsheet.netbalance,
balance_after = getbal(mastsheet.netbalance, shopexp.amount, tran),
posted_by = shopexp.shop1.login.id,
shop = shopexp.shop,
trans_category = tran.id,
trans_timestamp = DateTime.Now,
trans_type = (tran.type == true) ? 1 : 0,
details = "Exp For - " + shopexp.comment,
};
mastsheet.sales_balance = getbal(mastsheet.sales_balance, transaction.amount, tran);
mastsheet.netbalance = getbal(mastsheet.netbalance, transaction.amount, tran);
db.shop_transactions.InsertOnSubmit(transaction);
if (sheet == null)
{
db.shop_balance_sheets.InsertOnSubmit(mastsheet);
}
else
{
shop_balance_sheet prevbalsheet = db.shop_balance_sheets.SingleOrDefault(a => a.shop == shopexp.shop);
prevbalsheet.netbalance = mastsheet.netbalance;
prevbalsheet.online_credit = mastsheet.online_credit;
prevbalsheet.credit_balance = mastsheet.credit_balance;
prevbalsheet.sales_balance = mastsheet.sales_balance;
}
db.SubmitChanges();
scope.Complete();
returnValue++;
}
}
}
return(returnValue);
}
catch (Exception)
{
return(0);
}
}
public shop_balance_sheet_crud(shop_balance_sheet shop_balance_sheet_)
{
this.shop_balance_sheet_ = shop_balance_sheet_;
}
