public List <master_sb_sale> fillSBDataToList(DateTime date) { List <shop> shops = new CRUD.shop_crud().getallShop().ToList <shop>(); if (dtExcelRecords == null) { return(null); } else { List <master_sb_sale> sales = new List <master_sb_sale>(); 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; master_sb_sale sale; string excelshopcode = (string)values[1]; shop shoped = shops.SingleOrDefault(a => a.shop_code == excelshopcode);// new shop_crud().find_shop_By_Code((string)values[1]) != null ? shophelper.find_shop_By_Code((string)values[1]) : new shop {id=-1, shop_code=(string) values[1]}; try { sale = new master_sb_sale { // shop1 = (shop_ != null) ? shop_ : null, //((shophelper.find_shop_By_Code((string)values[1])) != null) ? shophelper.find_shop_By_Code((string)values[1]) : null, //(string)values[1]) != null) ? shophelper.find_shop_By_Code((string)values[1]) : null, shop1 = (shoped != null) ? shoped : new shop { shop_code = values[1].ToString(), app_id = values[1].ToString() }, // shop = shoped.id,//shoped.id, //app_id = values[1].ToString(),//temp string used to display shop in list view date = date, stake = Decimal.Parse(values[5].ToString()), winnings = Decimal.Parse(values[7].ToString()), cancelled = Decimal.Parse(values[10].ToString()), single_stake_sales = Decimal.Parse(values[16].ToString()), isverified = false, islocked = false, date_posted = DateTime.Today, }; // sale.shop1 = ((shophelper.find_shop_By_Code((string)values[1])) != null) ? shophelper.find_shop_By_Code((string)values[1]) : null; sale.sales = Decimal.Subtract((Decimal)sale.stake, (Decimal)sale.cancelled); sale.balance = Decimal.Subtract((Decimal)sale.sales, (Decimal)sale.winnings); sale.other_stake_commision = Decimal.Multiply((Decimal)(sale.sales - sale.single_stake_sales), (shoped.commission != null) ? shoped.commission.Value / 100 : Utilities.COMMISSION.COMMISSION_CONSTANT / 100); sale.single_stake_commision = Decimal.Multiply((Decimal)sale.single_stake_sales, Utilities.COMMISSION.SINGLE_COMMISION_CONSTANT / 100); sale.commision = sale.single_stake_commision + sale.other_stake_commision; //sale.commision = Decimal.Multiply((Decimal)sale.sales, (shoped.commission != null) ? shoped.commission.Value / 100 : Utilities.COMMISSION.COMMISSION_CONSTANT / 100); sale.net_balance = Decimal.Subtract((Decimal)sale.balance, (Decimal)sale.commision); sale.single_stake_percent = sale.sales != 0 ? (sale.single_stake_sales / sale.sales) * 100 : 0; // sale = new master_sb_sales_crud(sale).insert_master_sb_sale(); if (sale == null) { sale = new master_sb_sale(); } sales.Add(sale); // sale = new master_sb_sales_crud(sale).insert_master_sb_sale(); } catch (Exception) { sale = new master_sb_sale(); // sale.shop1 = new shop { shop_code = values[1].ToString(), app_id = values[1].ToString() }; sale.app_id = values[1].ToString(); sales.Add(sale); } } return(sales); } }
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"); } }