Ejemplo n.º 1
0
 public static int InsertToKhai(tblToKhaiTau tokhai)
 {
     var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     _db.Connection.Open();
     tokhai.CreatedDate = CommonFactory.GetCurrentDate();
     tokhai.BranchId = FDHelper.RgCodeOfUnit();
     _db.AddTotblToKhaiTaus(tokhai);
     try
     {
         if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
         return _db.SaveChanges();
     }
     catch (Exception ex)
     {
         return -1;
     }
     finally
     {
         _db.Connection.Close();
     }
 }
        private void btnAddNew_Click(object sender, EventArgs e)
        {
            try
            {
                if (!Validate()) return;
                var train = new tblTrain();
                train.Number = txtNumberTrain.Text.Trim();
                var type = (short)((ComboBoxItem)ddlTypeName.SelectedItem).Value;
                train.Type = type;
                if (type == (short)TrainType.TypeExport || type == (short)TrainType.TypeExportChange || type == (short)TrainType.TypeExportNormal)
                {
                    train.IsExport = true;
                    train.DateExport = CommonFactory.GetCurrentDate();
                }
                else
                {
                    train.IsImport = true;
                    train.DateImport = CommonFactory.GetCurrentDate();
                }
                if (type == (short)TrainType.TypeExportChange || type == (short)TrainType.TypeImportChange)
                {
                    train.NumberHandover = txtNumberHandover.Text.Trim();
                    train.DateHandover = dtpHandover.Value;
                    train.CodeStation = txtCodeCuaKhau.Text.Trim();
                    train.CodeStationFromTo = txtCodeGaDenDi.Text.Trim();
                    train.StatusVehicle = txtStatusVehicle.Text.Trim();
                    train.StatusGoods = txtStatusGood.Text.Trim();
                }

                train.CreatedBy = _userInfo.UserID;
                if (TrainFactory.Insert(train) > 0)
                {
                    //insert tờ khai
                    if (type == (short)TrainType.TypeExportNormal || type == (short)TrainType.TypeImportNormal)
                    {
                        var declare = new tblToKhaiTau()
                                          {
                                              Number = Convert.ToInt32(txtExportNumber.Text.Trim()),
                                              DateDeclaration = dtpDeclaration.Value,
                                              TypeCode = txtTypeExport.Text.Trim(),
                                              CustomCode = txtCustomsCode.Text.Trim(),
                                              CreatedBy = _userInfo.UserID,
                                              TrainID = train.TrainID
                                          };
                        TrainFactory.InsertToKhai(declare);

                    }
                    //insert toa tàu
                    if (grdToaTau.Rows.Count > 0)
                    {
                        var listToaTau = new List<tblToaTau>();
                        for (int i = 0; i < grdToaTau.Rows.Count; i++)
                        {
                            var toaTau = (tblToaTau) grdToaTau.Rows[i].DataBoundItem;
                            toaTau.CreatedBy = _userInfo.UserID;
                            toaTau.TrainID = train.TrainID;
                            listToaTau.Add(toaTau);
                        }
                        TrainFactory.InsertToaTau(listToaTau);
                    }

                    MessageBox.Show("Thêm mới thành công!");
                    Reset();
                }
                else MessageBox.Show("Thêm mới không thành công!");
            }
            catch (Exception ex)
            {
                if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
            }
        }