//Personel Listesi
public void PersonelListData()
{
var CaniasWebServiceYeni = new iasWebServiceImplService();
string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay");
//object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,16.01.2018,20.02.2018,1,1", "STRING", true);
object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,16.01.2018,20.02.2018,1,1", "STRING", true);
//object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "2,40,01.01.2018,20.03.2018,1,1,2018,02", "STRING", true);
string jsonString = resp.ToString();
CaniasWebServiceYeni.logout(sessionid);
JArray jsonVal = JArray.Parse(jsonString) as JArray;
dynamic lizaylist = jsonVal;
JSONData d = new JSONData();
//foreach (dynamic x in lizaylist)
//{
// Lizay.dll.method.MOBILUSERLIST.AddUserData(new Lizay.dll.entity.MOBILUSERLIST()
// {
// PERSID = x.PERSID.ToString(),
// DISPLAY = x.PERSTEXT.ToString(),
// DEPARTMENT = x.PERSBUSA.ToString(),
// DEPARTMENTT = x.PERSBUSATEXT.ToString(),
// BIRTHDAY = "",
// NAME = x.PERSTEXT.ToString(),
// SURNAME = x.PERSTEXT.ToString(),
// PAY = x.PERSPAY.ToString(),
// });
// Lizay.dll.method.MOBILUSERLIST.AddCompanyData(new Lizay.dll.entity.MOBILUSERLIST()
// {
// DEPARTMENT = x.PERSBUSA.ToString(),
// DEPARTMENTT = x.PERSBUSATEXT.ToString(),
// });
//}
Label2.Text = jsonVal.Count.ToString() + " Adet personel ve mağaza kaydı aktarılmıştır.";
}
//Mağaza Hedef Dataları
public void CompanySalesTargetData()
{
var CaniasWebServiceYeni = new iasWebServiceImplService();
string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay");
//object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "1,40,01.01.2018,20.03.2018,1,1,2018,02", "STRING", true);
object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "2,40,01.03.2018,21.03.2018,1,1,2018,03", "STRING", true);
string jsonString = resp.ToString();
CaniasWebServiceYeni.logout(sessionid);
JArray jsonVal = JArray.Parse(jsonString) as JArray;
dynamic lizaylist = jsonVal;
JSONData d = new JSONData();
foreach (dynamic x in lizaylist)
{
Lizay.dll.method.COMPANYTARGETRATE.AddCompanyTargetData(new Lizay.dll.entity.COMPANYTARGETRATE()
{
CLIENT = x.CLIENT.ToString(),
COMPANY = x.COMPANY.ToString(),
FINYEAR = x.FINYEAR.ToString(),
FINPERIOD = x.FINPERIOD.ToString(),
TOTALORAN = x.TOTALORAN.ToString(),
BUSAREA = x.BUSAREA.ToString(),
STEXT = x.STEXT.ToString(),
PLAIN = x.PLAIN.ToString(),
MAGAZAORAN = x.MAGAZAORAN.ToString(),
CURRENCY = "TL",
});
}
Label2.Text = jsonVal.Count.ToString() + " Adet mağaza hedef kaydı aktarılmıştır.";
}
protected void Page_Load(object sender, EventArgs e)
{
if (CurrentUser.USERNAME == "")
{
FormsAuthentication.RedirectToLoginPage();
}
if (IsPostBack)
{
return;
}
if (string.IsNullOrEmpty(Page.Request.QueryString["Barkod"]))
{
Response.Redirect("urunarama.aspx");
}
var barcodeData = Page.Request.QueryString["Barkod"];
if (string.IsNullOrEmpty(barcodeData))
{
Response.Redirect("urunarama.aspx");
}
var sessionId = "";
List <BarcodeViewModel> barcode;
var caniasWebService = new iasWebServiceImplService();
try
{
//var arg = "IYILMAZ," + barcodeData;
var arg = CurrentUser.USERNAME + "," + barcodeData;
sessionId = caniasWebService.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay");
var resp = caniasWebService.callIASService(sessionId, "RetailBatchCheck", arg, "STRING", true);
var json = resp.ToString().Replace("[]", "''").Replace("\"ROW\":", "");
json = json.Remove(0, 1);
json = "[" + json;
json = json.Remove(json.Length - 1, 1);
json = json + "]";
barcode = JsonConvert.DeserializeObject <List <BarcodeViewModel> >(json);
}
catch (Exception ex)
{
Console.WriteLine(ex);
if (!string.IsNullOrEmpty(sessionId))
{
caniasWebService.logout(sessionId);
}
return;
}
finally
{
if (!string.IsNullOrEmpty(sessionId))
{
caniasWebService.logout(sessionId);
}
}
switch (barcode)
{
case null:
return;
case List <BarcodeViewModel> list:
{
var mainProduct = list.SingleOrDefault(x => x.IsTp == "1");
if (mainProduct == null)
{
Response.Redirect("urunarama.aspx");
}
var alternativeProduct = list.Where(x => x.IsTp == "0").ToList();
CreateHtmlMainProduct(mainProduct);
CreateHtmlAlternativeProduct(alternativeProduct);
break;
}
}
}
//Personel Satış Dataları
public void PersonData()
{
var CaniasWebServiceYeni = new iasWebServiceImplService();
string sessionid = CaniasWebServiceYeni.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay");
//object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "40,16.01.2018,16.01.2018,1,1", "STRING", true);
object resp = CaniasWebServiceYeni.callIASService(sessionid, "mobilExpenseList", "0,40,01.03.2018,31.03.2018,0,1", "STRING", true);
string jsonString = resp.ToString();
CaniasWebServiceYeni.logout(sessionid);
JArray jsonVal = JArray.Parse(jsonString) as JArray;
dynamic lizaylist = jsonVal;
JSONData d = new JSONData();
foreach (dynamic x in lizaylist)
{
Lizay.dll.method.MOBILEXPENSELIST.AddData(new Lizay.dll.entity.MOBILEXPENSELIST()
{
SATISD = x.SATISD.ToString(),
SALDEPT = x.SALDEPT.ToString(),
COMPANY = x.COMPANY.ToString(),
DOCTYPE = x.DOCTYPE.ToString(),
DOCNUM = x.DOCNUM.ToString(),
DOCDATE = x.DOCDATE.ToString(),
CUSTOMER = x.CUSTOMER.ToString(),
NAME1 = x.NAME1.ToString(),
CUSTGRP = x.CUSTGRP.ToString(),
COUNTRY = x.COUNTRY.ToString(),
DISCAMNT = x.DISCAMNT.ToString(),
CURRENCY = x.CURRENCY.ToString(),
ITEMNUM = x.ITEMNUM.ToString(),
MATERIAL = x.MATERIAL.ToString(),
MTEXT = x.MTEXT.ToString(),
QUANTITY = x.QUANTITY.ToString(),
QUNIT = x.QUNIT.ToString(),
BUSAREA = x.BUSAREA.ToString(),
SPRICE = x.SPRICE.ToString(),
PRICEFACTOR = x.PRICEFACTOR.ToString(),
GROSS = x.GROSS.ToString(),
TDISCAMNT = x.TDISCAMNT.ToString(),
DISCFROMHEAD = x.DISCFROMHEAD.ToString(),
SUBTOTAL = x.SUBTOTAL.ToString(),
ITENDORSE = x.ITENDORSE.ToString(),
MATTYPE = x.MATTYPE.ToString(),
MATGRP = x.MATGRP.ToString(),
EXHM = x.EXHM.ToString(),
EXHR = x.EXHR.ToString(),
MONTSUBTOTAL = x.MONTSUBTOTAL.ToString(),
YEARSUBTOTAL = x.YEARSUBTOTAL.ToString(),
MONTHQUANTITY = x.MONTHQUANTITY.ToString(),
YEARQUANTITY = x.YEARQUANTITY.ToString(),
ISVARIANT = x.ISVARIANT.ToString(),
QUANTITYX = x.QUANTITYX.ToString(),
TCOST = x.TCOST.ToString(),
BATCHNUM = x.BATCHNUM.ToString(),
TOTPROF = x.TOTPROF.ToString(),
TOTRATE = x.TOTRATE.ToString(),
PRINTEDINVNUM = x.PRINTEDINVNUM.ToString(),
MAINMATGRP = x.MAINMATGRP.ToString(),
PAYMCOND = x.PAYMCOND.ToString(),
PAYMTYPE = x.PAYMTYPE.ToString(),
SCMADEN = x.SCMADEN.ToString(),
SCGRUP = x.SCGRUP.ToString(),
SCTEMEL = x.SCTEMEL.ToString(),
SALDEPTX = x.SALDEPTX.ToString(),
PUAN = x.PUAN.ToString(),
TEGI = x.TEGI.ToString(),
TERW = x.TERW.ToString(),
INVTYPE = x.INVTYPE.ToString(),
DATATYPE = "PERSONEL",
});
}
Label2.Text = jsonVal.Count.ToString() + " Adet personel kaydı aktarılmıştır.";
}
public static string GetData(int pageIndex)
{
var sessionId = "";
var caniasWebService = new iasWebServiceImplService();
var sb = new StringBuilder();
try
{
var a = pageIndex * 10;
var countFilter = "";
if (pageIndex == 1)
{
countFilter = "1," + a;
}
if (pageIndex > 1)
{
countFilter = (a + 1) + "," + (a + 10);
}
//var arg = "3,IYILMAZ,AMML,,,,,,1,10";
//var arg = "3,IYILMAZ,AMML,,,,,," + countFilter;
//var arg = "3,IYILMAZ,ALYM,AU,AL,05,1,10";
var arg = "3," + ActiveSession.ActiveUserName + ActiveSession.ActiveUrunFilter + "," + countFilter;
sessionId = caniasWebService.login("00", "T", "NEW", "CANIAS", "192.168.1.50:27499/S2", "WSLIZAY", "Ws-123lizay");
var resp = caniasWebService.callIASService(sessionId, "RetailMatCheck", arg, "STRING", true);
var json = resp.ToString().Replace("[]", "''").Replace("\"ROW\":", "");
json = json.Remove(0, 1);
json = "[" + json;
json = json.Remove(json.Length - 1, 1);
json = json + "]";
var list = JsonConvert.DeserializeObject <List <BarcodeListViewModel> >(json);
var i = 0;
foreach (var d in list.ToList())
{
sb.AppendLine("<div class=\"row\">");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style = \"margin-top: 15px;border-bottom: groove;\">");
sb.AppendLine("<div class=\"col-lg-3 col-xs-6\"> ");
sb.AppendLine("<img src=\"data:image/png;base64," + d.Pict.Replace("-----BEGIN CERTIFICATE-----", "").Replace("-----END CERTIFICATE-----", "") + "\" class=\"img-responsive\" alt =\"\" />");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-9 col-xs-6\"> ");
//sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
//sb.AppendLine("<div class=\"urunlistsol\">Taş:</div>");
//sb.AppendLine("<p class=\"urunlistsag\">" + d.IsMatText.Trim() + "</p>");
//sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
sb.AppendLine("<div class=\"urunlistsol\">Taş Özellikleri:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.IsTasDet.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
sb.AppendLine("<div class=\"urunlistsol\">Barkod:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.Batch.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
sb.AppendLine("<div class=\"urunlistsol\"> Montür:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.DetColor.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> ");
sb.AppendLine("<div class=\"urunlistsol\">Ağırlık:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.QuantityX.Trim() + "gr</p>");
sb.AppendLine("</div>");
//sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> ");
//sb.AppendLine("<div class=\"urunlistsol\">Kesim:</div>");
//sb.AppendLine("<p class=\"urunlistsag\">" + d.IsMatText.Trim() + "</p>");
//sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> ");
sb.AppendLine("<div class=\"urunlistsol\">Fiyat:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.Lastprice.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\"> ");
sb.AppendLine("<div class=\"urunlistsol\">Fiyat Kuru:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.Spricecurrency.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\" > ");
sb.AppendLine("<div class=\"urunlistsol\">E:</div>");
sb.AppendLine("<p class=\"urunlistsag ustucizik\"> " + d.Mameti.Trim() + "</p>");
sb.AppendLine("</div>");
//sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
//sb.AppendLine("<div class=\"urunlistsol\"> Maliyet Kuru:</div>");
//sb.AppendLine("<p class=\"urunlistsag\">" + d.Costcurrency.Trim() + "</p>");
//sb.AppendLine("</div>");
sb.AppendLine("<div class=\"col-lg-12 col-xs-12\" style =\"margin-top: 10px;\">");
sb.AppendLine("<div class=\"urunlistsol\"> Bulunduğu Mağaza:</div>");
sb.AppendLine("<p class=\"urunlistsag\">" + d.IsWare.Trim() + "</p>");
sb.AppendLine("</div>");
sb.AppendLine("</div>");
sb.AppendLine("</div>");
sb.AppendLine("</div>");
//if (i > 10)
// break;
i++;
}
return(sb.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex);
if (!string.IsNullOrEmpty(sessionId))
{
caniasWebService.logout(sessionId);
}
}
finally
{
if (!string.IsNullOrEmpty(sessionId))
{
caniasWebService.logout(sessionId);
}
}
return("");
}
