public static int InsertToKhaiTau(tblToKhaiTau toKhaiTau) { var db = Instance(); db.AddTotblToKhaiTaus(toKhaiTau); return(db.SaveChanges()); }
public frmToKhai(UserInfo userInfo, tblToKhaiTau toKhaiTau, short type, short mode = (short)0) { InitializeComponent(); _userInfo = userInfo; _type = type; _mode = mode; _toKhaiTau = toKhaiTau; }
public static int InsertToKhai(tblToKhaiTau tokhai) { var db = new dbTrainEntities(ConnectionController.GetConnection()); tokhai.CreatedDate = CommonFactory.GetCurrentDate(); db.AddTotblToKhaiTaus(tokhai); return(db.SaveChanges()); }
public static int UpdateToKhaiTau(tblToKhaiTau toKhaiTau, List <tblToaTau> listToaTau) { try { var db = Instance(); //xoa cac toa tau cu thuoc to khai List <tblToKhaiTauResource> listReource = db.tblToKhaiTauResources.Where(x => x.tblToKhaiTau.ID == toKhaiTau.ID).ToList(); foreach (tblToKhaiTauResource resource in listReource) { deleteToKhaiTauResource(resource); } //cap nhat thong tin to khai tau tblToKhaiTau toKhaitauOrigin = db.tblToKhaiTaus.Where(x => x.ID == toKhaiTau.ID).FirstOrDefault(); if (toKhaitauOrigin != null) { toKhaitauOrigin.Number = toKhaiTau.Number; toKhaitauOrigin.DateDeclaration = toKhaiTau.DateDeclaration; toKhaitauOrigin.TypeCode = toKhaiTau.TypeCode; toKhaitauOrigin.CustomCode = toKhaiTau.CustomCode; toKhaitauOrigin.ModifiedBy = toKhaiTau.ModifiedBy; toKhaitauOrigin.ModifiedDate = CommonFactory.GetCurrentDate(); //them cac toa tau moi cho to khai foreach (var toaTau in listToaTau) { var declarationResource = new tblToKhaiTauResource { tblToaTau = toaTau }; toKhaitauOrigin.tblToKhaiTauResources.Add(declarationResource); } db.SaveChanges(); } return(1); } catch (Exception) { } return(0); }
public static tblToKhaiTau CreatetblToKhaiTau(long id, string branchId, long trainID) { tblToKhaiTau tblToKhaiTau = new tblToKhaiTau(); tblToKhaiTau.ID = id; tblToKhaiTau.BranchId = branchId; tblToKhaiTau.TrainID = trainID; return tblToKhaiTau; }
public void AddTotblToKhaiTaus(tblToKhaiTau tblToKhaiTau) { AddObject("tblToKhaiTaus", tblToKhaiTau); }
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()); } } }
private void btnAddNew_Click(object sender, EventArgs e) { var dr = MessageBox.Show(ConstantInfo.CONFIRM_ADD_NEW, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr != DialogResult.Yes) { return; } try { if (!Validate()) { return; } //if (grdToaTau.RowCount == 0) //{ // MessageBox.Show("Bạn phải chọn ít nhất một toa tàu!"); // return; //} //kiem tra su trung lap so to khai if (TrainFactory.FindToKhaiTauByNumber(Int64.Parse(txtNumberToKhai.Text.Trim()), dtpDeclaration.Value, txtTypeCode.Text) != null) { MessageBox.Show("Số tờ khai này đã tồn tại, xin nhập số khác!"); return; } var declaration = new tblToKhaiTau { Type = _type, Number = Int64.Parse(txtNumberToKhai.Text.Trim()), DateDeclaration = dtpDeclaration.Value, TypeCode = txtTypeCode.Text.Trim(), CustomCode = txtCustomsCode.Text.Trim(), CreatedBy = _userInfo.UserID, CreatedDate = CommonFactory.GetCurrentDate() }; foreach (var toaTau in _listToaTau) { var declarationResource = new tblToKhaiTauResource { tblToaTau = toaTau }; declaration.tblToKhaiTauResources.Add(declarationResource); } var result = TrainFactory.InsertToKhaiTau(declaration); if (result > 0) { MessageBox.Show(string.Format("Thêm mới Tờ khai {0} thành công!", _type == 0 ? "xuất cảnh" : "nhập cảnh")); Reset(); } else { MessageBox.Show("Thêm mới Tờ khai không thành công!"); } } catch (Exception ex) { if (GlobalInfo.IsDebug) { MessageBox.Show(ex.ToString()); } } }