protected void Page_Load(object sender, EventArgs e) { bool bUploaded = false; //TODO: HTTP 401 or Redirect if (!RequestAuthentication.Authenticate(Request)) { Logger.AddToLogger(Server.MapPath("."), "AddData.aspx ERROR: Request failed authentication."); return; } Action <string> loggingAction = error => Logger.AddToLogger(Server.MapPath("."), "AddData.aspx ERROR: " + error); var requestValidator = new RequestValidator(loggingAction); var propertiesToValidate = new List <string> { "TransactionGUID", "CountryIDFrom", "CompanyVATFrom", "CountryIDTo", "CompanyVATTo", "WriteCode", "Data", "CompanySerialNumber" }; //TODO: HTTP 404 or Redirect if (!requestValidator.ValidateDataFieldsInRequest(Request, propertiesToValidate)) { return; } DBLayer dblayer = new DBLayer(); dblayer.CreateConnectionString(Server.MapPath(".")); var countryIDFrom = Request["CountryIDFrom"]; var companyVATFrom = Request["CompanyVATFrom"]; var countryIDTo = Request["CountryIDTo"]; var companyVATTo = Request["CompanyVATTo"]; var data = Request["Data"]; var companySerialNumber = Request["CompanySerialNumber"]; var transactionGUID = Request["TransactionGUID"]; var writeCode = Request["WriteCode"]; if (dblayer.IsCompanyBlocked(countryIDFrom, companyVATFrom, countryIDTo, companyVATTo)) { return; } // TODO: WTF? data = data.Replace("\"\"", "\""); data = data.Replace("''", "'"); data = data.Replace("\"", "\"\""); data = data.Replace("'", "''"); var success = dblayer.AddData(transactionGUID, countryIDFrom, companyVATFrom, countryIDTo, companyVATTo, data, writeCode); if (success) { Billing billing = dblayer.GetBilling(companySerialNumber, Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString())); if (billing == null) { billing = new Billing { CompanySerialNumber = companySerialNumber, DateMonth = Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString()), InCounter = 1, OutCounter = 0 }; dblayer.AddBilling(billing); } else { billing.InCounter++; dblayer.UpdateBilling(billing, Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString())); } UploadFile uf = new UploadFile(); bUploaded = uf.Upload(Request, loggingAction, Server.MapPath("."), transactionGUID); } //Response.Write(transactionGUID + ", " + countryIDFrom + ", " + companyVATFrom + ", " + countryIDTo + ", " + companyVATTo + ", " + data + ", " + writeCode + ", bUploaded" + bUploaded); Response.Write("Uploaded: " + bUploaded); }
protected void Page_Load(object sender, EventArgs e) { Logger.AddToLogger(Server.MapPath("."), "Loading page GetData.aspx.cs"); //http://212.150.1.51/GlobalInfoProtocol/GetData.aspx?CountryID=117&CompanyVAT=513638346&MAC=001CC0B16B8C&Read=123456789&Write=123456789&LoginKey=xezp3avnniqyjf45wso0ot45 //http://212.150.1.51/GlobalInfoProtocol/GetData.aspx?CountryID=117&CompanyVAT=512242355&MAC=001CC0B16B8C&Read=peer30033&Write=ilana1234&LoginKey=xezp3avnniqyjf45wso0ot45 DBLayer dblayer = new DBLayer(); dblayer.CreateConnectionString(Server.MapPath(".")); String LoginKey = Request["LoginKey"]; String CountryID = Request["CountryID"]; String CompanyVAT = Request["CompanyVAT"]; String ReadCode = Request["Read"]; String MAC = Request["MAC"]; String WriteCode = Request["Write"]; String CompanySerialNumber = Request["CompanySerialNumber"]; if (LoginKey != "xezp3avnniqyjf45wso0ot45") { return; } //var data = new Dictionary<string, string> { }; ValidateRequestData("CountryID", CountryID); ValidateRequestData("CompanyVAT", CompanyVAT); ValidateRequestData("ReadCode", ReadCode); ValidateRequestData("MAC", MAC); ValidateRequestData("WriteCode", WriteCode); ValidateRequestData("CompanySerialNumber", CompanySerialNumber); Company company = dblayer.GetCompanyReadable(CountryID, MAC, CompanyVAT, ReadCode); if (company != null) { if (company.Active) { String data = dblayer.GetCompanyData(CountryID, CompanyVAT, WriteCode); if ((data != null) && (data.Trim() != "")) { Response.Write(data); string[] lines = data.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); Billing billing = dblayer.GetBilling(CompanySerialNumber, Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString())); if (billing == null) { billing = new Billing(); billing.CompanySerialNumber = CompanySerialNumber; billing.DateMonth = Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString()); billing.InCounter = 0; billing.OutCounter = lines.Length; dblayer.AddBilling(billing); } else { billing.OutCounter += lines.Length; dblayer.UpdateBilling(billing, DateTime.Now.AddDays(-(DateTime.Now.Day) + 1)); } } } } }
protected void Page_Load(object sender, EventArgs e) { //http://212.150.1.51/GlobalInfoProtocol/AddData.aspx?CountryIDFrom=117&CompanyVATFrom=513638346&CountryIDTo=117&CompanyVATTo=513638346&WriteCode=123456789&Data=KT|024444|0303/12/2012|0503/12/2012|0603/12/2012|07אדירים|08513638346|09xxx|10|111|12|13222|14חז&LoginKey=xezp3avnniqyjf45wso0ot45 //http://212.150.1.51/GlobalInfoProtocol/AddData.aspx? //CountryIDFrom=117&CompanyVATFrom=513638346&CountryIDTo=117 //&CompanyVATTo=513638346&WriteCode=123456789& //Data=KT|024444|0303/12/2012|0503/12/2012|0603/12/2012|07אדירים|08513638346|09xxx|10|111|12|13222|14חז //&LoginKey=xezp3avnniqyjf45wso0ot45 //http://212.150.1.51/GlobalInfoProtocol/AddData.aspx? //CountryIDFrom=117 //&CompanyVATFrom=513638346 //&CountryIDTo=117 //&CompanyVATTo=513638346 //&WriteCode=123456789& //Data=KT|02222|0303/12/2012|0503/12/2012|0603/12/2012|07אדירים|08513638346|09ww|10|111|12|13333|14חז //&LoginKey=xezp3avnniqyjf45wso0ot45 DBLayer dblayer = new DBLayer(); dblayer.CreateConnectionString(Server.MapPath(".")); String LoginKey = Request["LoginKey"]; String TransactionGUID = Request["TransactionGUID"]; String CountryIDFrom = Request["CountryIDFrom"]; String CompanyVATFrom = Request["CompanyVATFrom"]; String CountryIDTo = Request["CountryIDTo"]; String CompanyVATTo = Request["CompanyVATTo"]; String WriteCode = Request["WriteCode"]; String Data = Request["Data"]; String CompanySerialNumber = Request["CompanySerialNumber"]; if ((LoginKey != null) && (LoginKey == "xezp3avnniqyjf45wso0ot45")) { if ((TransactionGUID != null) && (TransactionGUID != "")) { if ((WriteCode != null) && (WriteCode != "")) { if ((CountryIDFrom != null) && (CountryIDFrom != "")) { if ((CompanyVATFrom != null) && (CompanyVATFrom != "")) { if ((CountryIDTo != null) && (CountryIDTo != "")) { if ((CompanyVATTo != null) && (CompanyVATTo != "")) { if ((Data != null) && (Data != "")) { if ((CompanySerialNumber != null) && (CompanySerialNumber != "")) { if (!dblayer.IsCompanyBlocked(CountryIDFrom, CompanyVATFrom, CountryIDTo, CompanyVATTo)) { Data = Data.Replace("\"\"", "\""); Data = Data.Replace("''", "'"); Data = Data.Replace("\"", "\"\""); Data = Data.Replace("'", "''"); Response.Write(TransactionGUID + ", " + CountryIDFrom + ", " + CompanyVATFrom + ", " + CountryIDTo + ", " + CompanyVATTo + ", " + Data + ", " + WriteCode); if (dblayer.AddData(TransactionGUID, CountryIDFrom, CompanyVATFrom, CountryIDTo, CompanyVATTo, Data, WriteCode)) { Billing billing = dblayer.GetBilling(CompanySerialNumber, Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString())); if (billing == null) { billing = new Billing(); billing.CompanySerialNumber = CompanySerialNumber; billing.DateMonth = Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString()); billing.InCounter = 1; billing.OutCounter = 0; dblayer.AddBilling(billing); } else { billing.InCounter++; dblayer.UpdateBilling(billing, Convert.ToDateTime(DateTime.Now.AddDays(-(DateTime.Now.Day) + 1).ToShortDateString())); } } } } } } } } } } } } }