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