private int?fnc_saveValues(IWebElement element, bool download, out bool stopFetch)
{
stopFetch = false;
Dictionary <string, object> dic = this.fnc_getValues(element, download);
string whereCondition = this.fnc_getWhereCondition(dic, this.prp_identifierColumnNames);
using (var entity = new Model.logisticEntities())
{
int?idValue;
var exists = entity.Database.SqlQuery <int?>("select top 1 1 from " + this.TableName + (string.IsNullOrEmpty(whereCondition) ? "" : " where " + whereCondition)).FirstOrDefault();
if (exists.HasValue)
{
idValue = this.fnc_update(dic, whereCondition);
if (this.prp_stopFetchingWhenGotToExistedRows)
{
stopFetch = true;
}
return(idValue);
}
else
{
idValue = this.fnc_insert(dic);
return(idValue);
}
}
}
public void sb_readAndSaveStatesToDB(bool saveCitiesForEachState)
{
try
{
Uri uri = new Uri(this.v_urlState);
StateCityJsonModel[] statesJson = null;
WebRequest webRequest = WebRequest.Create(uri);
webRequest.Proxy = null;
webRequest.Method = "GET";
WebResponse webResponse = webRequest.GetResponse();
if (webResponse != null)
{
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream()))
{
string result = rd.ReadToEnd();
statesJson = Newtonsoft.Json.JsonConvert.DeserializeObject <StateCityJsonModel[]>(result);
}
webResponse.Close();
if (statesJson != null)
{
using (var entityLogistic = new Model.logisticEntities())
{
foreach (StateCityJsonModel state in statesJson)
{
this.sb_saveStateToDB(state, saveCitiesForEachState);
}
}
}
}
}
catch (Exception ex)
{
}
}
public int fnc_getLastPageIndex()
{
int?startPageIndex = 1;
if (string.IsNullOrEmpty(this.TableName))
{
throw new Exception("TableName is not specified");
}
if (string.IsNullOrEmpty(this.prp_pageIndexColumnName))
{
throw new Exception("prp_columnPageIndexName is not specified");
}
string whereCondition = "";
using (var entityLogistic = new Model.logisticEntities())
{
if (this.prp_pageIndexIdentifierColumnNames != null && this.prp_pageIndexIdentifierColumnNames.Length > 0)
{
Dictionary <string, object> dicValues = this.fnc_getValues(null, false, this.prp_pageIndexIdentifierColumnNames);
whereCondition = this.fnc_getWhereCondition(dicValues, this.prp_pageIndexIdentifierColumnNames);
}
startPageIndex = entityLogistic.Database.SqlQuery <int?>("select max(" + this.prp_pageIndexColumnName + ") from " + this.TableName + (string.IsNullOrEmpty(whereCondition) ? "" : " where " + whereCondition)).FirstOrDefault();
if (!startPageIndex.HasValue)
{
return(1);
}
return(startPageIndex.Value);
}
}
public static int?fnc_getWagonIdCheckWithControlNo(long?wagonNo /*,bool add*/, bool notifNotExist)
{
if (!wagonNo.HasValue)
{
return(null);
}
using (var entityLogistic = new Model.logisticEntities())
{
var entryWagon = entityLogistic.Wagons.FirstOrDefault(o => o.wagonControlNo == wagonNo.ToString());
if (entryWagon == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "WagonNo = " + wagonNo + " does not exist in Wagons table.";// + (add ? "? It will be created" : "");
}
//if (add)
//{
// entryWagon = new Model.Wagon();
// entryWagon.wagonNo = wagonNo;
// entityLogistic.Wagons.Add(entryWagon);
// entityLogistic.SaveChanges();
// return entryWagon.Id;
//}
//else return null;
return(null);
}
else
{
return(entryWagon.Id);
}
}
}
public void sb_readAndSaveToDB()
{
try
{
Uri uri = new Uri(this.v_url);
stationsJsonModel stationsJson = null;
WebRequest webRequest = WebRequest.Create(uri);
webRequest.Proxy = null;
webRequest.Method = "GET";
WebResponse webResponse = webRequest.GetResponse();
if (webResponse != null)
{
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream()))
{
string result = rd.ReadToEnd();
stationsJson = Newtonsoft.Json.JsonConvert.DeserializeObject <stationsJsonModel>(result);
}
webResponse.Close();
if (stationsJson != null && stationsJson.features != null)
{
using (var entityLogistic = new Model.logisticEntities())
{
foreach (station_featureJsonModel feature in stationsJson.features)
{
feature.sb_saveToDB();
}
}
}
}
}
catch (Exception ex)
{
}
}
public static int?fnc_getBillOfLadingId(long?billOfLadingNo /*,bool add*/, bool notifNotExist)
{
if (!billOfLadingNo.HasValue)
{
return(null);
}
using (var entityLogistic = new Model.logisticEntities())
{
var entryBillOfLading = entityLogistic.PWS0BillOfLadings.FirstOrDefault(o => o.jBarnameh_NO == billOfLadingNo.ToString());
if (entryBillOfLading == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "BillOfLading = " + billOfLadingNo + " does not exist in BillOfLadings table.";// + (add ? "? It will be created" : "");
}
//if (add)
//{
// entryWagon = new Model.Wagon();
// entryWagon.wagonNo = wagonNo;
// entityLogistic.Wagons.Add(entryWagon);
// entityLogistic.SaveChanges();
// return entryWagon.Id;
//}
//else return null;
return(null);
}
else
{
return(entryBillOfLading.Id);
}
}
}
public void sb_saveToDB(trainBillOfLadingsJsonModel billOfLading, int train_no, int?trainId, int cycleNumber, string fetchUrl)
{
bool add = false;
using (var entityLogistic = new Model.logisticEntities())
{
Model.PWS0BillOfLadings entryPWS0BillOfLading = entityLogistic.PWS0BillOfLadings.FirstOrDefault(o =>
o.jBarnameh_NO == billOfLading.Barnameh_NO &&
o.jBar_Type == billOfLading.Bar_Type
//&& o.jDestination_Station_Name == trainWagon.Destination_Station_Name
//&& o.jSource_Station_Name== trainWagon.Source_Station_Name
&& o.jWagon_NO == billOfLading.Wagon_NO);
if (entryPWS0BillOfLading == null)
{
add = true;
entryPWS0BillOfLading = new Model.PWS0BillOfLadings();
}
try
{
entryPWS0BillOfLading.CurrentStationId = stations.fnc_getStationId(billOfLading.Current_Station_Code, billOfLading.Current_Station_Name, true);;
entryPWS0BillOfLading.CycleNumber = cycleNumber;
entryPWS0BillOfLading.DestinationStationId = stations.fnc_getStationId(null, billOfLading.Destination_Station_Name, true);
entryPWS0BillOfLading.FetchTime = DateTime.Now;
entryPWS0BillOfLading.FetchUrl = fetchUrl;
entryPWS0BillOfLading.goodsId = goods.fnc_getGoodsId(billOfLading.Bar_Type, false, true);
entryPWS0BillOfLading.jBarnameh_NO = billOfLading.Barnameh_NO;
entryPWS0BillOfLading.jBar_Type = billOfLading.Bar_Type;
entryPWS0BillOfLading.jCurrent_Station_Code = billOfLading.Current_Station_Code;
entryPWS0BillOfLading.jCurrent_Station_Name = billOfLading.Current_Station_Name;
entryPWS0BillOfLading.jDestination_Station_Name = billOfLading.Destination_Station_Name;
entryPWS0BillOfLading.jEntrance_Date = billOfLading.Entrance_Date;
entryPWS0BillOfLading.jEntrance_Date_M = billOfLading.Entrance_Date_M;
entryPWS0BillOfLading.jEntrance_Time = billOfLading.Entrance_Time;
entryPWS0BillOfLading.jF15Rec_ID = billOfLading.F15Rec_ID;
entryPWS0BillOfLading.jSource_Station_Code = billOfLading.Source_Station_Code;
entryPWS0BillOfLading.jSource_Station_Name = billOfLading.Source_Station_Name;
entryPWS0BillOfLading.jTashkil_Date = billOfLading.Tashkil_Date;
entryPWS0BillOfLading.jTashkil_Time = billOfLading.Tashkil_Time;
entryPWS0BillOfLading.jTrain_No = billOfLading.Train_No;
entryPWS0BillOfLading.jWagon_NO = billOfLading.Wagon_NO;
entryPWS0BillOfLading.SourceStationId = stations.fnc_getStationId(billOfLading.Source_Station_Code, billOfLading.Source_Station_Name, true);
entryPWS0BillOfLading.TashkilDateTime = Functions.fnc_convertSolarDateAndTimeToDateTime(entryPWS0BillOfLading.jTashkil_Date, string.IsNullOrEmpty(billOfLading.Tashkil_Time) ? null : (int?)int.Parse(billOfLading.Tashkil_Time));
entryPWS0BillOfLading.TrainId = (trainId.HasValue ? trainId.Value : (billOfLading.Entrance_Date_M.HasValue ? (int?)trainBarry.fnc_getTrainIdFromDB(train_no, billOfLading.Entrance_Date_M.Value) : null));
entryPWS0BillOfLading.WagonId = trainBarryWagons.fnc_getWagonIdCheckWithControlNo(billOfLading.Wagon_NO, true);
if (add)
{
entityLogistic.PWS0BillOfLadings.Add(entryPWS0BillOfLading);
}
entityLogistic.SaveChanges();
}
catch (Exception ex)
{
}
}
}
public static bool fnc_saveWagonFromRWMMS(rwmms.declerationListDataTable dt, int rowIndex)
{
if (dt == null)
{
throw new Exception("dt is null");
}
if (rowIndex < 0 || rowIndex >= dt.Rows.Count)
{
throw new Exception("rowIndex " + rowIndex + " is outofbound");
}
DataRow dr = dt.Rows[rowIndex];
long wagonNo = long.Parse(dr[rwmms.declerationListDataTable.fld_wagonNo].ToString());
try
{
using (var entityLogistic = new Model.logisticEntities())
{
bool add = false;
var entryWagon = entityLogistic.Wagons.FirstOrDefault(o => o.wagonNo == wagonNo);
if (entryWagon == null)
{
add = true;
entryWagon = new Model.Wagon();
}
//entryWagon.capacity ;
entryWagon.companyId = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_ownerName]) ? null : rwmms.vehicleOwners.Fnc_getVehicleOwnerId(dr[rwmms.declerationListDataTable.fld_ownerName].ToString());
entryWagon.wagonNo = wagonNo;
entryWagon.wagonTypeId = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonTypeName]) ? null : trainBarryWagons.fnc_getWagonTypeName(dr[rwmms.declerationListDataTable.fld_wagonTypeName].ToString(), true, true);
entryWagon.wrAxisCount = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonAxisCount]) ? null : (int?)int.Parse(dr[rwmms.declerationListDataTable.fld_wagonAxisCount].ToString());
entryWagon.wrBoogieType = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonBoogieType]) ? null : dr[rwmms.declerationListDataTable.fld_wagonBoogieType].ToString();
entryWagon.wrBrakeType = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonBrakeType]) ? null : dr[rwmms.declerationListDataTable.fld_wagonBrakeType].ToString();
entryWagon.wrCapacity = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonCapacity]) ? null : (double?)double.Parse(dr[rwmms.declerationListDataTable.fld_wagonCapacity].ToString());
entryWagon.wrChassisSerial = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonChassisSerialNo]) ? null : dr[rwmms.declerationListDataTable.fld_wagonChassisSerialNo].ToString();
entryWagon.wrCompanyManufacturer = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonCompanyManufacturer]) ? null : dr[rwmms.declerationListDataTable.fld_wagonCompanyManufacturer].ToString();
entryWagon.wrCountry = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonCountry]) ? null : dr[rwmms.declerationListDataTable.fld_wagonCountry].ToString();
entryWagon.wrHookType = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonHookType]) ? null : dr[rwmms.declerationListDataTable.fld_wagonHookType].ToString();
entryWagon.wrNetWeight = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonNetWeight]) ? null : (double?)double.Parse(dr[rwmms.declerationListDataTable.fld_wagonNetWeight].ToString());
entryWagon.wrProductionYear = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonProductionYear]) ? null : (int?)int.Parse(dr[rwmms.declerationListDataTable.fld_wagonProductionYear].ToString());
entryWagon.wrRivNo = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonRIVNo]) ? null : dr[rwmms.declerationListDataTable.fld_wagonRIVNo].ToString();
entryWagon.wrWagonTypeName = Functions.IsNull(dr[rwmms.declerationListDataTable.fld_wagonTypeName]) ? null : dr[rwmms.declerationListDataTable.fld_wagonTypeName].ToString();
if (add)
{
entityLogistic.Wagons.Add(entryWagon);
}
else
{
entityLogistic.Entry(entryWagon).State = EntityState.Modified;
}
entityLogistic.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static int?fnc_getStationId(int?stationCode, string stationName, bool notifNotExist)
{
if (!stationCode.HasValue && string.IsNullOrEmpty(stationName))
{
return(null);
}
using (var entityLogistic = new Model.logisticEntities())
{
Model.PWS0Stations station;
if (stationCode.HasValue)
{
station = entityLogistic.PWS0Stations.FirstOrDefault(o => o.stcode == stationCode);
}
else
{
station = entityLogistic.PWS0Stations.FirstOrDefault(o => o.name == stationName);
if (station == null)
{
station = entityLogistic.PWS0Stations.FirstOrDefault(o => o.name2 == stationName);
if (station == null)
{
station = entityLogistic.PWS0Stations.FirstOrDefault(o => o.alternateNames.Contains(stationName + ";"));
}
}
}
if (station == null)
{
string strNotif = "";
if (notifNotExist)
{
if (stationCode.HasValue)
{
strNotif = "stationCode = " + stationCode + " does not exist in PWS0Stations table.";//+ (add ? "? It will be created" : "");
}
else
{
strNotif = "stationName1 or stationName2 = " + stationName + " does not exist in PWS0Stations table."; //+ (add ? "? It will be created" : "");
}
}
//if (add)
//{
// entryStation = new Model.PWS0Goods();
// entryStation.name = stationName;
// entityLogistic.PWS0Stations.Add(entryStation);
// entityLogistic.SaveChanges();
// return entryStation.Id;
//}
//else return null;
return(null);
}
else
{
return(station.Id);
}
}
}
private int?fnc_update(Dictionary <string, object> dic, string whereCondition)
{
string cmd = "";
int i;
object value;
for (i = 0; i <= dic.Count - 1; i++)
{
if (this.Columns[dic.ElementAt(i).Key] is htmlControl &&
!string.IsNullOrEmpty(((htmlControl)this.Columns[dic.ElementAt(i).Key]).prp_alternateColName))
{
//those columns which have alternate names should not be updated
//for example we have companyName ='microsoft' column which has alternatenames = 'micro soft'
//now we have 'micro soft' as value so we should not update companyName with 'micro soft'
continue;
}
if (this.Columns[dic.ElementAt(i).Key] is htmlControl &&
!((htmlControl)this.Columns[dic.ElementAt(i).Key]).prp_saveToDB)
{
//some columns like yes/no can be ignored and save as bit via computedcolumn
continue;
}
value = dic.ElementAt(i).Value;
if (Functions.IsNull(value))
{
cmd = cmd + dic.ElementAt(i).Key + "=" + " Null " + ",";
}
else if (Functions.fnc_isNumeric(value))
{
cmd = cmd + dic.ElementAt(i).Key + "=" + value.ToString() + ",";
}
else
{
cmd = cmd + dic.ElementAt(i).Key + "='" + value.ToString() + "',";
}
}
if (!string.IsNullOrEmpty(cmd))
{
cmd = cmd.Remove(cmd.Length - 1, 1);
}
cmd = " update " + this.TableName + " set " + cmd
+ " output inserted." + this.prp_columnIdName + (string.IsNullOrEmpty(whereCondition) ? "" : " where " + whereCondition);
using (var entity = new Model.logisticEntities())
{
try
{
int?id = entity.Database.SqlQuery <int?>(cmd).FirstOrDefault();
return(id);
}
catch (Exception ex)
{
Program.logs.Error("Error in fnc_update", ex);
//return null;
}
return(null);
}
}
public void readAndSaveBarnamehToDB(long barnameh_no, int cycleNumber)
{
try
{
Uri uri;
uri = new Uri(this.v_urlFindBillOfLading);
trainBillOfLadingsJsonModel[] trainBillOfLadingsListJson = null;
WebRequest webRequest = WebRequest.Create(uri);
webRequest.Proxy = null;
webRequest.Method = "POST";
webRequest.Headers.Add("Cache-Control", "no-cache");
webRequest.Headers.Add("Cookie", "__RequestVerificationToken=Gm4hoEFS8RkxaSfJxpaeorLztRy6-rfjyKm1pRyPYQP-4dGSPAKrHWG62K3vaJOz_k7xEJBWigJHetij4ID_TmbP-27KPhaINnSun-IMnZc1;");
webRequest.ContentType = "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW";
// "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW", "------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"__RequestVerificationToken\"\r\n\r\nGJKWN0U0ndGyC5fAKEdhhosJMhpjLmtfvNIieri7YR8Q37_BUn-lmEg6ucZPrWPefAcxG1-5TPMtYPZsa6fFIigJBBICLcfUlMrufrpIV6U1\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--"
string postData;
postData = "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"__RequestVerificationToken\"\r\n\r\nGJKWN0U0ndGyC5fAKEdhhosJMhpjLmtfvNIieri7YR8Q37_BUn-lmEg6ucZPrWPefAcxG1-5TPMtYPZsa6fFIigJBBICLcfUlMrufrpIV6U1\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW"
+ "\r\nContent-Disposition: form-data; name=\"barnameh_no\"\r\n\r\n" + barnameh_no.ToString() + "\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--";
byte[] formData = Encoding.UTF8.GetBytes(postData);
Stream streamRequest = webRequest.GetRequestStream();
streamRequest.Write(formData, 0, formData.Length);
streamRequest.Flush();
streamRequest.Close();
WebResponse webResponse = webRequest.GetResponse();
if (webResponse != null)
{
string result;
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream()))
{
result = rd.ReadToEnd();
}
webResponse.Close();
trainBillOfLadingsListJson = Newtonsoft.Json.JsonConvert.DeserializeObject <trainBillOfLadingsJsonModel[]>(result);
if (trainBillOfLadingsListJson != null)
{
using (var entityLogistic = new Model.logisticEntities())
{
foreach (trainBillOfLadingsJsonModel billOfLading in trainBillOfLadingsListJson)
{
if (billOfLading.Train_No.HasValue)
{
PWS0.trainBarryBillOfLadings bill = new trainBarryBillOfLadings();
bill.sb_saveToDB(billOfLading, billOfLading.Train_No.Value, null, cycleNumber, "findBariWagon");
}
}
}
}
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// Columns which should be comapred with parentRefcolumns
/// </summary>
public object fnc_getColumnValue(Dictionary <string, object> dicValues)
{
string whereCondition = this.fnc_getWhereCondition(dicValues);
using (var entity = new Model.logisticEntities())
{
var value = entity.Database.SqlQuery <int?>("select top 1 " + this.prp_parentIdColumnName + " from " + this.prp_parentTableName + " where " + whereCondition).FirstOrDefault();
return(value);
}
}
private void sb_saveGroupsToDB(wagonPartsGroupsDataTable dt, int?idGroupParent)
{
if (dt == null)
{
return;
}
int i;
bool add;
string groupName;
Model.rwmmsWagonPartsGroup entry_wagonPartsGroup;
using (var entityLogistic = new Model.logisticEntities())
{
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
add = false;
if (Functions.IsNull(dt.Rows[i][wagonPartsGroupsDataTable.fld_groupName]))
{
continue;
}
groupName = dt.Rows[i][wagonPartsGroupsDataTable.fld_groupName].ToString();
entry_wagonPartsGroup = entityLogistic.rwmmsWagonPartsGroups.FirstOrDefault(o => o.IdGroupParent == idGroupParent &&
o.wGroupName == groupName);
if (entry_wagonPartsGroup == null)
{
add = true;
entry_wagonPartsGroup = new Model.rwmmsWagonPartsGroup();
}
entry_wagonPartsGroup.FetchTime = DateTime.Now;
entry_wagonPartsGroup.IdGroupParent = idGroupParent;
entry_wagonPartsGroup.wGroupName = Functions.IsNull(dt.Rows[i][wagonPartsGroupsDataTable.fld_groupName]) ? null : dt.Rows[i][wagonPartsGroupsDataTable.fld_groupName].ToString();
entry_wagonPartsGroup.wPSID = Functions.IsNull(dt.Rows[i][wagonPartsGroupsDataTable.fld_psid]) ? null : dt.Rows[i][wagonPartsGroupsDataTable.fld_psid].ToString();
entry_wagonPartsGroup.wSerialNo = Functions.IsNull(dt.Rows[i][wagonPartsGroupsDataTable.fld_serialNo]) ? null : dt.Rows[i][wagonPartsGroupsDataTable.fld_serialNo].ToString().Replace(" ", "").Replace("\r\n", "");
if (add)
{
entityLogistic.rwmmsWagonPartsGroups.Add(entry_wagonPartsGroup);
}
else
{
entityLogistic.Entry(entry_wagonPartsGroup).State = System.Data.Entity.EntityState.Modified;
}
try
{
entityLogistic.SaveChanges();
dt.Rows[i][wagonPartsGroupsDataTable.fld_id] = entry_wagonPartsGroup.Id;
}
catch (Exception ex)
{
}
}
}
}
public void sb_readAndSaveCitiesToDB(int stateId, int?parentId)
{
try
{
Uri uri;
uri = new Uri(this.v_urlCity);
StateCityJsonModel[] cities = null;
WebRequest webRequest = WebRequest.Create(uri);
webRequest.Proxy = null;
webRequest.Method = "POST";
webRequest.Headers.Add("Cache-Control", "no-cache");
webRequest.Headers.Add("Cookie", "__RequestVerificationToken=Gm4hoEFS8RkxaSfJxpaeorLztRy6-rfjyKm1pRyPYQP-4dGSPAKrHWG62K3vaJOz_k7xEJBWigJHetij4ID_TmbP-27KPhaINnSun-IMnZc1;");
webRequest.ContentType = "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW";
// "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW", "------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"__RequestVerificationToken\"\r\n\r\nGJKWN0U0ndGyC5fAKEdhhosJMhpjLmtfvNIieri7YR8Q37_BUn-lmEg6ucZPrWPefAcxG1-5TPMtYPZsa6fFIigJBBICLcfUlMrufrpIV6U1\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--"
string postData;
postData = "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"ostanid\"\r\n\r\n" + stateId.ToString() + "\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--";
byte[] formData = Encoding.UTF8.GetBytes(postData);
Stream streamRequest = webRequest.GetRequestStream();
streamRequest.Write(formData, 0, formData.Length);
streamRequest.Flush();
streamRequest.Close();
WebResponse webResponse = webRequest.GetResponse();
if (webResponse != null)
{
string result;
using (StreamReader rd = new StreamReader(webResponse.GetResponseStream()))
{
result = rd.ReadToEnd();
}
webResponse.Close();
cities = Newtonsoft.Json.JsonConvert.DeserializeObject <StateCityJsonModel[]>(result);
if (cities != null)
{
using (var entityLogistic = new Model.logisticEntities())
{
foreach (StateCityJsonModel city in cities)
{
this.sb_saveCityToDB(city, stateId, parentId);
}
}
}
}
}
catch (Exception ex)
{
}
}
private void sb_saveOwnersDetailsToDB(DataTable dt, int cycleNumber)
{
if (dt == null)
{
return;
}
int i;
Model.rwmmsVehicleOwnersDetail entry_vehicleOwnersDetail;
bool add;
string meliNo;
using (var entityLogistic = new Model.logisticEntities())
{
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
add = false;
if (!Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo]))
{
meliNo = dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo].ToString();
entry_vehicleOwnersDetail = entityLogistic.rwmmsVehicleOwnersDetails.FirstOrDefault(o => o.wMeliNo == meliNo);
if (entry_vehicleOwnersDetail == null)
{
add = true;
entry_vehicleOwnersDetail = new Model.rwmmsVehicleOwnersDetail();
}
}
else
{
entry_vehicleOwnersDetail = new Model.rwmmsVehicleOwnersDetail();
add = true;
}
//entry_vehicleOwnersDetail.companyId = companyId;
entry_vehicleOwnersDetail.CycleNumber = cycleNumber;
entry_vehicleOwnersDetail.FetchTime = DateTime.Now;
entry_vehicleOwnersDetail.Source = "rwmms";
entry_vehicleOwnersDetail.wEmail = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_email]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_email].ToString();
entry_vehicleOwnersDetail.wFName = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_fname]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_fname].ToString();
entry_vehicleOwnersDetail.wLName = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_lname]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_lname].ToString();
entry_vehicleOwnersDetail.wMeliNo = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo].ToString();
entry_vehicleOwnersDetail.wMobileNumber = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_mobileNumber]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_mobileNumber].ToString();
if (add)
{
entityLogistic.rwmmsVehicleOwnersDetails.Add(entry_vehicleOwnersDetail);
}
else
{
entityLogistic.Entry(entry_vehicleOwnersDetail).State = System.Data.Entity.EntityState.Modified;
}
entityLogistic.SaveChanges();
}
}
}
private int?fnc_insert(Dictionary <string, object> dic)
{
string columnNames = "";
string columnValues = "";
string cmd;
int i;
object value;
for (i = 0; i <= dic.Count - 1; i++)
{
if (this.Columns[dic.ElementAt(i).Key] is htmlControl &&
!((htmlControl)this.Columns[dic.ElementAt(i).Key]).prp_saveToDB)
{
//some columns like yes/no can be ignored and save as bit via computedcolumn
continue;
}
value = dic.ElementAt(i).Value;
if (Functions.IsNull(value))
{
columnValues = columnValues + " Null " + ",";
}
else if (Functions.fnc_isNumeric(value))
{
columnValues = columnValues + value + ",";
}
else
{
columnValues = columnValues + "'" + value + "',";
}
columnNames = columnNames + dic.ElementAt(i).Key + ",";
}
if (!string.IsNullOrEmpty(columnNames))
{
columnNames = columnNames.Remove(columnNames.Length - 1, 1);
columnValues = columnValues.Remove(columnValues.Length - 1, 1);
}
cmd = " insert into " + this.TableName + "(" + columnNames + ")" + " OUTPUT inserted." + this.prp_columnIdName + " values(" + columnValues + ")";
using (var entity = new Model.logisticEntities())
{
try
{
int?id = entity.Database.SqlQuery <int?>(cmd).FirstOrDefault();
return(id);
}
catch (Exception ex)
{
Program.logs.Error("Error in fnc_insert", ex);
}
return(null);
}
}
public static int?fnc_getTrainIdFromDB(int train_no, DateTime?enteranceDateTime)
{
using (var entityLogistic = new Model.logisticEntities())
{
var entryTrainBarry = entityLogistic.PWS0TrainsBarry.FirstOrDefault(o => o.jTrain_No == train_no &&
o.jEntrance_DateTime == enteranceDateTime);
if (entryTrainBarry == null)
{
return(null);
}
return(entryTrainBarry.Id);
}
}
public Grabber()
{
int?temp;
using (var entityLogistic = new Model.logisticEntities())
{
DateTime dateTime = DateTime.Now.Date;
temp = entityLogistic.PWS0BillOfLadings.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber);
this.v_cyleNumberBillOfLadings = (temp.HasValue ? temp.Value : 0) + 1;
temp = entityLogistic.PWS0TrainsBarry.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber);
this.v_cyleNumberTrainsBarry = (temp.HasValue ? temp.Value : 0) + 1;
temp = entityLogistic.PWS0TrainsPassengers.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber);
this.v_cyleNumberTrainsPassenger = (temp.HasValue ? temp.Value : 0) + 1;
}
}
public bool fnc_insert(Dictionary <string, object> dic)
{
string columnNames = "";
string columnValues = "";
string cmd;
int i;
object value;
for (i = 0; i <= dic.Count - 1; i++)
{
value = dic.ElementAt(i).Value;
if (Functions.IsNull(value))
{
columnValues = columnValues + " Null " + ",";
}
else if (Functions.fnc_isNumeric(value))
{
columnValues = columnValues + value + ",";
}
else
{
columnValues = columnValues + "'" + value + "',";
}
columnNames = columnNames + dic.ElementAt(i).Key + ",";
}
if (!string.IsNullOrEmpty(columnNames))
{
columnNames = columnNames.Remove(columnNames.Length - 1, 1);
columnValues = columnValues.Remove(columnValues.Length - 1, 1);
}
cmd = " insert into " + this.TableName + "(" + columnNames + ")values(" + columnValues + ")";
using (var entity = new Model.logisticEntities())
{
try
{
entity.Database.ExecuteSqlCommand(cmd);
return(true);
}
catch (Exception ex)
{
Program.logs.Error("Error in fnc_insert", ex);
return(false);
}
}
}
public static int?Fnc_getVehicleOwnerId(string ownerName)
{
if (string.IsNullOrEmpty(ownerName))
{
return(null);
}
using (var entityLogistic = new Model.logisticEntities())
{
var entry_vehicleOwner = entityLogistic.rwmmsVehicleOwners.FirstOrDefault(o => o.companyName == ownerName ||
o.AlternateNames.Contains(ownerName + ";"));
if (entry_vehicleOwner == null)
{
return(null);
}
else
{
return(entry_vehicleOwner.Id);
}
}
}
public bool fnc_update(Dictionary <string, object> dic, string whereCondition)
{
string cmd = "";
int i;
object value;
for (i = 0; i <= dic.Count - 1; i++)
{
value = dic.ElementAt(i).Value;
if (Functions.IsNull(value))
{
cmd = cmd + dic.ElementAt(i).Key + "=" + " Null " + ",";
}
else if (Functions.fnc_isNumeric(value))
{
cmd = cmd + dic.ElementAt(i).Key + "=" + value.ToString() + ",";
}
else
{
cmd = cmd + dic.ElementAt(i).Key + "='" + value.ToString() + "',";
}
}
if (!string.IsNullOrEmpty(cmd))
{
cmd = cmd.Remove(cmd.Length - 1, 1);
}
cmd = " update " + this.TableName + " set " + cmd + " where " + whereCondition;
using (var entity = new Model.logisticEntities())
{
try
{
entity.Database.ExecuteSqlCommand(cmd);
return(true);
}
catch (Exception ex)
{
Program.logs.Error("Error in fnc_update", ex);
return(false);
}
}
}
public static int?fnc_getGoodsId(string goodsName, bool add, bool notifNotExist)
{
if (string.IsNullOrEmpty(goodsName))
{
return(null);
}
if (goodsName == "واگن بدون بار")
{
return(-1);
}
using (var entityLogistic = new Model.logisticEntities())
{
var entryGoods = entityLogistic.PWS0Goods.FirstOrDefault(o => o.goodsName == goodsName);
if (entryGoods == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "goodsName = " + goodsName + " does not exist in PWS0Goods table." + (add ? "? It will be created" : "");
}
if (add)
{
entryGoods = new Model.PWS0Goods();
entryGoods.goodsName = goodsName;
entityLogistic.PWS0Goods.Add(entryGoods);
entityLogistic.SaveChanges();
return(entryGoods.Id);
}
else
{
return(null);
}
}
else
{
return(entryGoods.Id);
}
}
}
public bool fnc_save(System.Collections.ObjectModel.ReadOnlyCollection <IWebElement> items)
{
int i;
string whereCondition = "";
Dictionary <string, object> dic;
bool retVal = true;
for (i = prp_skipRowTop; i <= items.Count - 1 - prp_skipRowBottom; i++)
{
if (this.prp_skipRowIndecies != null && this.prp_skipRowIndecies.Contains(i))
{
continue;
}
whereCondition = this.fnc_getWhereCondition(items[i]);
dic = this.fnc_getColumnsValue(items[i]);
using (var entity = new Model.logisticEntities())
{
var exists = entity.Database.SqlQuery <int?>("select top 1 1 from " + this.TableName + " where " + whereCondition).FirstOrDefault();
if (exists.HasValue)
{
if (!this.fnc_update(dic, whereCondition))
{
retVal = false;
}
}
else
{
if (!this.fnc_insert(dic))
{
retVal = false;
}
}
}
}
return(retVal);
}
/// <summary>
///
/// </summary>
/// <param name="cityJson"></param>
/// <param name="parentIdInDB">refer to Id which is saved automatically in db</param>
/// <param name="parentStateIdInJson">refer to stateId which comes from JSON</param>
private void sb_saveCityToDB(StateCityJsonModel cityJson, int parentStateIdInJson, int?parentIdInDB)
{
using (var entityLogistic = new Model.logisticEntities())
{
if (!parentIdInDB.HasValue)
{
var entryState = entityLogistic.PWS0StateCities.FirstOrDefault(o => o.ParentStateIdInJson == parentStateIdInJson && (o.isState.HasValue && o.isState.Value));
if (entryState != null)
{
parentIdInDB = entryState.Id;
}
}
bool add = false;
Model.PWS0StateCities entryPWS0City = entityLogistic.PWS0StateCities.FirstOrDefault(o => o.CityId == cityJson.CityID &&
(!o.isState.HasValue || !o.isState.Value));
if (entryPWS0City == null)
{
add = true;
entryPWS0City = new Model.PWS0StateCities();
}
entryPWS0City.CityId = cityJson.CityID;
entryPWS0City.CityName = cityJson.CityName;
entryPWS0City.isState = false;
entryPWS0City.ParentIdInDB = parentIdInDB;
entryPWS0City.ParentStateIdInJson = parentStateIdInJson;
entryPWS0City.StateId = null;
entryPWS0City.StateName = null;
if (add)
{
entityLogistic.PWS0StateCities.Add(entryPWS0City);
}
entityLogistic.SaveChanges();
}
}
public static int?fnc_getWagonTypeName(string wagonTypeName, bool add, bool notifNotExist)
{
if (string.IsNullOrEmpty(wagonTypeName))
{
return(null);
}
using (var entityLogistic = new Model.logisticEntities())
{
var entryWagonType = entityLogistic.WagonsTypes.FirstOrDefault(o => o.typeName == wagonTypeName.ToString() ||
o.alternateNames.Contains(wagonTypeName + ";"));
if (entryWagonType == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "WagonTypeName = " + wagonTypeName + " does not exist in WagonsType table." + (add ? "? It will be created" : "");
}
if (add)
{
entryWagonType = new Model.WagonsType();
entryWagonType.typeName = wagonTypeName;
entityLogistic.WagonsTypes.Add(entryWagonType);
entityLogistic.SaveChanges();
return(entryWagonType.Id);
}
else
{
return(null);
}
}
else
{
return(entryWagonType.Id);
}
}
}
private void sb_saveStateToDB(StateCityJsonModel stateJson, bool saveCitiesForEachState)
{
using (var entityLogistic = new Model.logisticEntities())
{
bool add = false;
Model.PWS0StateCities entryPWS0State = entityLogistic.PWS0StateCities.FirstOrDefault(o => o.StateId == stateJson.StateID &&
o.isState.HasValue && o.isState.Value);
if (entryPWS0State == null)
{
add = true;
entryPWS0State = new Model.PWS0StateCities();
}
entryPWS0State.CityId = null;
entryPWS0State.CityName = null;
entryPWS0State.isState = true;
entryPWS0State.ParentIdInDB = null;
entryPWS0State.ParentStateIdInJson = null;
entryPWS0State.StateId = stateJson.StateID;
entryPWS0State.StateName = stateJson.StateName;
if (add)
{
entityLogistic.PWS0StateCities.Add(entryPWS0State);
}
entityLogistic.SaveChanges();
//to get id of stationid
int parentIdInDB = entryPWS0State.Id;
if (saveCitiesForEachState && stateJson.StateID.HasValue)
{
this.sb_readAndSaveCitiesToDB(stateJson.StateID.Value, parentIdInDB);
}
}
}
public static int?fnc_getAreaId(string areaName, bool add, bool notifNotExist)
{
if (string.IsNullOrEmpty(areaName))
{
return(null);
}
//if (areaName == "واگن بدون بار") return -1;
using (var entityLogistic = new Model.logisticEntities())
{
var entryArea = entityLogistic.Areas.FirstOrDefault(o => o.areaName == areaName);
if (entryArea == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "areaName = " + areaName + " does not exist in Areas table." + (add ? "? It will be created" : "");
}
if (add)
{
entryArea = new Model.Area();
entryArea.areaName = areaName;
entityLogistic.Areas.Add(entryArea);
entityLogistic.SaveChanges();
return(entryArea.Id);
}
else
{
return(null);
}
}
else
{
return(entryArea.Id);
}
}
}
public void sb_readAndSaveToDB(bool loginAndLogout, bool getAttach)
{
if (loginAndLogout)
{
login lg = new login();
lg.fnc_logoutWithSelenium(this.v_webBrowser);
if (login.fnc_isLoginPage(this.v_webBrowser.Url, this.v_url))
{
lg.fnc_loginWithSelenium(this.v_webBrowser);
this.v_webBrowser.Navigate().GoToUrl(this.v_url);
SharedFunctions.sb_waitForReady(this.v_webBrowser);
}
}
int pageIndex = 1;
int rowIndex;
string html;
using (var entityLogistic = new Model.logisticEntities())
{
for (pageIndex = 1; pageIndex <= this.v_pageCount; pageIndex++)
{
Program.logs.Info("Start of :" + pageIndex);
//if we should get extraDetail we should logout and then login again
if (pageIndex > 1)
{
pageIndex = seleniumDownloader.fnc_gotoPage(this.v_webBrowser, this.v_url, this.v_tableId, pageIndex, this.v_pageCount, false);
if (pageIndex == -1)
{
return;
}
}
html = this.v_webBrowser.PageSource;
if (!string.IsNullOrEmpty(html))
{
this.v_dt.Rows.Clear();
Functions.sb_fillDatatableWithHtmlTableId(html, v_tableId, this.v_dt);
this.sb_fillDatatablePSID(html, v_tableId, 2, this.v_dt);
if (this.v_dt.Rows.Count > 0)
{
this.sb_saveGroupsToDB(this.v_dt, null);
}
}
else
{
break;
}
try
{
int groupId;
for (rowIndex = 0; rowIndex <= this.v_dt.Rows.Count - 1; rowIndex++)
{
if (Functions.IsNull(this.v_dt.Rows[rowIndex][wagonPartsGroupsDataTable.fld_id]))
{
continue;
}
groupId = int.Parse(this.v_dt.Rows[rowIndex][wagonPartsGroupsDataTable.fld_id].ToString());
var el = this.v_webBrowser.FindElement(By.Id(this.v_tableId));
var rows = el.FindElements(By.TagName("tr"));
var cells = rows[rowIndex + this.v_dt.prp_skipRowTop].FindElements(By.TagName("td"));
cells[2].Click();
SharedFunctions.sb_waitForReady(this.v_webBrowser);
var queryString = HttpUtility.ParseQueryString(this.v_webBrowser.Url);
if (!Functions.IsNull(queryString["psid"]))
{
var entryPartGroup = entityLogistic.rwmmsWagonPartsGroups.FirstOrDefault(o => o.Id == groupId);
if (entryPartGroup != null)
{
entryPartGroup.wPSID = queryString["psid"];
entityLogistic.SaveChanges();
}
}
this.sb_readAndSavePartsToDB(groupId, this.v_dt.Rows[rowIndex][wagonPartsGroupsDataTable.fld_groupName].ToString(), getAttach
, this.v_downloadPath);
this.sb_readAndSaveSubGroupsToDB(groupId, getAttach, this.v_downloadPath + (this.v_downloadPath.EndsWith("\\") ? "" : "\\") + this.v_dt.Rows[rowIndex][wagonPartsGroupsDataTable.fld_groupName].ToString());
var elPath = this.v_webBrowser.FindElement(By.Id(this.v_pathElementId));
var hrefCollection = elPath.FindElements(By.TagName("a"));
if (hrefCollection != null && hrefCollection.Count > 0)
{
hrefCollection[hrefCollection.Count - 1].Click();
SharedFunctions.sb_waitForReady(this.v_webBrowser);
}
}
}
catch (Exception ex)
{
}
Program.logs.Info("End of :" + pageIndex);
}
}
}
private void sb_saveToDB(DataTable dt, int cycleNumber)
{
if (dt == null)
{
return;
}
int i;
string solarDate;
int? solarTime;
DateTime?enteranceDateTime;
Model.raiWagon_Info_Tracking entry_raiWagon_Info_Tracking;
using (var entityLogistic = new Model.logisticEntities())
{
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
entry_raiWagon_Info_Tracking = new Model.raiWagon_Info_Tracking();
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName]))
{
entry_raiWagon_Info_Tracking.currentStationId = PWS0.stations.fnc_getStationId(null, dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName].ToString(), true);
}
entry_raiWagon_Info_Tracking.CycleNumber = cycleNumber;
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName]))
{
entry_raiWagon_Info_Tracking.destinationStationId = PWS0.stations.fnc_getStationId(null, dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName].ToString(), true);
}
#region enteranceDate
solarDate = null;
solarTime = null;
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceDate] != null))
{
var solarDateArr = dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceDate].ToString().Split('/');
Array.Reverse(solarDateArr);
solarDate = string.Join("", solarDateArr);
solarDate = solarDate.Replace("/", "");
}
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceTime]))
{
solarTime = int.Parse(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceTime].ToString().Replace(":", ""));
}
entry_raiWagon_Info_Tracking.enteranceDateTime = enteranceDateTime = Functions.fnc_convertSolarDateAndTimeToDateTime(solarDate, solarTime);;
#endregion
entry_raiWagon_Info_Tracking.exitDateTime = null;
entry_raiWagon_Info_Tracking.FetchTime = DateTime.Now;
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_barType]))
{
entry_raiWagon_Info_Tracking.goodsID = PWS0.goods.fnc_getGoodsId(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_barType].ToString()
, false, true);
}
entry_raiWagon_Info_Tracking.Source = "History";
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName]))
{
entry_raiWagon_Info_Tracking.sourceStationId = PWS0.stations.fnc_getStationId(null, dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName].ToString(), true);
}
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo]))
{
entry_raiWagon_Info_Tracking.trainId = PWS0.trainBarry.fnc_getTrainIdFromDB(int.Parse(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo].ToString()), enteranceDateTime);
}
if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo]))
{
entry_raiWagon_Info_Tracking.wagonId = PWS0.trainBarryWagons.fnc_getWagonIdCheckWithControlNo(long.Parse(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo].ToString()), true);
}
entry_raiWagon_Info_Tracking.wAreaName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_areaName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_areaName].ToString());
entry_raiWagon_Info_Tracking.wBarType = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_barType]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_barType].ToString());
entry_raiWagon_Info_Tracking.wBillOfLadingNo = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo]) ? null : (long?)long.Parse(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo].ToString()));
entry_raiWagon_Info_Tracking.wCurrentStationName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName].ToString());
entry_raiWagon_Info_Tracking.wDestinationStationName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName].ToString());
entry_raiWagon_Info_Tracking.wDistance = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_distance]) ? null : (int?)int.Parse(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_distance].ToString()));
entry_raiWagon_Info_Tracking.wEnteranceDate = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceDate]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceDate].ToString());
entry_raiWagon_Info_Tracking.wEnteranceTime = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceTime]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_enteranceTime].ToString());
entry_raiWagon_Info_Tracking.wExitDate = null;
entry_raiWagon_Info_Tracking.wExitTime = null;
entry_raiWagon_Info_Tracking.wRowNo = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_rowNo]) ? null : (int?)int.Parse(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_rowNo].ToString()));
entry_raiWagon_Info_Tracking.wSourceStationName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName].ToString());
entry_raiWagon_Info_Tracking.wTrainDestinationStationName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainDestinationStationName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainDestinationStationName].ToString());
entry_raiWagon_Info_Tracking.wTrainNo = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo]) ? null : (int?)int.Parse(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo].ToString()));
entry_raiWagon_Info_Tracking.wTrainSourceStationName = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainSourceStationName]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainSourceStationName].ToString());
entry_raiWagon_Info_Tracking.wWagonNo = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo]) ? null : (long?)long.Parse(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo].ToString()));
entityLogistic.raiWagon_Info_Tracking.Add(entry_raiWagon_Info_Tracking);
entityLogistic.SaveChanges();
}
}
}
private void sb_readExtraDetailAndSaveToDB(int cycleNumber, int pageIndex)
{
int rowIndex = 1;
string htmlEditPage;
nextRecord : pageIndex = this.fnc_gotoPage(pageIndex, true);
if (pageIndex == -1)
{
return;
}
var table = this.v_webBrowser.FindElementById(v_tableId);
if (table != null)
{
var rows = table.FindElements(By.TagName("tr"));
if (rows != null && rows.Count > 0 && rowIndex <= rows.Count - 2)
{//first and last row are header and footer
using (var entityLogistic = new Model.logisticEntities())
{
var columns = rows[rowIndex].FindElements(By.TagName("td"));
if (columns.Count >= 6)
{
var href = columns[6].FindElement(By.TagName("a"));
if (href != null)
{
href.Click();
SharedFunctions.sb_waitForReady(this.v_webBrowser);
htmlEditPage = this.v_webBrowser.PageSource;
string firstName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtFirstName");
string lastName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtLastName");
string fatherName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtFatherName");
string certNo = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtIdentityNumber");
string registerCity = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtIdentityRegisterLocation");
string meliNo = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtNationalCode");
string postalCode = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentPostCode");
string email = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentEmail");
string mobileNumber = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtMobileNumber");
string birthDate = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtBirthDate");
string address = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentAddress");
if (!string.IsNullOrEmpty(meliNo))
{
var entryOwnerExtraDetail = entityLogistic.rwmmsVehicleOwnersDetails.FirstOrDefault(o => o.wMeliNo == meliNo);
if (entryOwnerExtraDetail != null)
{
//entryOwnerExtraDetail.companyId
entryOwnerExtraDetail.CycleNumber = cycleNumber;
entryOwnerExtraDetail.FetchTime = DateTime.Now;
entryOwnerExtraDetail.Source = "http://rwmms.rai.ir/VehicleOwnerDetailInfo.aspx";
entryOwnerExtraDetail.wAddress = (Functions.IsNull(address) ? null : address);
entryOwnerExtraDetail.wBirthDate = (Functions.IsNull(birthDate) ? null : birthDate);
entryOwnerExtraDetail.wCertNo = (Functions.IsNull(certNo) ? null : certNo);
entryOwnerExtraDetail.wEmail = (Functions.IsNull(email) ? null : email);
entryOwnerExtraDetail.wFatherName = (Functions.IsNull(fatherName) ? null : fatherName);
entryOwnerExtraDetail.wFName = (Functions.IsNull(firstName) ? null : firstName);
entryOwnerExtraDetail.wLName = (Functions.IsNull(lastName) ? null : lastName);
entryOwnerExtraDetail.wMeliNo = (Functions.IsNull(meliNo) ? null : meliNo);
entryOwnerExtraDetail.wMobileNumber = (Functions.IsNull(mobileNumber) ? null : mobileNumber);
entryOwnerExtraDetail.wPostalCode = (Functions.IsNull(postalCode) ? null : postalCode);
entryOwnerExtraDetail.wRegisterCity = (Functions.IsNull(registerCity) ? null : registerCity);
entityLogistic.Entry(entryOwnerExtraDetail).State = System.Data.Entity.EntityState.Modified;
entityLogistic.SaveChanges();
}
}
rowIndex++;
goto nextRecord;
}
}
}
}
}
}
