public StoreInformation(StoreHost host)
{
this.PrinterIP = host.PrinterIP;
this.RouterIP = host.RouterIP;
this.LaptopIP1 = host.LaptopIP1;
this.LaptopIP2 = host.LaptopIP2;
this.FingerIP = host.FingerIP;
this.FlowIP = host.FlowIP;
}
public StoreInformation(StoreHost host)
{
this.PrinterIP = host.PrinterIP;
this.RouterIP = host.RouterIP;
this.LaptopIP1 = host.LaptopIP1;
this.LaptopIP2 = host.LaptopIP2;
this.FingerIP = host.FingerIP;
this.FlowIP = host.FlowIP;
}
public static StoreHost GetStoreHost(string storeNo)
{
StoreHost host = new StoreHost();
string url = "http://10.1" + storeNo.Substring(0, 2) + "." + Convert.ToInt32(storeNo.Substring(2, 2)).ToString();
host.Url = url + ".100";
host.PrinterIP = host.Url.Substring(7);
host.RouterIP = (url + ".1").Substring(7);
host.LaptopIP1 = (url + ".40").Substring(7) + ";" + (url + ".41").Substring(7);
host.LaptopIP2 = (url + ".50").Substring(7) + ";" + (url + ".51").Substring(7);
host.FingerIP = (url + ".140").Substring(7);
host.FlowIP = (url + ".120").Substring(7);
return(host);
}
public static void InsertStoreInformationTemp()
{
DataSet ds = SqlHelper.GetOpeningStores();
List <StoreInformation> list = new List <StoreInformation>();
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
string storeNo = ds.Tables[0].Rows[i][0].ToString();
StoreHost host = Common.GetStoreHost(storeNo);
StoreInformation store = new StoreInformation(host);
store.StoreNo = storeNo;
store.StoreRegion = ds.Tables[0].Rows[i][1].ToString();
store.StoreType = ds.Tables[0].Rows[i][2].ToString();
list.Add(store);
}
string[] clist = { "storeNo", "storeRegion", "storeType", "printerIP", "routerIP", "laptopIP1", "laptopIP2", "fingerIP", "flowIP", "emailAddress", "printerType", "tonerType", "routerType" };
DataTable dt = new DataTable();
foreach (string colname in clist)
{
dt.Columns.Add(colname);
}
int rowcount = list.Count;
for (int i = 0; i < rowcount; i++)
{
DataRow row = dt.NewRow();
row["storeNo"] = list[i].StoreNo;
row["storeRegion"] = list[i].StoreRegion;
row["storeType"] = list[i].StoreType;
row["printerIP"] = list[i].PrinterIP;
row["routerIP"] = list[i].RouterIP;
row["laptopIP1"] = list[i].LaptopIP1;
row["laptopIP2"] = list[i].LaptopIP2;
row["fingerIP"] = list[i].FingerIP;
row["flowIP"] = list[i].FlowIP;
row["emailAddress"] = list[i].StoreNo + "*****@*****.**"; // [email protected]
row["printerType"] = null;
row["tonerType"] = null;
row["routerType"] = null;
dt.Rows.Add(row);
}
SqlHelper.TruncateStoreInformationTemp();
SqlHelper.CommonBulkInsert(dt, "StoreInformationTemp");
}
public static StoreHost GetStoreHost(string storeNo)
{
StoreHost host = new StoreHost();
string url = "http://10.1" + storeNo.Substring(0, 2) + "." + Convert.ToInt32(storeNo.Substring(2, 2)).ToString();
host.Url = url + ".100";
host.PrinterIP = host.Url.Substring(7);
host.RouterIP = (url + ".1").Substring(7);
host.LaptopIP1 = (url + ".40").Substring(7) + ";" + (url + ".41").Substring(7);
host.LaptopIP2 = (url + ".50").Substring(7) + ";" + (url + ".51").Substring(7);
host.FingerIP = (url + ".140").Substring(7);
host.FlowIP = (url + ".120").Substring(7);
return host;
}
