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());
}
}
}
