public winningsHelper(master_balance_sheet master_balance_sheet_)
{
try
{
this.master_balance_sheet = master_balance_sheet_;
shop_code = master_balance_sheet.shop1.shop_code;
admin_user user = new admin_user();
if (master_balance_sheet.shop1.agent != null)
{
user = new CRUD.admin_users_crud().find_admin_user_By_ID(master_balance_sheet.shop1.agent.Value);
}
else if (master_balance_sheet.shop1.shopmanager_id != null)
{
int shopmanager = master_balance_sheet.shop1.shopmanager_id.Value;
login login = new CRUD.logins_crud().find_login_By_ID(shopmanager);
user = new CRUD.admin_users_crud().find_admin_user_By_ID(login.admin_users[0].id);
}
AccountNumber = (user.accountNo != null)? user.accountNo: "";
AccountName = (user.account_name != null) ? user.account_name : "";
Bank = (user.bank_list != null) ? user.bank_list.name : "";
Balance = master_balance_sheet.sales_balance.Value;
}
catch (Exception)
{
this.master_balance_sheet = master_balance_sheet_;
shop_code = master_balance_sheet.shop1.shop_code;
AccountNumber = "";
AccountName = "";
Bank = "";
Balance = master_balance_sheet.sales_balance.Value;
}
}
public string ChangePassword(ChangePasswordModel req)
{
if (!ModelState.IsValid)
{
Response.Status = "400";
return("非法提交");
}
QCTESTEntities QC_DB = new QCTESTEntities();
int id = userHelper.getUserID();
admin_user user = QC_DB.admin_user.First(t => t.ID == id);
if (user.Password != req.Password)
{
Response.Status = "400";
return("旧密码错误");
}
user.Password = req.Password;
QC_DB.SaveChanges();
return(true.ToString());
}
public addressHelper(shop shop)
{
Shop_Code = shop.shop_code;
try
{
if (shop.agent != null)
{
admin_user user = db.admin_users.SingleOrDefault(a => a.id == shop.agent);
Address = (user != null && user.address != null) ? user.address : "";
Phone_Number = (user != null && user.phone != null) ? user.phone : "";
Mobile = (user != null && user.mobile != null) ? user.mobile : "";
}
else if (shop.shopmanager_id != null)
{
login login = db.logins.SingleOrDefault(a => a.id == shop.shopmanager_id);
admin_user user = login.admin_users[0];
Address = (user != null && user.address != null) ? user.address : "";
Phone_Number = (user != null && user.phone != null) ? user.phone : "";
Mobile = (user != null && user.mobile != null) ? user.mobile : "";
}
}
catch (Exception)
{
Address = "";
Phone_Number = "";
Mobile = "";
}
}
public admin_user find_admin_user_By_ID(int id)
{
try
{
admin_user = db.admin_users.SingleOrDefault(a => a.id == id);
return(admin_user);
}
catch (Exception)
{
return(null);
}
}
public admin_user find_admin_user_By_AppId(string Appid)
{
try
{
admin_user = db.admin_users.SingleOrDefault(a => a.app_id == Appid);
return(admin_user);
}
catch (Exception)
{
return(null);
}
}
public string editUser(admin_user user)
{
QCTESTEntities QC_DB = new QCTESTEntities();
var u = QC_DB.admin_user.First(t => t.ID == user.ID);
u.Name = user.Name;
u.Permission = user.Permission;
u.Type = user.Type;
QC_DB.SaveChanges();
return("");
}
public admin_user delete_admin_user()
{
try
{
admin_user prev_admin_user = db.admin_users.SingleOrDefault(a => a.id == admin_user.id);
db.admin_users.DeleteOnSubmit(prev_admin_user);
return(admin_user);
}
catch (Exception)
{
return(null);
}
}
public bool initialisebonusparams(shop shop, string message, decimal bonus, decimal newbalance)
{
try
{
if (shop.agent != null)
{
user = new CRUD.admin_users_crud().find_admin_user_By_ID(shop.agent.Value);
}
else if (shop.shopmanager_id != null)
{
int shopmanager = shop.shopmanager_id.Value;
login login = new CRUD.logins_crud().find_login_By_ID(shopmanager);
user = new CRUD.admin_users_crud().find_admin_user_By_ID(login.admin_users[0].id);
}
else
{
user = new admin_user();
}
if (user.phone != null && user.phone != "" && user.phone.Count() > 0)
{
if (message.Contains("{shop_code}"))
{
string shopstring = message;
shopstring = shop.shop_code + " ";
message = message.Replace("{shop_code}", shopstring);
}
if (message.Contains("{bonus}"))
{
message = message.Replace("{bonus}", bonus.ToString());
}
if (message.Contains("{prevbal}"))
{
message = message.Replace("{prevbal}", (newbalance - bonus).ToString());
}
if (message.Contains("{new_balance}"))
{
message = message.Replace("{new_balance}", newbalance.ToString());
}
messages = message;
}
}
catch (Exception)
{
}
return(true);
}
public customer(shop shop)
{
admin_user user = new admin_user();
try
{
if (shop.agent != null)
{
//agent
user = new CRUD.admin_users_crud().find_admin_user_By_ID(shop.agent.Value);
}
else if (shop.shopmanager_id != null)
{
user = shop.login.admin_users[0];
}
else
{
status = 1;
}
if (user != null)
{
this.user = user;
this.shop = shop;
firstname = user.firstname;
middlename = user.lastname;
lastname = user.middlename;
email = user.email;
phone = user.phone;
statusMessage = "Customer is Valid";
status = 0;
reference = shop.id;
customerAletrnateReference = shop.shop_code;
customerReferenceDescription = user.account_name;
}
else
{
status = 1;
}
}
catch (Exception ex)
{
//user = null;
status = 1;
}
}
public int addUser(admin_user user)
{
QCTESTEntities QC_DB = new QCTESTEntities();
admin_user tmp = new admin_user();
tmp.Username = user.Username;
tmp.Type = user.Type;
tmp.Permission = user.Permission;
tmp.Name = user.Name;
tmp.GreatDate = DateTime.Now;
tmp.Password = "******";
QC_DB.admin_user.Add(tmp);
QC_DB.SaveChanges();
return(tmp.ID);
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
QCTESTEntities QC_DB = new QCTESTEntities();
var ss = QC_DB.admin_user.FirstOrDefault(t => t.Username == model.UserName);
if (ss != null)
{
ModelState.AddModelError("", "用户名已存在");
return(View(model));
}
admin_user tmp = new admin_user();
tmp.Username = model.UserName;
tmp.Type = null;//游客
tmp.Name = model.Name == null ? model.UserName : model.Name;
tmp.GreatDate = DateTime.Now;
tmp.Password = model.Password;
tmp.Permission = "";
QC_DB.admin_user.Add(tmp);
//私有项目
var newP = new project();
newP.Pname = "private project";
newP.userID = tmp.ID;
QC_DB.project.Add(newP);
//私有框架
var newF = new caseFramework();
newF.workName = "你的框架";
newF.userID = tmp.ID;
newF.controlXML = new XElement("Steps").ToString();
QC_DB.caseFramework.Add(newF);
QC_DB.SaveChanges();
return(RedirectToAction("Login", "User"));
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return(View(model));
}
public admin_user alter_admin_user()
{
try
{
admin_user prev_admin_user = db.admin_users.SingleOrDefault(a => a.id == admin_user.id);
prev_admin_user.accountNo = admin_user.accountNo;
prev_admin_user.address = admin_user.address;
prev_admin_user.Bank = admin_user.Bank;
prev_admin_user.bbm_pin = admin_user.bbm_pin;
prev_admin_user.default_credit_limit = admin_user.default_credit_limit;
prev_admin_user.email = admin_user.email;
prev_admin_user.firstname = admin_user.firstname;
prev_admin_user.isactive = admin_user.isactive;
prev_admin_user.join_date = admin_user.join_date;
prev_admin_user.lastname = admin_user.lastname;
prev_admin_user.middlename = admin_user.middlename;
prev_admin_user.mobile = admin_user.mobile;
prev_admin_user.name_title = admin_user.name_title;
prev_admin_user.num_of_shops = admin_user.num_of_shops;
prev_admin_user.phone = admin_user.phone;
prev_admin_user.photopath = admin_user.photopath;
prev_admin_user.sex = admin_user.sex;
prev_admin_user.skype = admin_user.skype;
prev_admin_user.account_name = admin_user.account_name;
if (admin_user.login1 != null)
{
if (admin_user.login1.password != null)
{
prev_admin_user.login1.password = Utilities.MD5Encript.MD5Hash(admin_user.login1.password);
}
prev_admin_user.login1.role = admin_user.login1.role;
}
db.SubmitChanges();
return(admin_user);
}
catch (Exception)
{
return(null);
}
}
public creditlimit(shop shop, decimal currentbalanace)
{
int agentId = shop.agent.Value;
admin_user user = db.admin_users.SingleOrDefault(a => a.id == agentId);
shop_ = shop.shop_code;
currentbalance_ = currentbalanace;
creditlimit_ = shop.credit_limit.Value;
creditdeficit_ = currentbalance_ - creditlimit_;
phoneNumber_ = ((user.phone != null) ? user.phone : "") + ((user.mobile != null) ? "/" + user.mobile : "");
if (creditdeficit_ > 10000)
{
Remark = "BLOCK";
}
else
{
Remark = "CREDIT CONTROLLER ";
}
}
public bonusSaver(List <bonushelper> bonuses, transaction_category bonustransaction, DateTime fromdate, DateTime todate, admin_user user)
{
this.bonuses = bonuses;
this.bonustransaction = bonustransaction;
this.fromdate = fromdate;
this.todate = todate;
this.user = user;
List <int> shopsIds = bonuses.Select(a => a.shop.id).ToList <int>();
this.shopDebtsToUpdate = db.debts.Where(a => shopsIds.Contains(a.shop)).ToList <debt>();
this.ShopBalancesToUpdate = db.master_balance_sheets.Where(a => shopsIds.Contains(a.shop.Value)).ToList <master_balance_sheet>();
this.transactionsToSave = new List <master_transaction>();
this.debtTransactionToSave = new List <debt_transaction>();
ComputeBonuses();
SaveTransactions();
SendSms();
transtate = true;
}
public List <WgbSalesUpload.debt> getAllAgentdebts(admin_user user, List <debt> debts)
{
try
{
if (debts == null)
{
debts = db.debts.ToList <debt>();
}
List <debt> agentdebts = new List <debt>();
List <shop> shops = db.shops.Where(a => a.agent == user.id).ToList <shop>();
foreach (shop shop in shops)
{
agentdebts.AddRange(getAllShopdebts(shop, debts));
}
return(agentdebts);
}
catch (Exception)
{
return(debts);
}
}
public string fillDataToList(RadGrid r1, RadGrid r2, RadGrid r3)
{
if (dtExcelRecords == null)
{
return("Error : No Data to Process");
}
else
{
List <login> names = db.logins.ToList <login>();
List <login> errornames = new List <login>();
List <shop> shops = db.shops.ToList <shop>();;
List <shop> errorshops = new List <shop>();;
List <admin_user> users = db.admin_users.ToList <admin_user>();
List <admin_user> errorusers = new List <admin_user>();
admin_user user = null; shop shop = null;
login login = null;
shop_crud shophelper = new shop_crud();
//shop shoped;
foreach (DataRow row in dtExcelRecords.Rows)
{
int rowindex = dtExcelRecords.Rows.IndexOf(row);
// if (dtExcelRecords.Rows.IndexOf(row) == 0)
// continue;
if (dtExcelRecords.Rows.IndexOf(row) == dtExcelRecords.Rows.Count - 1)
{
break;
}
var values = row.ItemArray;
string[] data = ((string)values[1]).Split('/');
if (data.Length > 2)
{
string state_string = data[0];
string shop_string = data[1];
string shop_type_string = data[2];
if (state_string != null && shop_string != null && shop_type_string != null)
{
if (shop_type_string.Contains("AG"))
{
try
{
login = names.SingleOrDefault(b => b.username == shop_string);
if (login != null)
{
user = login.admin_users[0];
}
else
{
login = new login();
login.role = 3;
login.username = shop_string;
login.password = Utilities.MD5Encript.MD5Hash("changeme");
login.App_id = Application(db).app_id;
user = new admin_user {
firstname = shop_string, middlename = "AGENCY", login1 = login
};
user.app_id = Application(db).app_id;
names.Add(login);
db.logins.InsertOnSubmit(login);
user.login = login.id;
db.admin_users.InsertOnSubmit(user);
db.SubmitChanges();
users.Add(user);
}
if (shops.SingleOrDefault(a => a.shop_code == ((string)values[1])) == null)
{
shop = new shop
{
shop_code = (string)values[1],
isactive = true,
is_bettingshop = true,
state = db.state_lists.SingleOrDefault(a => a.code == state_string).id,
shop_ownership = "AGENT",
is_onlinefunding = false,
shop_name = shop_string + " SHOP " + shop_type_string.Substring(shop_type_string.Length - 1, 1)
};
shop.app_id = Application(db).app_id;
shop.agent = user.id;
db.shops.InsertOnSubmit(shop);
db.SubmitChanges();
shops.Add(shop);
}
}
catch (Exception)
{
errorshops.Add(shop);
errorusers.Add(user);
errornames.Add(login);
}
}
else
{//insert hubs
try
{
login = names.SingleOrDefault(b => b.username == shop_string);
if (login != null)
{
user = login.admin_users[0];
}
else
{
login = new login();
login.role = 2;
login.username = shop_string;
login.password = Utilities.MD5Encript.MD5Hash("changeme");
login.App_id = Application(db).app_id;
names.Add(login);
user = new admin_user {
firstname = shop_string, middlename = "MANAGER", login1 = login, num_of_shops = 1
};
user.app_id = Application(db).app_id;
db.logins.InsertOnSubmit(login);
user.login = login.id;
db.admin_users.InsertOnSubmit(user);
db.SubmitChanges();
users.Add(user);
}
if (shops.SingleOrDefault(a => a.shop_code == ((string)values[1])) == null)
{
shop = new shop
{
shop_code = (string)values[1],
isactive = true,
is_bettingshop = true,
state = db.state_lists.SingleOrDefault(a => a.code == state_string).id,
shop_ownership = "WGB",
is_onlinefunding = false,
};
if (shop_type_string.Contains("H"))
{
shop.shop_type = 1;
shop.shop_name = shop_string + " HUB";
}
else if (shop_type_string.Contains("BS"))
{
shop.shop_type = 2;
shop.shop_name = shop_string + " BIG SHOP";
}
else
{
shop.shop_type = 3;
shop.shop_name = shop_string + " REGULAR SHOP";
}
shop.app_id = Application(db).app_id;
shop.shopmanager_id = login.id;
db.shops.InsertOnSubmit(shop);
db.SubmitChanges();
shops.Add(shop);
}
}
catch (Exception)
{
errorshops.Add(shop);
errorusers.Add(user);
errornames.Add(login);
}
}
//remain shopmanager id
}
}
r1.DataSource = errornames;
r2.DataSource = errorshops;
r3.DataSource = errorusers;
r1.DataBind(); r2.DataBind(); r3.DataBind();
}
return("File processed Sucessfully");
}
}
public bool initializeParameters(shop shop, string message, object date)
{
try
{
if (shop.agent != null)
{
user = new CRUD.admin_users_crud().find_admin_user_By_ID(shop.agent.Value);
}
else if (shop.shopmanager_id != null)
{
int shopmanager = shop.shopmanager_id.Value;
login login = new CRUD.logins_crud().find_login_By_ID(shopmanager);
user = new CRUD.admin_users_crud().find_admin_user_By_ID(login.admin_users[0].id);
}
else
{
user = new admin_user();
}
if (user.phone != null && user.phone != "" && user.phone.Count() > 0)
{
if (message.Contains("{shop_code}"))
{
string shopstring = message;
shopstring = " " + shop.shop_code + " ";
message = message.Replace("{shop_code}", shopstring);
}
if (message.Contains("{shop_id}"))
{
string shopstring = message;
shopstring = shop.id + " ";
message = message.Replace("{shop_id}", shopstring);
}
if (message.Contains("{debt_analysis}"))
{
List <debt> debts = db.debts.Where(a => a.shop == shop.id && a.status == true).ToList <debt>();
if (debts.Count > 0)
{
string debtstring = "";
foreach (debt debt in debts)
{
debtstring += debt.debt_type1.name + " DEBT : " + "NGN" + debt.current_amount.Value.ToString("#,0.00") + " \r\n ";
}
message = message.Replace("{debt_analysis}", debtstring);
}
}
if (message.Contains("{date}"))
{
string datestring = "";
if (date == null)
{
datestring = DateTime.Now.ToShortDateString();
}
else
{
datestring = ((DateTime)date).ToShortDateString();
}
message = message.Replace("{date}", datestring);
}
if (message.Contains("{curr_date}"))
{
string datestring = "";
datestring = DateTime.Now.ToShortDateString();
message = message.Replace("{curr_date}", datestring + " ");
}
if (message.Contains("{sales_analysis}"))
{
string salesanalysisstring = "";
salesanalysisstring = shop.shop_code + " NGN" + shop.master_balance_sheets[0].sales_balance.Value.ToString("#,0.00");
message = message.Replace("{sales_analysis}", salesanalysisstring);
}
if (message.Contains("{sales_bal}"))
{
string salesbalstring = "";
salesbalstring = "NGN" + shop.master_balance_sheets[0].sales_balance.Value.ToString("#,0.00");
message = message.Replace("{sales_bal}", salesbalstring);
}
if (message.Contains("{message}"))
{
string messagestring = message;
initializeParameters(shop, messagestring, date);
message = message.Replace("{message}", messagestring);
}
if (message.Contains("{bank_details}"))
{
string bankdetstring = message;
if (user.bank_list != null)
{
bankdetstring = user.bank_list.code + "(" + user.accountNo + ")";
}
else
{
bankdetstring = "";
}
message = message.Replace("{bank_details}", bankdetstring);
}
messages = message;
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public List <admin_user> fillDataToList()
{
if (dtExcelRecords == null)
{
return(null);
}
else
{
List <admin_user> userList = new List <admin_user>();
//sho shophelper = new shop_crud();
//shop shoped;
foreach (DataRow row in dtExcelRecords.Rows)
{
int rowindex = dtExcelRecords.Rows.IndexOf(row);
//if (dtExcelRecords.Rows.IndexOf(row) == 0)
// continue;
//if (dtExcelRecords.Rows.IndexOf(row) == dtExcelRecords.Rows.Count - 1)
// break;
//
var values = row.ItemArray;
shop shop = db.shops.SingleOrDefault(a => a.shop_code == values[4].ToString());
if (shop != null && userList.Where(a => a.id == shop.agent).Count() < 1)//&& values[5].ToString().Length>9)
{
admin_user user = db.admin_users.SingleOrDefault(a => a.id == shop.agent);
user.address = values[2] != null ? values[2].ToString() : "";
try
{
string[] data = ((string)values[1]).Replace('.', ' ').Split(' ');
string fname = null, lname = null, mname = null;// = data[0];
if (values[5] != null && values[5].ToString().Count() > 0)
{
user.accountNo = String.Format("{0:0000000000}", values[5]);
if (values[6] != null && values[6].ToString().Count() > 0)
{
user.Bank = db.bank_lists.SingleOrDefault(a => a.code == values[6].ToString().Trim()).id;
}
}
mname = data[0];
fname = data[1];
if (data.Length > 2)
{
lname = data[2];
}
if (values[7] != null && values[7].ToString().Count() > 0)
{
user.account_name = values[7].ToString();
}
else
{
user.account_name = (string)values[1].ToString();
}
user.firstname = fname;
user.middlename = mname;
user.lastname = (lname != null ? lname : "AGENCY");
if (values[8] != null && values[8].ToString().Count() > 0)
{
string[] phn = ((string)values[8]).Split('/');
if (phn.Length > 0)
{
user.phone = phn[0];
}
if (phn.Length > 1)
{
user.mobile = phn[1];
}
}
userList.Add(user);
}
catch (Exception ex)
{
errorlist_.Add(user);
}
}
}
list_ = userList;
return(userList);
}
}
public void SaveTransaction(bonushelper bhelp, transaction_category bonustransaction, admin_user user)
{
master_balance_sheet sendbal;
transaction_category sendtran;
try
{
using (TransactionScope scope = new TransactionScope())
{
master_balance_sheet bal = db.master_balance_sheets.SingleOrDefault(a => a.shop == bhelp.shop.id);
master_transaction transaction = new master_transaction
{
amount = bhelp.Bonus,
app_id = Application().app_id,
balance_after = getbal(bal.sales_balance, bhelp.Bonus, bonustransaction),
balance_before = bal.sales_balance,
description = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(),
details = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(),
posted_by = user.id,
shop = bhelp.shop.id,
trans_category = bonustransaction.id,
trans_timestamp = DateTime.Now,
trans_type = (bonustransaction.type == true) ? 0 : 1,
};
db.master_transactions.InsertOnSubmit(transaction);
master_balance_sheet prevbal = db.master_balance_sheets.SingleOrDefault(a => a.shop == bhelp.shop.id);
prevbal.sales_balance = getbal(bal.sales_balance, bhelp.Bonus, bonustransaction);
prevbal.netbalance = getbal(bal.netbalance, bhelp.Bonus, bonustransaction);
sendbal = prevbal;
sendtran = bonustransaction;
db.SubmitChanges();
scope.Complete();
}
SendSms(bhelp, sendbal, sendtran);
}
catch (Exception)
{
}
}
public string SaveBonusTransaction(List <bonushelper> bonus, transaction_category bonustransaction, DateTime fromdate, DateTime todate, admin_user user)
{
this.fromdate = fromdate;
this.todate = todate;
int completed = 0;
int failed = 0;
// Thread workerSms;
//AutoSendSMS("234" + user.phone.Substring(1, user.phone.Length-1));
foreach (bonushelper bhelp in bonus)
{
if (bhelp.Bonus > 0)
{
try
{
//workerSms = new Thread(() => SaveTransaction(bhelp, bonustransaction, user));
//workerSms.Start();
//completed++;
SaveTransaction(bhelp, bonustransaction, user);
completed++;
}
catch (Exception)
{
failed++;
}
}
}
return("Completed " + completed + " Failed " + failed);
}
public admin_users_crud(admin_user admin_user_)
{
this.admin_user_ = admin_user_;
}
public AdminUserRenderer(admin_user user)
{
this.id = user.id;
this.name = ((user.firstname != null)?user.firstname.ToUpperInvariant():"") + " " + ((user.middlename != null) ? user.middlename.ToUpperInvariant() : "") + " " + ((user.lastname != null)?user.lastname.ToUpperInvariant():"");
this.user_ = user;
}
