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 entityLogestic = new logisticEntities()) { foreach (StateCityJsonModel state in statesJson) { this.sb_saveStateToDB(state, saveCitiesForEachState); } } } } } catch (Exception ex) { } }
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 entityLogestic = new 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 entityLogestic = new logisticEntities()) { var entryBillOfLading = entityLogestic.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 Wagon(); // entryWagon.wagonNo = wagonNo; // entityLogestic.Wagons.Add(entryWagon); // entityLogestic.SaveChanges(); // return entryWagon.Id; //} //else return null; return(null); } else { return(entryBillOfLading.Id); } } }
public static int?fnc_getWagonIdCheckWithControlNo(long?wagonNo /*,bool add*/, bool notifNotExist) { if (!wagonNo.HasValue) { return(null); } using (var entityLogestic = new logisticEntities()) { var entryWagon = entityLogestic.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 Wagon(); // entryWagon.wagonNo = wagonNo; // entityLogestic.Wagons.Add(entryWagon); // entityLogestic.SaveChanges(); // return entryWagon.Id; //} //else return null; return(null); } else { return(entryWagon.Id); } } }
public void sb_saveToDB(trainBillOfLadingsJsonModel billOfLading, int train_no, int?trainId, int cycleNumber, string fetchUrl) { bool add = false; using (var entityLogestic = new logisticEntities()) { PWS0BillOfLadings entryPWS0BillOfLading = entityLogestic.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 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) { entityLogestic.PWS0BillOfLadings.Add(entryPWS0BillOfLading); } entityLogestic.SaveChanges(); } catch (Exception ex) { } } }
public static int?fnc_getStationId(int?stationCode, string stationName, bool notifNotExist) { if (!stationCode.HasValue && string.IsNullOrEmpty(stationName)) { return(null); } using (var entityLogestic = new logisticEntities()) { PWS0Stations station; if (stationCode.HasValue) { station = entityLogestic.PWS0Stations.FirstOrDefault(o => o.stcode == stationCode); } else { station = entityLogestic.PWS0Stations.FirstOrDefault(o => o.name == stationName); if (station == null) { station = entityLogestic.PWS0Stations.FirstOrDefault(o => o.name2 == stationName); if (station == null) { station = entityLogestic.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 PWS0Goods(); // entryStation.name = stationName; // entityLogestic.PWS0Stations.Add(entryStation); // entityLogestic.SaveChanges(); // return entryStation.Id; //} //else return null; return(null); } else { return(station.Id); } } }
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 entityLogestic = new 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) { } }
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 entityLogestic = new logisticEntities()) { foreach (StateCityJsonModel city in cities) { this.sb_saveCityToDB(city, stateId, parentId); } } } } } catch (Exception ex) { } }
public static int?fnc_getTrainIdFromDB(int train_no, DateTime?enteranceDateTime) { using (var entityLogestic = new logisticEntities()) { var entryTrainBarry = entityLogestic.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 entityLogestic = new logisticEntities()) { DateTime dateTime = DateTime.Now.Date; temp = entityLogestic.PWS0BillOfLadings.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber); this.v_cyleNumberBillOfLadings = (temp.HasValue ? temp.Value : 0) + 1; temp = entityLogestic.PWS0TrainsBarry.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber); this.v_cyleNumberTrainsBarry = (temp.HasValue ? temp.Value : 0) + 1; temp = entityLogestic.PWS0TrainsPassengers.Where(o => DbFunctions.TruncateTime(o.FetchTime) == dateTime).Max(o => o.CycleNumber); this.v_cyleNumberTrainsPassenger = (temp.HasValue ? temp.Value : 0) + 1; } }
public static int?fnc_getGoodsId(string goodsName, bool add, bool notifNotExist) { if (string.IsNullOrEmpty(goodsName)) { return(null); } if (goodsName == "واگن بدون بار") { return(-1); } using (var entityLogestic = new logisticEntities()) { var entryGoods = entityLogestic.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 PWS0Goods(); entryGoods.goodsName = goodsName; entityLogestic.PWS0Goods.Add(entryGoods); entityLogestic.SaveChanges(); return(entryGoods.Id); } else { return(null); } } else { return(entryGoods.Id); } } }
public static int?fnc_getWagonTypeName(string wagonTypeName, bool add, bool notifNotExist) { if (string.IsNullOrEmpty(wagonTypeName)) { return(null); } using (var entityLogestic = new logisticEntities()) { var entryWagonType = entityLogestic.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 WagonsType(); entryWagonType.typeName = wagonTypeName; entityLogestic.WagonsTypes.Add(entryWagonType); entityLogestic.SaveChanges(); return(entryWagonType.Id); } else { return(null); } } else { return(entryWagonType.Id); } } }
public static int?fnc_getAreaId(string areaName, bool add, bool notifNotExist) { if (string.IsNullOrEmpty(areaName)) { return(null); } //if (areaName == "واگن بدون بار") return -1; using (var entityLogestic = new logisticEntities()) { var entryArea = entityLogestic.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 Area(); entryArea.areaName = areaName; entityLogestic.Areas.Add(entryArea); entityLogestic.SaveChanges(); return(entryArea.Id); } else { return(null); } } else { return(entryArea.Id); } } }
private void sb_saveStateToDB(StateCityJsonModel stateJson, bool saveCitiesForEachState) { using (var entityLogestic = new logisticEntities()) { bool add = false; PWS0StateCities entryPWS0State = entityLogestic.PWS0StateCities.FirstOrDefault(o => o.StateId == stateJson.StateID && o.isState.HasValue && o.isState.Value); if (entryPWS0State == null) { add = true; entryPWS0State = new 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) { entityLogestic.PWS0StateCities.Add(entryPWS0State); } entityLogestic.SaveChanges(); //to get id of stationid int parentIdInDB = entryPWS0State.Id; if (saveCitiesForEachState && stateJson.StateID.HasValue) { this.sb_readAndSaveCitiesToDB(stateJson.StateID.Value, parentIdInDB); } } }
/// <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 entityLogestic = new logisticEntities()) { if (!parentIdInDB.HasValue) { var entryState = entityLogestic.PWS0StateCities.FirstOrDefault(o => o.ParentStateIdInJson == parentStateIdInJson && (o.isState.HasValue && o.isState.Value)); if (entryState != null) { parentIdInDB = entryState.Id; } } bool add = false; PWS0StateCities entryPWS0City = entityLogestic.PWS0StateCities.FirstOrDefault(o => o.CityId == cityJson.CityID && (!o.isState.HasValue || !o.isState.Value)); if (entryPWS0City == null) { add = true; entryPWS0City = new 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) { entityLogestic.PWS0StateCities.Add(entryPWS0City); } entityLogestic.SaveChanges(); } }
public bool readAndSaveWagonToDB(long wagonNo, string solarDateFrom, string solarDateTo, int cycleNumber) { SharedVariables.logs.Info("Start Fetch " + wagonNo + " from " + solarDateFrom + " to " + solarDateTo); using (var entityLogistics = new logisticEntities()) { customersHistoryFetchLog entryCustomersHistoryFetchLog = new customersHistoryFetchLog(); entryCustomersHistoryFetchLog.endDate = solarDateTo; entryCustomersHistoryFetchLog.fetchTimeEnd = null; entryCustomersHistoryFetchLog.fetchTimeStart = DateTime.Now; entryCustomersHistoryFetchLog.startDate = solarDateFrom; entryCustomersHistoryFetchLog.state = 0; entryCustomersHistoryFetchLog.wagonNo = wagonNo.ToString(); entityLogistics.customersHistoryFetchLogs.Add(entryCustomersHistoryFetchLog); entityLogistics.SaveChanges(); wagonInfoTrackingDetail wagonDetail = new wagonInfoTrackingDetail(); try { DateTime dateFrom, dateTo; dateFrom = DateTime.MinValue; dateTo = DateTime.MaxValue; try { dateFrom = Functions.solarToMiladi(solarDateFrom); } catch (Exception ex) { SharedVariables.logs.Error("wagonInfoSeirHistory.readAndSaveWagonToDB.solarToMiladi,solarDateFrom", ex); entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } if (solarDateFrom.Length == 10) { solarDateFrom = solarDateFrom.Remove(0, 2); } solarDateFrom = solarDateFrom.Replace("/", ""); try { dateTo = Functions.solarToMiladi(solarDateTo); } catch (Exception ex) { SharedVariables.logs.Error("wagonInfoSeirHistory.readAndSaveWagonToDB.solarToMiladi,solarDateTo", ex); entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } if (solarDateTo.Length == 10) { solarDateTo = solarDateTo.Remove(0, 2); } solarDateTo = solarDateTo.Replace("/", ""); if (dateFrom > dateTo) { SharedVariables.logs.Error("wagonInfoSeirHistory.readAndSaveWagonToDB.solarToMiladi, SolarDateFrom should be lower than SolarDateTo"); entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } login lg = new login(); start: if (login.v_cookieCollection == null) { if (!lg.fnc_login()) { //cannot login entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } } Uri uri; uri = new Uri(this.v_url); string postData; int pageNumber = 1; wagonInfoSeirHistoryDataTable dt = new wagonInfoSeirHistoryDataTable(); 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(); SharedVariables.logs.Info(postData); 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(); entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } 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(); entryCustomersHistoryFetchLog.state = -1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(false); } } string result; using (StreamReader rd = new StreamReader(webResponse.GetResponseStream(), Encoding.GetEncoding("windows-1256"))) { result = rd.ReadToEnd(); } webResponse.Close(); if (!string.IsNullOrEmpty(result)) { dt.Rows.Clear(); Functions.sb_fillDatatableWithHtmlTableId(result, "AutoNumber2", 2, 0, 0, 0, dt); if (dt.Rows.Count > 0) { this.sb_saveToDB(dt, cycleNumber); } } } pageNumber++; } while (dt.Rows.Count > 0); SharedVariables.logs.Info("End Fetch " + wagonNo + " from " + solarDateFrom + " to " + solarDateTo); entryCustomersHistoryFetchLog.state = 1; entryCustomersHistoryFetchLog.fetchTimeEnd = DateTime.Now; entityLogistics.SaveChanges(); return(true); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { SharedVariables.logs.Error("wagonInfoSeirHistory.readAndSaveWagonToDB.finalException Entity of type \"" + eve.Entry.Entity.GetType().Name + "\" in state \"" + eve.Entry.State + "\" has the following validation errors:"); foreach (var ve in eve.ValidationErrors) { SharedVariables.logs.Error("- Property: \"" + ve.PropertyName + "\", Error: \"" + ve.ErrorMessage + "\""); } } return(false); } catch (Exception ex) { SharedVariables.logs.Error("wagonInfoSeirHistory.readAndSaveWagonToDB.finalException", ex); return(false); } } }
public void sb_saveToDB() { using (var entityLogestic = new logisticEntities()) { bool add = false; PWS0Stations entryPWS0Station = entityLogestic.PWS0Stations.FirstOrDefault(o => o.stcode == this.properties.stcode && o.name == this.properties.name && o.name2 == this.properties.name2 && o.areaid == this.properties.areaid && o.cityid == this.properties.cityid && o.cityname == this.properties.cityname && o.statename == this.properties.statename && o.stateid == this.properties.stateid); if (entryPWS0Station == null) { add = true; entryPWS0Station = new PWS0Stations(); } entryPWS0Station.lat = this.properties.lat; entryPWS0Station.lon = this.properties.lon; entryPWS0Station.alt = this.properties.alt; entryPWS0Station.name = this.properties.name; entryPWS0Station.name2 = this.properties.name2; entryPWS0Station.stcode = this.properties.stcode; entryPWS0Station.bus = this.properties.bus; entryPWS0Station.metro = this.properties.metro; entryPWS0Station.taxi = this.properties.taxi; entryPWS0Station.other = this.properties.other; entryPWS0Station.cellOffice = this.properties.cellOffice; entryPWS0Station.parkingtim = this.properties.parkingtim; entryPWS0Station.sakohamlkh = this.properties.sakohamlkh; entryPWS0Station.daftarforo = this.properties.daftarforo; entryPWS0Station.kioskkhari = this.properties.kioskkhari; entryPWS0Station.khodpardaz = this.properties.khodpardaz; entryPWS0Station.telephonom = this.properties.telephonom; entryPWS0Station.internetbi = this.properties.internetbi; entryPWS0Station.balabar = this.properties.balabar; entryPWS0Station.ramp = this.properties.ramp; entryPWS0Station.postbehdas = this.properties.postbehdas; entryPWS0Station.ambolans = this.properties.ambolans; entryPWS0Station.vilcher = this.properties.vilcher; entryPWS0Station.masirnabin = this.properties.masirnabin; entryPWS0Station.amanatketa = this.properties.amanatketa; entryPWS0Station.tanaqolat = this.properties.tanaqolat; entryPWS0Station.soqat = this.properties.soqat; entryPWS0Station.mobile = this.properties.mobile; entryPWS0Station.sanayedast = this.properties.sanayedast; entryPWS0Station.reservhote = this.properties.reservhote; entryPWS0Station.irani = this.properties.irani; entryPWS0Station.farangi = this.properties.farangi; entryPWS0Station.bajetahvil = this.properties.bajetahvil; entryPWS0Station.salonentez = this.properties.salonentez; entryPWS0Station.salontashr = this.properties.salontashr; entryPWS0Station.namazkhone = this.properties.namazkhone; entryPWS0Station.restoran = this.properties.restoran; entryPWS0Station.vahedetela = this.properties.vahedetela; entryPWS0Station.ashia = this.properties.ashia; entryPWS0Station.sandoq = this.properties.sandoq; entryPWS0Station.saatkaranb = this.properties.saatkaranb; entryPWS0Station.saatkarbaj = this.properties.saatkarbaj; entryPWS0Station.agency = this.properties.agency; entryPWS0Station.areaid = this.properties.areaid; entryPWS0Station.cityid = this.properties.cityid; entryPWS0Station.cityname = this.properties.cityname; entryPWS0Station.statename = this.properties.statename; entryPWS0Station.stateid = this.properties.stateid; entryPWS0Station.TaghlilStationID = this.properties.TaghlilStationID; entryPWS0Station.taghlilid = this.properties.taghlilid; entryPWS0Station.FetchTime = DateTime.Now; if (add) { entityLogestic.PWS0Stations.Add(entryPWS0Station); } entityLogestic.SaveChanges(); //to get id of stationid int StationId = entryPWS0Station.Id; add = false; PWS0StationsGeos entryPWS0StationsGeos = entityLogestic.PWS0StationsGeos.FirstOrDefault(o => o.StationId == StationId && o.id == this.id); if (entryPWS0StationsGeos == null) { entryPWS0StationsGeos = new PWS0StationsGeos(); add = true; } entryPWS0StationsGeos.id = this.id; entryPWS0StationsGeos.geometry_name = this.geometry_name; if (this.geometry != null) { entryPWS0StationsGeos.geometryType = this.geometry.type; if (this.geometry.coordinates != null) { entryPWS0StationsGeos.geometryCoordinates = string.Join(",", this.geometry.coordinates.ToArray()); } } entryPWS0StationsGeos.StationId = StationId; entryPWS0StationsGeos.type = this.type; if (add) { entityLogestic.PWS0StationsGeos.Add(entryPWS0StationsGeos); } entityLogestic.SaveChanges(); } }
public void readAndSaveToDB(int F15Rec_ID, int train_no, int?trainId, int cycleNumber, trainBarryJsonModel trainBarryJson) { try { Uri uri; uri = new Uri(this.v_url); 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=\"f15rec_id\"\r\n\r\n" + F15Rec_ID.ToString() + "\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW" + "\r\nContent-Disposition: form-data; name=\"train_no\"\r\n\r\n" + train_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 entityLogestic = new logisticEntities()) { foreach (trainBillOfLadingsJsonModel billOfLading in trainBillOfLadingsListJson) { if (trainBarryJson != null) { //billOfLading.Barnameh_NO= it has it already //billOfLading.Bar_Type = it has it already billOfLading.Current_Station_Code = trainBarryJson.Current_Station_Code; //billOfLading.Current_Station_Name= //billOfLading.Destination_Station_Name = it has it already billOfLading.Entrance_Date = trainBarryJson.Entrance_Date; billOfLading.Entrance_Date_M = trainBarryJson.Entrance_DateTime; billOfLading.Entrance_Time = trainBarryJson.Entrance_Time; billOfLading.F15Rec_ID = trainBarryJson.F15Rec_ID; billOfLading.Source_Station_Code = trainBarryJson.Source_Station_Code; //billOfLading.Source_Station_Name = it has it already billOfLading.Tashkil_Date = trainBarryJson.Tashkil_Date; billOfLading.Tashkil_Time = trainBarryJson.Tashkil_Time; billOfLading.Train_No = trainBarryJson.Train_No; //billOfLading.Wagon_NO = it has it already } else { trainBarry train = new trainBarry(); trainBarryJsonModel[] jModel = train.fnc_findTrainBarry(train_no); if (jModel != null) { trainBarryJson = jModel.OrderByDescending(o => o.Entrance_DateTime).FirstOrDefault(); if (trainBarryJson != null) { //billOfLading.Barnameh_NO= it has it already //billOfLading.Bar_Type = it has it already billOfLading.Current_Station_Code = trainBarryJson.Current_Station_Code; //billOfLading.Current_Station_Name= //billOfLading.Destination_Station_Name = it has it already billOfLading.Entrance_Date = trainBarryJson.Entrance_Date; billOfLading.Entrance_Date_M = trainBarryJson.Entrance_DateTime; billOfLading.Entrance_Time = trainBarryJson.Entrance_Time; billOfLading.F15Rec_ID = trainBarryJson.F15Rec_ID; billOfLading.Source_Station_Code = trainBarryJson.Source_Station_Code; //billOfLading.Source_Station_Name = it has it already billOfLading.Tashkil_Date = trainBarryJson.Tashkil_Date; billOfLading.Tashkil_Time = trainBarryJson.Tashkil_Time; billOfLading.Train_No = trainBarryJson.Train_No; //billOfLading.Wagon_NO = it has it already } } } this.sb_saveToDB(billOfLading, train_no, trainId, cycleNumber, "getBariWgonList"); } } } } } catch (Exception ex) { } }
private void sb_saveToDB(DataTable dt, int cycleNumber) { if (dt == null) { return; } int i; string solarDate; string solarTime; DateTime? entranceDateTime; customersHistory entryCustomersHistory; bool add; string currentStationName; string wagonNo; string trainNo; string billOfLadingNo; using (var entityLogistic = new logisticEntities()) { for (i = 0; i <= dt.Rows.Count - 1; i++) { try { wagonNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo].ToString()); trainNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo].ToString()); currentStationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName].ToString()); billOfLadingNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo].ToString()); #region enteranceDate solarDate = null; solarTime = null; if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate])) { solarDate = "13" + dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate].ToString().Substring(0, 2) + "/" + dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate].ToString().Substring(2, 2) + "/" + dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate].ToString().Substring(4, 2); } if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime])) { solarTime = dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime].ToString(); } if (!Functions.IsNull(solarTime)) { entranceDateTime = Functions.fnc_convertSolarDateAndTimeToDateTime(solarDate, int.Parse(solarTime.Replace(":", ""))); } else { entranceDateTime = null; } #endregion add = true; entryCustomersHistory = entityLogistic.customersHistories.Where(o => o.wagonControlNo == wagonNo && o.trainNo == trainNo && o.currentStationName == currentStationName && o.entranceSolarDate == solarDate && o.entranceTime == solarTime && o.billOfLadingNo == billOfLadingNo).FirstOrDefault(); if (entryCustomersHistory == null) { add = true; entryCustomersHistory = new customersHistory(); } else { add = false; } entryCustomersHistory.wagonControlNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_wagonNo].ToString()); entryCustomersHistory.trainNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainNo].ToString()); entryCustomersHistory.areaName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_areaName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_areaName].ToString()); entryCustomersHistory.currentStationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName].ToString()); entryCustomersHistory.entranceSolarDate = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate]) ? null : solarDate); entryCustomersHistory.entranceTime = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime].ToString()); entryCustomersHistory.distance = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_distance]) ? null : (int?)int.Parse(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_distance].ToString())); entryCustomersHistory.goodsType = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_goodsType]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_goodsType].ToString()); entryCustomersHistory.sourceStationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName].ToString()); entryCustomersHistory.destinationStationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_destinationStationName].ToString()); entryCustomersHistory.billOfLadingNo = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_billOfLadingNo].ToString()); entryCustomersHistory.trainSourcestationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainSourceStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainDestinationStationName].ToString()); entryCustomersHistory.trainDestinationStationName = (Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainDestinationStationName]) ? null : dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_trainDestinationStationName].ToString()); entryCustomersHistory.entranceDateTime = entranceDateTime; entryCustomersHistory.fetchTime = DateTime.Now; if (add) { entityLogistic.customersHistories.Add(entryCustomersHistory); } entityLogistic.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { SharedVariables.logs.Error("wagonInfoSeirHistory.sb_savetoDb Entity of type \"" + eve.Entry.Entity.GetType().Name + "\" in state \"" + eve.Entry.State + "\" has the following validation errors:"); foreach (var ve in eve.ValidationErrors) { SharedVariables.logs.Error("- Property: \"" + ve.PropertyName + "\", Error: \"" + ve.ErrorMessage + "\""); } } } catch (Exception ex) { SharedVariables.logs.Error("wagonInfoSeirHistory.sb_savetoDb", ex); } } } }
private void sb_saveToDBOld(DataTable dt, int cycleNumber) { if (dt == null) { return; } int i; string solarDate; int? solarTime; DateTime?enteranceDateTime; raiWagon_Info_Tracking entry_raiWagon_Info_Tracking; using (var entityLogistic = new logisticEntities()) { for (i = 0; i <= dt.Rows.Count - 1; i++) { entry_raiWagon_Info_Tracking = new raiWagon_Info_Tracking(); if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_currentStationName])) { entry_raiWagon_Info_Tracking.currentStationId = 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 = 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_entranceSolarDate] != null)) { var solarDateArr = dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate].ToString().Split('/'); Array.Reverse(solarDateArr); solarDate = string.Join("", solarDateArr); solarDate = solarDate.Replace("/", ""); } if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime])) { solarTime = int.Parse(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime].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_goodsType])) { entry_raiWagon_Info_Tracking.goodsID = goods.fnc_getGoodsId(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_goodsType].ToString() , false, true); } entry_raiWagon_Info_Tracking.Source = "History"; if (!Functions.IsNull(dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_sourceStationName])) { entry_raiWagon_Info_Tracking.sourceStationId = 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 = 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 = 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_goodsType]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_goodsType].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_entranceSolarDate]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceSolarDate].ToString()); entry_raiWagon_Info_Tracking.wEnteranceTime = (Functions.IsNull(this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime]) ? null : this.v_dt.Rows[i][wagonInfoSeirHistoryDataTable.fld_entranceTime].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_saveToDB(trainBarryJsonModel train, int cycleNumber, bool getLocomotives, bool getBillOfLadings) { trainBarryBillOfLadings billOfLadings = new trainBarryBillOfLadings(); trainBarryLocomotives locos = new trainBarryLocomotives(); using (var entityLogestic = new logisticEntities()) { bool add = false; PWS0TrainsBarry entryPWS0Train = entityLogestic.PWS0TrainsBarry.FirstOrDefault(o => o.jCurrent_Station_Code == train.Current_Station_Code && o.jDestination_Station_Code == train.Destination_Station_Code //&& o.jEntrance_Date== train.Entrance_Date //&& o.jEntrance_DateTime== train.Entrance_DateTime //&& o.jEntrance_Time== train.Entrance_Time && o.jF15Rec_ID == train.F15Rec_ID && o.jSource_Station_Code == train.Source_Station_Code && o.jTashkil_Date == train.Tashkil_Date && o.jTashkil_Time == train.Tashkil_Time && o.jTrain_No == train.Train_No //&& o.jUpdate_DateTime == train.Update_DateTime ); if (entryPWS0Train == null) { add = true; entryPWS0Train = new PWS0TrainsBarry(); } try { entryPWS0Train.CurrentStationId = stations.fnc_getStationId(train.Current_Station_Code, null, true); entryPWS0Train.DestinationStationId = stations.fnc_getStationId(train.Destination_Station_Code, null, true); entryPWS0Train.FetchTime = DateTime.Now; entryPWS0Train.jCurrent_Station_Code = train.Current_Station_Code; entryPWS0Train.jDestination_Station_Code = train.Destination_Station_Code; entryPWS0Train.jEntrance_Date = train.Entrance_Date; entryPWS0Train.jEntrance_DateTime = train.Entrance_DateTime; entryPWS0Train.jEntrance_Time = train.Entrance_Time; entryPWS0Train.jF15Rec_ID = train.F15Rec_ID; entryPWS0Train.jLocomotiveNumbers = (train.F15Rec_ID.HasValue && getLocomotives ? locos.fnc_getTrainsBarryLocomotives(train.F15Rec_ID.Value) : null); entryPWS0Train.jSource_Station_Code = train.Source_Station_Code; entryPWS0Train.jTashkil_Date = train.Tashkil_Date; entryPWS0Train.jTashkil_Time = train.Tashkil_Time; entryPWS0Train.jTrain_No = train.Train_No; entryPWS0Train.jUpdate_DateTime = train.Update_DateTime; entryPWS0Train.SourceStationId = stations.fnc_getStationId(train.Source_Station_Code, null, true); entryPWS0Train.TashkilDateTime = Functions.fnc_convertSolarDateAndTimeToDateTime(train.Tashkil_Date, string.IsNullOrEmpty(train.Tashkil_Time) ? null : (int?)int.Parse(train.Tashkil_Time)); entryPWS0Train.CycleNumber = cycleNumber; if (add) { entityLogestic.PWS0TrainsBarry.Add(entryPWS0Train); } entityLogestic.SaveChanges(); if (train.F15Rec_ID.HasValue && train.Train_No.HasValue && getBillOfLadings) { billOfLadings.readAndSaveToDB(train.F15Rec_ID.Value, train.Train_No.Value, entryPWS0Train.Id, cycleNumber, train); } } catch (Exception ex) { } } }