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; }