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_lodgement_reimbursment alter_shop_lodgement_reimbursment()
{
try
{
shop_lodgement_reimbursment prev_shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == shop_lodgement_reimbursment.id);
prev_shop_lodgement_reimbursment.amount = shop_lodgement_reimbursment.amount;
prev_shop_lodgement_reimbursment.bank = shop_lodgement_reimbursment.bank;
prev_shop_lodgement_reimbursment.date = shop_lodgement_reimbursment.date;
prev_shop_lodgement_reimbursment.from_date = shop_lodgement_reimbursment.from_date;
prev_shop_lodgement_reimbursment.islocked = shop_lodgement_reimbursment.islocked;
prev_shop_lodgement_reimbursment.isverified = shop_lodgement_reimbursment.isverified;
prev_shop_lodgement_reimbursment.shop = shop_lodgement_reimbursment.shop;
prev_shop_lodgement_reimbursment.teller_number = shop_lodgement_reimbursment.teller_number;
prev_shop_lodgement_reimbursment.to_date = shop_lodgement_reimbursment.to_date;
prev_shop_lodgement_reimbursment.transaction = shop_lodgement_reimbursment.transaction;
prev_shop_lodgement_reimbursment.weekno = shop_lodgement_reimbursment.weekno;
db.SubmitChanges();
return(shop_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public shop_lodgement_reimbursment find_shop_lodgement_reimbursment_By_AppId(string Appid)
{
try
{
shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.app_id == Appid);
return(shop_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public shop_lodgement_reimbursment find_shop_lodgement_reimbursment_By_ID(int id)
{
try
{
shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == id);
return(shop_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public shop_lodgement_reimbursment delete_shop_lodgement_reimbursment()
{
try
{
shop_lodgement_reimbursment prev_shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == shop_lodgement_reimbursment.id);
db.shop_lodgement_reimbursments.DeleteOnSubmit(prev_shop_lodgement_reimbursment);
return(shop_lodgement_reimbursment);
}
catch (Exception)
{
return(null);
}
}
public shop_lodgement_reimbursment_crud(shop_lodgement_reimbursment shop_lodgement_reimbursment_)
{
this.shop_lodgement_reimbursment_ = shop_lodgement_reimbursment_;
}
