public void readAndSaveWagonToDB(long wagonNo, string solarDateFrom, string solarDateTo, int cycleNumber)
{
wagonInfoTrackingDetail wagonDetail = new wagonInfoTrackingDetail();
try
{
DateTime dateFrom, dateTo;
dateFrom = DateTime.MinValue;
dateTo = DateTime.MaxValue;
try
{
dateFrom = Functions.solarToMiladi(solarDateFrom);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Error in date format solarDateFrom", "Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
if (solarDateFrom.Length == 10)
{
solarDateFrom = solarDateFrom.Remove(0, 2);
}
solarDateFrom = solarDateFrom.Replace("/", "");
try
{
dateTo = Functions.solarToMiladi(solarDateTo);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Error in date format solarDateTo", "Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
if (solarDateTo.Length == 10)
{
solarDateTo = solarDateTo.Remove(0, 2);
}
solarDateTo = solarDateTo.Replace("/", "");
if (dateFrom > dateTo)
{
System.Windows.Forms.MessageBox.Show("SolarDateFrom should be lower than SolarDateTo", "Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
login lg = new login();
start:
if (login.v_cookieCollection == null)
{
if (!lg.fnc_login())
{
//cannot login
return;
}
}
Uri uri;
uri = new Uri(this.v_url);
string postData;
int pageNumber = 1;
do
{
HttpWebRequest webRequest = (HttpWebRequest)HttpWebRequest.Create(uri);
//webRequest.Headers.Add("Accept-Language", "en-US,en;q=0.8");
webRequest.Proxy = null;
webRequest.Method = "POST";
//webRequest.Headers.Add("Cache-Control", "no-cache");
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.CookieContainer = new CookieContainer();
foreach (Cookie cookie in login.v_cookieCollection)
{
webRequest.CookieContainer.Add(cookie);
}
postData = "WagonNo=" + wagonNo.ToString()
+ "&From_Date=" + solarDateFrom.ToString()
+ "&To_Date=" + solarDateTo.ToLower()
+ "&Page=" + pageNumber.ToString();
byte[] formData = Encoding.ASCII.GetBytes(postData);
webRequest.ContentLength = formData.Length;
Stream streamRequest = webRequest.GetRequestStream();
streamRequest.Write(formData, 0, formData.Length);
streamRequest.Flush();
streamRequest.Close();
HttpWebResponse webResponse = (HttpWebResponse)webRequest.GetResponse();
if (webResponse != null)
{
if (webResponse.ResponseUri == null || string.IsNullOrEmpty(webResponse.ResponseUri.AbsoluteUri))
{
webResponse.Close();
return;
}
if (login.fnc_isLoginPage(webResponse, this.v_url))
{
//we haven't loginned yet
if (lg.fnc_login())
{
goto start;
}
else
{
//cannot login inform or log !!!!!
webResponse.Close();
return;
}
}
string result;
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream(), Encoding.GetEncoding("windows-1256")))
{
result = rd.ReadToEnd();
}
webResponse.Close();
if (!string.IsNullOrEmpty(result))
{
this.v_dt.Rows.Clear();
Functions.sb_fillDatatableWithHtmlTableId(result, "AutoNumber2", 2, 0, 0, 0, this.v_dt);
if (this.v_dt.Rows.Count > 0)
{
this.sb_saveToDB(this.v_dt, cycleNumber);
}
}
}
pageNumber++;
} while (this.v_dt.Rows.Count > 0);
}
catch (Exception ex)
{
}
}
public void readAndSaveWagonToDB(long wagonNoStart, long wagonNoEnd, int cycleNumber, bool get30DaysBeforeInformation)
{
wagonInfoTrackingDetail wagonDetail = new wagonInfoTrackingDetail();
try
{
login lg = new login();
start:
if (login.v_cookieCollection == null)
{
if (!lg.fnc_login())
{
//cannot login
return;
}
}
Uri uri;
uri = new Uri(this.v_url);
HttpWebRequest webRequest = (HttpWebRequest)HttpWebRequest.Create(uri);
//webRequest.Headers.Add("Accept-Language", "en-US,en;q=0.8");
webRequest.Proxy = null;
webRequest.Method = "POST";
//webRequest.Headers.Add("Cache-Control", "no-cache");
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.CookieContainer = new CookieContainer();
foreach (Cookie cookie in login.v_cookieCollection)
{
webRequest.CookieContainer.Add(cookie);
}
string postData;
postData = "FToolNo=" + wagonNoStart.ToString() + "&TToolNo=" + wagonNoEnd.ToString()
+ "&WNumber=&Wagon_No=&From_Date=&To_Date=&Rd_Exportkind=html";
byte[] formData = Encoding.ASCII.GetBytes(postData);
webRequest.ContentLength = formData.Length;
Stream streamRequest = webRequest.GetRequestStream();
streamRequest.Write(formData, 0, formData.Length);
streamRequest.Flush();
streamRequest.Close();
HttpWebResponse webResponse = (HttpWebResponse)webRequest.GetResponse();
if (webResponse != null)
{
if (webResponse.ResponseUri == null || string.IsNullOrEmpty(webResponse.ResponseUri.AbsoluteUri))
{
webResponse.Close();
return;
}
if (login.fnc_isLoginPage(webResponse, this.v_url))
{
//we haven't loginned yet
if (lg.fnc_login())
{
goto start;
}
else
{
//cannot login inform or log !!!!!
webResponse.Close();
return;
}
}
string result;
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream(), Encoding.GetEncoding("windows-1256")))
{
result = rd.ReadToEnd();
}
webResponse.Close();
if (!string.IsNullOrEmpty(result))
{
this.v_dt.Rows.Clear();
Functions.sb_fillDatatableWithHtmlTableId(result, "AutoNumber2", 2, 0, 0, 0, this.v_dt);
if (this.v_dt.Rows.Count > 0)
{
this.sb_saveToDB(this.v_dt, cycleNumber);
if (get30DaysBeforeInformation)
{
for (int i = 0; i <= this.v_dt.Rows.Count - 1; i++)
{
wagonDetail.readAndSaveWagonToDB(long.Parse(this.v_dt.Rows[i].ToString()), Functions.miladiToSolar(DateTime.Now), cycleNumber);
}
}
}
}
}
}
catch (Exception ex)
{
}
}
