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