public credit_type insert_credit_type()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.applications.InsertOnSubmit(app);
credit_type.App_id = app.app_id;
db.credit_types.InsertOnSubmit(credit_type);
db.SubmitChanges();
scope.Complete();
}
return(find_credit_type_By_AppId(credit_type.App_id));
}
catch (Exception)
{
return(null);
}
}
public master_balance_sheet insert_master_balance_sheet()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.applications.InsertOnSubmit(app);
master_balance_sheet.App_id = app.app_id;
db.master_balance_sheets.InsertOnSubmit(master_balance_sheet);
db.SubmitChanges();
scope.Complete();
}
return(find_master_balance_sheet_By_AppId(master_balance_sheet.App_id));
}
catch (Exception)
{
return(null);
}
}
public shop_expense insert_shop_expense()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.SubmitChanges();
shop_expense.app_id = app.app_id;
db.shop_expenses.InsertOnSubmit(shop_expense);
db.SubmitChanges();
scope.Complete();
}
return(find_shop_expense_By_AppId(shop_expense.app_id));
}
catch (Exception)
{
return(null);
}
}
public bank_list insert_bank_list()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.applications.InsertOnSubmit(app);
bank_list.app_id = app.app_id;
db.bank_lists.InsertOnSubmit(bank_list);
db.SubmitChanges();
scope.Complete();
}
return(find_bank_list_By_AppId(bank_list.app_id));
}
catch (Exception)
{
return(null);
}
}
public mail insert_mail()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//application app = new application
//{
// app_id = Guid.NewGuid().ToString()
//};
//db.applications.InsertOnSubmit(app);
// mail.app_id = app.app_id;
db.mails.InsertOnSubmit(mail);
db.SubmitChanges();
scope.Complete();
}
return(mail);
}
catch (Exception)
{
return(null);
}
}
public shop insert_shop()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.SubmitChanges();
shop.app_id = app.app_id;
shop.master_balance_sheets.Add(new master_balance_sheet {
App_id = Guid.NewGuid().ToString(), credit_balance = 0, netbalance = 0, online_credit = 0, sales_balance = 0
});
db.shops.InsertOnSubmit(shop);
db.SubmitChanges();
scope.Complete();
}
return(find_shop_By_AppId(shop.app_id));
}
catch (Exception)
{
return(null);
}
}
public login insert_login()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
login.password = Utilities.MD5Encript.MD5Hash(login.password);
db.applications.InsertOnSubmit(app);
login.App_id = app.app_id;
db.logins.InsertOnSubmit(login);
db.SubmitChanges();
scope.Complete();
}
return(find_login_By_AppId(login.App_id));
}
catch (Exception)
{
return(null);
}
}
public master_sb_sale alter_master_sb_sale()
{
try
{
master_sb_sale prev_master_sb_sale = db.master_sb_sales.SingleOrDefault(a => a.id == master_sb_sale.id);
prev_master_sb_sale.balance = master_sb_sale.balance;
prev_master_sb_sale.cancelled = master_sb_sale.cancelled;
prev_master_sb_sale.commision = master_sb_sale.commision;
prev_master_sb_sale.date = master_sb_sale.date;
prev_master_sb_sale.date_posted = master_sb_sale.date_posted;
prev_master_sb_sale.islocked = master_sb_sale.islocked;
prev_master_sb_sale.isverified = master_sb_sale.isverified;
prev_master_sb_sale.net_balance = master_sb_sale.net_balance;
prev_master_sb_sale.posted_by = master_sb_sale.posted_by;
prev_master_sb_sale.sales = master_sb_sale.sales;
prev_master_sb_sale.shop = master_sb_sale.shop;
prev_master_sb_sale.stake = master_sb_sale.stake;
prev_master_sb_sale.winnings = master_sb_sale.winnings;
db.SubmitChanges();
return(master_sb_sale);
}
catch (Exception)
{
return(null);
}
}
public login_log insert_login_log()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.applications.InsertOnSubmit(app);
login_log.App_id = app.app_id;
db.login_logs.InsertOnSubmit(login_log);
db.SubmitChanges();
scope.Complete();
}
return(find_login_log_By_AppId(login_log.App_id));
}
catch (Exception)
{
return(null);
}
}
public admin_user insert_admin_user()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
application app = new application
{
app_id = Guid.NewGuid().ToString()
};
db.applications.InsertOnSubmit(app);
admin_user.app_id = app.app_id;
if (admin_user.login1 != null)
{
admin_user.login1.password = Utilities.MD5Encript.MD5Hash(admin_user.login1.password);
}
db.admin_users.InsertOnSubmit(admin_user);
db.SubmitChanges();
scope.Complete();
}
return(find_admin_user_By_AppId(admin_user.app_id));
}
catch (Exception)
{
return(null);
}
}
public transaction_type insert_transaction_type()
{
try
{
db.transaction_types.InsertOnSubmit(transaction_type);
db.SubmitChanges();
return(find_transaction_type_By_AppId(transaction_type.App_id));
}
catch (Exception)
{
return(null);
}
}
public shop_credit insert_shop_credit()
{
try
{
db.shop_credits.InsertOnSubmit(shop_credit);
db.SubmitChanges();
return(find_shop_credit_By_AppId(shop_credit.app_id));
}
catch (Exception)
{
return(null);
}
}
public master_expense insert_master_expense()
{
try
{
db.master_expenses.InsertOnSubmit(master_expense);
db.SubmitChanges();
return(find_master_expense_By_AppId(master_expense.app_id));
}
catch (Exception)
{
return(null);
}
}
public shop_balance_sheet insert_shop_balance_sheet()
{
try
{
db.shop_balance_sheets.InsertOnSubmit(shop_balance_sheet);
db.SubmitChanges();
return(find_shop_balance_sheet_By_AppId(shop_balance_sheet.App_id));
}
catch (Exception)
{
return(null);
}
}
public master_credit insert_master_credit()
{
try
{
db.master_credits.InsertOnSubmit(master_credit);
db.SubmitChanges();
return(find_master_credit_By_AppId(master_credit.app_id));
}
catch (Exception)
{
return(null);
}
}
public commission_transaction insert_commission_transaction()
{
try
{
db.commission_transactions.InsertOnSubmit(commission_transaction);
db.SubmitChanges();
return(find_commission_transaction_By_AppId(commission_transaction.app_id));
}
catch (Exception)
{
return(null);
}
}
public transaction_category insert_transaction_category()
{
try
{
db.transaction_categories.InsertOnSubmit(transaction_category);
db.SubmitChanges();
return(find_transaction_category_By_AppId(transaction_category.app_id));
}
catch (Exception)
{
return(null);
}
}
public master_transaction insert_master_transaction()
{
try
{
db.master_transactions.InsertOnSubmit(master_transaction);
db.SubmitChanges();
return(find_master_transaction_By_AppId(master_transaction.app_id));
}
catch (Exception)
{
return(null);
}
}
public master_lodgement_reimbursment insert_master_lodgement_reimbursment()
{
try
{
db.master_lodgement_reimbursments.InsertOnSubmit(master_lodgement_reimbursment);
db.SubmitChanges();
return(find_master_lodgement_reimbursment_By_AppId(master_lodgement_reimbursment.app_id));
}
catch (Exception)
{
return(null);
}
}
public state_local_govt insert_state_local_govt()
{
try
{
db.state_local_govts.InsertOnSubmit(state_local_govt);
db.SubmitChanges();
return(state_local_govt);
}
catch (Exception)
{
return(null);
}
}
public debt_transaction insert_debt_transaction()
{
try
{
db.debt_transactions.InsertOnSubmit(debt_transaction);
db.SubmitChanges();
return(find_debt_transaction_By_AppId(debt_transaction.app_id));
}
catch (Exception)
{
return(null);
}
}
public shop_type insert_shop_type()
{
try
{
db.shop_types.InsertOnSubmit(shop_type);
db.SubmitChanges();
return(find_shop_type_By_AppId(shop_type.app_id));
}
catch (Exception)
{
return(null);
}
}
public application insert_application()
{
try
{
application.app_id = Guid.NewGuid().ToString();
db.applications.InsertOnSubmit(application);
db.SubmitChanges();
return(find_application_By_AppId(application.app_id));
}
catch (Exception)
{
return(null);
}
}
private void SaveTransactions()
{
try
{
using (TransactionScope scope = new TransactionScope())
{
db.master_transactions.InsertAllOnSubmit(transactionsToSave);
db.debt_transactions.InsertAllOnSubmit(debtTransactionToSave);
foreach (master_balance_sheet bal in ShopBalancesToUpdate)
{
master_balance_sheet prevbal = db.master_balance_sheets.SingleOrDefault(a => a.id == bal.id);
prevbal.credit_balance = bal.credit_balance;
prevbal.sales_balance = bal.sales_balance;
prevbal.netbalance = bal.netbalance;
}
foreach (debt debt in shopDebtsToUpdate)
{
debt prevdebt = db.debts.SingleOrDefault(a => a.id == debt.id);
prevdebt.current_amount = debt.current_amount;
prevdebt.status = debt.status;
}
db.SubmitChanges();
scope.Complete();
}
}
catch (Exception)
{
}
}
public void loadStream(string x)
{
//if (Request.ContentType == "text/xml" || Request.ContentType == "text/plain" || Request.ContentType == "text/html"|| Request.ContentType == "application/xml")
//{
XDocument doc = null;;
XDocument xmlInput = XDocument.Parse(x);
IEnumerable <XElement> requests = xmlInput.Elements();
//initialize to objects and process then return request;
string root = xmlInput.Root.Name.ToString();
if (root.Contains("Customer"))
{
doc = generateCustomerValidationRequests(doc, requests);
}
else if (root.Contains("PaymentNotificationRequest"))
{
payment_request req = new payment_request {
request = x, date = DateTime.Now
};
BettingSuiteDataContext db = new BettingSuiteDataContext();
db.payment_requests.InsertOnSubmit(req);
db.SubmitChanges();
var paymentrequests = xmlInput.Descendants("Payment").ToList();
doc = generatePaymentNotificationRequests(doc, paymentrequests);
}
sendResponse(doc);
// }
//}
}
private bool savePaymentDetails(PaymentNotificationRequestHelper pnr)
{
BettingSuiteDataContext db = new BettingSuiteDataContext();
if (iSNotDuplicate(pnr.getPaymentLogId(), db))
{
try
{
using (TransactionScope scope = new TransactionScope())
{
PaymentNotificationRequest pr = setPaymentRequestObjAndSave(pnr, db);
shop shop = new CRUD.shop_crud().find_shop_By_ID(pr.CustReference);
foreach (PaymentItemHelper it in pnr.getPaymentItems())
{
if (it.getItemCode().Equals(ConfigurationManager.AppSettings["SalesCode"].ToString()))
{
AddSalesTransaction(shop, pr, db);
}
else if (it.getItemCode().Equals(ConfigurationManager.AppSettings["LEASE DEBT"].ToString()))
{
//do lease debt lodgement
}
else if (it.getItemCode().Equals(ConfigurationManager.AppSettings["OPERATIONAL DEBT"].ToString()))
{
//do operational debt lodgement
}
else if (it.getItemCode().Equals(ConfigurationManager.AppSettings["ONLINE AGENCY"].ToString()))
{
//send online dept updates on online agency
}
else if (it.getItemCode().Equals(ConfigurationManager.AppSettings["ONLINE USER"].ToString()))
{
//send online dept updates on online user
}
else if (it.getItemCode().Equals(ConfigurationManager.AppSettings["PAYMENT COMMISION"].ToString()))
{
//futute implementation
}
else
{
//send acknologement message of payments
}
}
db.SubmitChanges();
scope.Complete();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
else
{
}
return(false);
}
public void saveList()
{
db.SubmitChanges();
//foreach (master_transaction user in list_)
//{
// new CRUD.master_transactions_crud(user).alter_master_transaction();
//}
}
public void saveList()
{
db.SubmitChanges();
//foreach (admin_user user in list_)
//{
// new CRUD.admin_users_crud(user).alter_admin_user();
//}
}
public bool rechargeVendor(string name, int newcredits)
{
try{
sms_vendor vendor = getVendorsByName(name);
vendor.remaining_credits += newcredits;
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool ReactivateMail(string validationcode, int days, int val)
{
mail_validity mailvalidity = db.mail_validities.First();
if (mailvalidity.validatycode == validationcode && val == 1)
{
mailvalidity.expirydate = mailvalidity.expirydate.Value.AddDays(days);
db.SubmitChanges();
return(true);
}
else if (mailvalidity.validatycode == validationcode && val == 2)
{
//sms_vendor smsv;
db.sms_vendors.SingleOrDefault(a => a.vendor_name == "50kobo").expiry_date.AddDays(days);
//smsv.expiry_date = smsv.expiry_date.AddDays(days);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}