Exemplo n.º 1
0
        private void btn_getTrainBarryLocomotives_Click(object sender, EventArgs e)
        {
            int F15Rec_ID;

            if (!int.TryParse(this.txtbx_locomotives_F15Rec_ID.Text, out F15Rec_ID))
            {
                MessageBox.Show("Wrong F15Rec_ID or the F15Rec_ID is not specified");
                return;
            }
            PWS0.trainBarryLocomotives locomotives = new PWS0.trainBarryLocomotives();
            locomotives.fnc_getTrainsBarryLocomotives(F15Rec_ID);
            MessageBox.Show("Warning!!! 'get Train Barry Locomotives' does not save locomtives into database. To save locomotives you need to perform 'get Train Barries'", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            MessageBox.Show("Finished!!!");
        }
Exemplo n.º 2
0
        private void sb_saveToDB(trainBarryJsonModel train, int cycleNumber, bool getLocomotives, bool getBillOfLadings)
        {
            trainBarryBillOfLadings billOfLadings = new trainBarryBillOfLadings();
            trainBarryLocomotives   locos         = new trainBarryLocomotives();

            using (var entityLogistic = new Model.logisticEntities())
            {
                bool add = false;
                Model.PWS0TrainsBarry entryPWS0Train = entityLogistic.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 Model.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)
                    {
                        entityLogistic.PWS0TrainsBarry.Add(entryPWS0Train);
                    }


                    entityLogistic.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)
                {
                }
            }
        }