public void NewMobileAndMerc(string[] merchantData, string DNETS, string DElavon, string status, string address, string simnr, string note, string MACAddress, string BoxName, string[] CrD, string[] ClD) { UpdateInternalLists(); bool BDNETS = false; bool BDElavon = false; bool Bstatus = true; Date CrDate = ConvertToDate(CrD); Date ClDate = ConvertToDate(ClD); Merchant merchant = new Merchant(merchantData[0], merchantData[1], merchantData[2], merchantData[3], merchantData[4]); if (DNETS == "Forsinket") { BDNETS = true; } if (DElavon == "Forsinket") { BDElavon = true; } if (status != "Aktiv") { Bstatus = false; } Mobilesystem mobile = new Mobilesystem(merchant, CrDate, address, simnr, MACAddress, BoxName, Bstatus, BDElavon, BDNETS, note, ClDate); mobilesystems.Add(mobile); merchants.Add(merchant); repo.GetMobileLists(mobilesystems); repo.GetMercLists(merchants); }
public string GetProOriginal(string tprice, string currencymobile) { string strBestSell = ""; try { DataTable table = new DataTable(); ProductMainPage_data ds = new Mobilesystem().MobileforShow("Select top 6 * from v_web_mobile_show_all where type=3 order by Sellingprice"); table = ds.Tables[0]; int num = table.Rows.Count; string id = ""; string name = ""; string price = ""; string img = ""; float rate = (float)Application["ratepromobi"]; float price1 = 1; for (int i = 0; i < num; i++) { id = table.Rows[i][ProductMainPage_data._id].ToString(); name = table.Rows[i][ProductMainPage_data._name].ToString() + " " + table.Rows[i][ProductMainPage_data._state].ToString();; //price = table.Rows[i][ProductMainPage_data._price].ToString(); price1 = float.Parse(table.Rows[i][ProductMainPage_data._price].ToString()); price1 = price1 * rate; price = price1.ToString("N").Split('.')[0]; if (price.Equals("0")) { price = "-"; } img = table.Rows[i][ProductMainPage_data._urlImage].ToString(); if (img.Length > 0) { img = "image/img_pro/" + img; } else { img = "image/common/notimgpro.png"; } strBestSell += "<tr><td width='65'>"; strBestSell += "<a href='?menu=dp&id=" + id + "'><img src='" + img + "' class='img4' /></a></td><td>"; strBestSell += "<a href='?menu=dp&id=" + id + "'>" + name + "</a><br />"; strBestSell += "<span class='txt4'>" + price + " " + currencymobile + "</span></td></tr>"; if (i + 1 < num) { strBestSell += "<tr><td colspan='2' class='line1'></td></tr>"; } } } catch (Exception ex) { Console.Write(ex.ToString()); } return(strBestSell); }
private void GetProductMainPage() { try { DataSet ds = new Mobilesystem().MobileMainpage(); DataTable table = ds.Tables[0]; int numPro = table.Rows.Count; if (numPro > 0) { GetJustHave(ds.Tables[1]); GetBestView(ds.Tables[2]); //currentAccess += GetListMessage(ds.Tables[3]); //currentAccess = "<marquee scrolldelay='120' width='580' onmouseout='start();' onmouseover='stop();'>" + currentAccess + ", " + currentAccess + "</marquee>"; strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%' bgcolor='#FFFFFF'>"; strProMain += "<tr><td width='25%'></td><td width='25%'></td><td width='25%'></td><td width='25%'></td></tr>"; string id = ""; string name = ""; string url = ""; string price = ""; string warranty = ""; float rate = (float)Application["ratepromain"]; float price1 = 1; string madein = ""; string isSpec = ""; int count = 0; for (int i = 0; i < numPro; i++) { count++; id = table.Rows[i][ProductMainPage_data._id].ToString(); name = table.Rows[i][ProductMainPage_data._name].ToString() + " " + table.Rows[i][ProductMainPage_data._state].ToString(); url = table.Rows[i][ProductMainPage_data._urlImage].ToString(); if (url.Length > 0) { url = "image/img_pro/" + url; } else { url = "image/common/notimgpro.png"; } price1 = float.Parse(table.Rows[i][ProductMainPage_data._price].ToString()); price1 = price1 * rate; price = price1.ToString("N").Split('.')[0]; warranty = table.Rows[i][ProductMainPage_data._WarrantyMonth].ToString(); madein = table.Rows[i][ProductMainPage_data._shortnote].ToString(); isSpec = table.Rows[i][ProductMainPage_data._isspec].ToString(); if (count == 1) { strProMain += "<tr align='center' class='txt2' valign='top'>"; } strProMain += "<td>"; strProMain += "<a href='?menu=dp&id=" + id + "'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a><span class='txt5'>" + (i + 1) + "</span> <br />"; strProMain += "<span class='txt4'>"; if (price.Equals("0")) { strProMain += tupdate + "</span><br />"; } else { strProMain += price + " " + unitPrice + "</span><br />"; } //strProMain += twarranty + ": <span class='txt4'>" + warranty + " " + tmonth + "</span><br />"; strProMain += "<a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a><br />"; if (table.Rows[i][ProductMainPage_data._ispromotion].ToString().Length > 0) { strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />"; } strProMain += "</td>"; if (count == 4) { strProMain += "</tr>"; if (i + 1 < numPro) { strProMain += "<tr><td colspan='4' class='line1'></td></tr>"; } count = 0; } else { if (i + 1 == numPro) { strProMain += "</tr>"; } } } strProMain += "</table>"; } } catch (Exception ex) { Console.Write(ex.ToString()); strProMain = ""; } }
protected void Page_Load(object sender, EventArgs e) { try { string menu = Request.QueryString["menu"].ToString(); string strmobile = ""; switch (menu) { case ("imgpro"): { try { string id = Request.QueryString["id"].ToString(); string name = Request.QueryString["name"].ToString(); string namepro = Request.QueryString["namepro"].ToString(); string subName = ""; int leng = namepro.Length; for (int i = 0; i < leng; i++) { if (namepro[i].Equals('(')) { break; } if (!namepro[i].Equals(',')) { subName += namepro[i]; } } subName = subName.Trim(); Session["SSIdProUpload"] = id + "," + name + "," + subName; } catch { } Response.Write("ok"); break; } case ("bestsell"): { string strreturn = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); ProductBestSellSystem products = new ProductBestSellSystem(); Boolean test = products.ProductBestUpdate(int.Parse(id), int.Parse(type)); if (!test) { strreturn = "err"; } else { //ProductMainPage_data ds = new ProductBestSellSystem().ProductBestSellAll(); //Application["appProductBestsell"] = ds.Tables[ProductMainPage_data._table]; } } catch { strreturn = "err"; } Response.Write(strreturn); } break; case ("justhave"): { string strreturn = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); ProductBestSellSystem products = new ProductBestSellSystem(); Boolean test = products.ProductJustHaveUpdate(int.Parse(id), int.Parse(type)); if (!test) { strreturn = "err"; } else { //ProductMainPage_data ds = new ProductBestSellSystem().ProductBestSellAll(); //Application["appProductBestsell"] = ds.Tables[ProductMainPage_data._table]; } } catch { strreturn = "err"; } Response.Write(strreturn); } break; //prepare out: case ("prepareout"): { string PrepareStr = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); ProductBestSellSystem products = new ProductBestSellSystem(); Boolean test = products.ProductPrepareoutUpdate(int.Parse(id), int.Parse(type)); if (!test) { PrepareStr = "err"; } else { //ProductMainPage_data ds = new ProductBestSellSystem().ProductBestSellAll(); //Application["appProductBestsell"] = ds.Tables[ProductMainPage_data._table]; } } catch { PrepareStr = "err"; } Response.Write(PrepareStr); } break; //proselloff: case ("proselloff"): { string strselloff = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); float price = float.Parse(Request.QueryString["price"].ToString()); ProductBestSellSystem products = new ProductBestSellSystem(); Boolean test = products.ProductSelloffUpdate(int.Parse(id), int.Parse(type), price); if (!test) { strselloff = "err"; } else { //ProductMainPage_data ds = new ProductBestSellSystem().ProductBestSellAll(); //Application["appProductBestsell"] = ds.Tables[ProductMainPage_data._table]; } } catch { strselloff = "err"; } Response.Write(strselloff); } break; case ("mainpage"): string strmain = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); string sort = Request.QueryString["sort"].ToString(); ProductMainPageSystem products = new ProductMainPageSystem(); Boolean test = products.ProductMainpageUpdate(int.Parse(id), int.Parse(type), int.Parse(sort)); if (!test) { strmain = "err"; } } catch { strmain = "err"; } Response.Write(strmain); break; case ("original"): string stroriginal = ""; try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); string sort = Request.QueryString["sort"].ToString(); ProductMainPageSystem products = new ProductMainPageSystem(); Boolean test = products.ProductOriginalUpdate(int.Parse(id), int.Parse(type), int.Parse(sort)); if (!test) { stroriginal = "err"; } } catch { strmain = "err"; } Response.Write(stroriginal); break; case ("dgroup"): string strdelete = ""; try { string id = Request.QueryString["id"].ToString(); ArticleManagerSystem Articles = new ArticleManagerSystem(); if (Articles.AdminGroupDeleteId(id)) { strdelete = "1"; } else { strdelete = "0"; } }catch { strdelete = "0"; } Response.Write(strdelete); break; case ("dgcontact"): string strdcontact = ""; try { string id = Request.QueryString["id"].ToString(); ContacstSystem Contacts = new ContacstSystem(); if (Contacts.GroupContactDeleteId(id)) { strdcontact = "1"; } else { strdcontact = "0"; } } catch { strdcontact = "0"; } Response.Write(strdcontact); break; case ("dglocation"): string strdlocation = ""; try { string id = Request.QueryString["id"].ToString(); ContacstSystem Contacts = new ContacstSystem(); if (Contacts.LocationContactDelete(id)) { strdlocation = "1"; } else { strdlocation = "0"; } } catch { strdlocation = "0"; } Response.Write(strdlocation); break; case ("dhelp"): string strdhelp = "0"; try { string id = Request.QueryString["id"].ToString(); HelpsSystem helps = new HelpsSystem(); if (helps.HelpsDelete(id)) { strdhelp = "1"; } } catch { strdhelp = "0"; } Response.Write(strdhelp); break; case ("donline"): string stronline = "0"; try { string id = Request.QueryString["id"].ToString(); SupportOnlineSystem Support = new SupportOnlineSystem(); if (Support.OnlineDelete(id)) { stronline = "1"; Application["appOnline"] = null; } } catch { stronline = "0"; } Response.Write(stronline); break; case ("dadvertise"): string strdadvertise = "0"; try { string id = Request.QueryString["id"].ToString(); AdvertiseSystem advertise = new AdvertiseSystem(); DataSet ds = advertise.AdvertiseSelectId(id); if (ds.Tables[0].Rows.Count > 0) { string url1 = ds.Tables[0].Rows[0]["urlimage"].ToString(); string path = Server.MapPath("../image/advertise/"); CvalidateImageForPost manageImage = new CvalidateImageForPost(); if (url1.Length > 0) { manageImage.DeleteFile(path + url1); } } if (advertise.AdvertiseDelete(id)) { strdadvertise = "1"; Application["appAdvertiset"] = null; } } catch { strdadvertise = "0"; } Response.Write(strdadvertise); break; case ("dadvertisespecial"): string strspecial = "0"; try { string id = Request.QueryString["id"].ToString(); AdvertiseSystem advertise = new AdvertiseSystem(); DataSet ds = advertise.SpecialSelectId(int.Parse(id)); if (ds.Tables[0].Rows.Count > 0) { string url1 = ds.Tables[0].Rows[0]["urlimage1"].ToString(); string url2 = ds.Tables[0].Rows[0]["urlimage2"].ToString(); string path = Server.MapPath("../image/advertise/"); CvalidateImageForPost manageImage = new CvalidateImageForPost(); if (url1.Length > 0) { manageImage.DeleteFile(path + url1); } if (url2.Length > 0) { manageImage.DeleteFile(path + url2); } } if (advertise.SpecialDelete(id)) { strspecial = "1"; } } catch { strspecial = "0"; } Response.Write(strspecial); break; case "darticle": string strdarticle = "0"; try { string id = Request.QueryString["id"].ToString(); ArticleManagerSystem article = new ArticleManagerSystem(); DataSet ds = article.ArticleSelectDetail(int.Parse(id)); if (ds.Tables[0].Rows.Count > 0) { string url1 = ds.Tables[0].Rows[0]["urlimage"].ToString(); string path = Server.MapPath("../image/img_article/"); CvalidateImageForPost manageImage = new CvalidateImageForPost(); if (url1.Length > 0) { manageImage.DeleteFile(path + url1); } } if (article.AdminArticleDelete(id)) { strdarticle = "1"; } } catch { strdarticle = "0"; } Response.Write(strdarticle); break; //for mobile: case "mobile1": try { string type = Request.QueryString["type"].ToString(); string id = Request.QueryString["id"].ToString(); string sort = Request.QueryString["sort"].ToString(); string insert = Request.QueryString["insert"].ToString(); Mobilesystem Mobile = new Mobilesystem(); Boolean test = Mobile.MobileUpdate(int.Parse(id), int.Parse(insert), int.Parse(type), int.Parse(sort)); if (!test) { strmobile = "err"; } } catch { strmobile = "err"; } Response.Write(strmobile); break; } } catch { } }
public void ImportBackup() { string path = Path.Combine(Environment.CurrentDirectory, backup); int sheet = 0; Excel.Application xlApp = new Excel.Application(); xlApp.DisplayAlerts = false; Excel.Workbook xlWB; object misValue = Missing.Value; xlWB = xlApp.Workbooks.Open(path); foreach (Excel.Worksheet xlWS in xlWB.Worksheets) { if (sheet == 0) // if it is merchant sheet { for (int y = 2; y <= xlWS.UsedRange.Rows.Count; y++) { Merchant merc = new Merchant ( xlWS.Cells[y, 1].Text, xlWS.Cells[y, 2].Text, xlWS.Cells[y, 3].Text, xlWS.Cells[y, 4].Text, xlWS.Cells[y, 5].Text ); merchants.Add(merc); } sheet++; } else if (sheet == 1) // if it is cardsystem sheet { for (int y = 2; y <= xlWS.UsedRange.Rows.Count; y++) { Merchant merc = null; bool status = true; bool delayCPI = false; bool delayEvalon = false; Date crd = new Date(int.Parse(xlWS.Cells[y, 9].Text.Split('-')[0]), int.Parse(xlWS.Cells[y, 9].Text.Split('-')[1]), int.Parse(xlWS.Cells[y, 9].Text.Split('-')[2]), "Opretelses Dato"); Date cld = new Date(int.Parse(xlWS.Cells[y, 10].Text.Split('-')[0]), int.Parse(xlWS.Cells[y, 10].Text.Split('-')[1]), int.Parse(xlWS.Cells[y, 10].Text.Split('-')[2]), "Luknings Dato"); foreach (Merchant merchant in merchants) { if (merchant.ID == xlWS.Cells[y, 1].Text) { merc = merchant; break; } } if (xlWS.Cells[y, 2].Text != "Aktiv") { status = false; } if (xlWS.Cells[y, 3].Text == "Forsinket") { delayEvalon = true; } if (xlWS.Cells[y, 4].Text == "Forsinket") { delayCPI = true; } Cardsystem card = new Cardsystem ( merc, crd, xlWS.Cells[y, 5].Text, xlWS.Cells[y, 6].Text, xlWS.Cells[y, 7].Text, xlWS.Cells[y, 8].Text, status, delayEvalon, delayCPI, xlWS.Cells[y, 11].Text, cld ); cardsystems.Add(card); } sheet++; } else if (sheet == 2) // if it is mobilsystem sheet { for (int y = 2; y <= xlWS.UsedRange.Rows.Count; y++) { Merchant merc = null; bool status = true; bool delayNETS = false; bool delayEvalon = false; Date crd = new Date(int.Parse(xlWS.Cells[y, 9].Text.Split('-')[0]), int.Parse(xlWS.Cells[y, 9].Text.Split('-')[1]), int.Parse(xlWS.Cells[y, 9].Text.Split('-')[2]), "Opretelses Dato"); Date cld = new Date(int.Parse(xlWS.Cells[y, 10].Text.Split('-')[0]), int.Parse(xlWS.Cells[y, 10].Text.Split('-')[1]), int.Parse(xlWS.Cells[y, 10].Text.Split('-')[2]), "Luknings Dato"); foreach (Merchant merchant in merchants) { if (merchant.ID == xlWS.Cells[y, 1].Text) { merc = merchant; break; } } if (xlWS.Cells[y, 2].Text != "Aktiv") { status = false; } if (xlWS.Cells[y, 3].Text == "Forsinket") { delayEvalon = true; } if (xlWS.Cells[y, 4].Text == "Forsinket") { delayNETS = true; } Mobilesystem mobile = new Mobilesystem ( merc, crd, xlWS.Cells[y, 5].Text, xlWS.Cells[y, 6].Text, xlWS.Cells[y, 7].Text, xlWS.Cells[y, 8].Text, status, delayEvalon, delayNETS, xlWS.Cells[y, 11].Text, cld ); mobilesystems.Add(mobile); } sheet++; } } repo.GetCardLists(cardsystems); repo.GetMobileLists(mobilesystems); repo.GetMercLists(merchants); }