private void btnAdd_Click(object sender, EventArgs e)
        {
            if (_mode == 0)
            {
                //validate
                if (validate())
                {
                    tblCustom customs = new tblCustom();
                    customs.CustomsCode = txtCode.Text;
                    customs.CustomsName = txtName.Text.Trim();
                    customs.Description = txtDescription.Text.Trim();
                    customs.CreatedBy = _userInfo.UserID;
                    customs.ModifiedBy = _userInfo.UserID;
                    if (CustomsFacory.Insert(customs) > 0)
                    {
                        try
                        {
                            _frmListCustoms.init();
                        }
                        catch (Exception ex)
                        {
                            //do nothing
                        }
                        MessageBox.Show("Thêm mới đơn vị hải quan thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        reset();
                    }
                    else
                    {
                        MessageBox.Show("Thêm mới đơn vị hải quan không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }

            
        }
        public static int Update(tblCustom customsObj)
        {
            dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
            _db.Connection.Open();

            tblCustom originCustoms = _db.tblCustoms.Where(g => g.CustomsCode == customsObj.CustomsCode).FirstOrDefault();

            if (originCustoms == null)
            {
                return -1;
            }

            originCustoms.CustomsName = customsObj.CustomsName;
            originCustoms.Description = customsObj.Description;
            originCustoms.ModifiedBy = customsObj.ModifiedBy;
            originCustoms.ModifiedDate = CommonFactory.GetCurrentDate();

            try
            {
                return _db.SaveChanges();
            }
            catch (Exception ex)
            {
                return -1;
            }
            finally
            {
                _db.Connection.Close();
            }
        }
        private void FrmReportImportToReExport_Load(object sender, EventArgs e)
        {
            this.Text = "Bao cao xuat/nhap chuyen cua khau" + ConstantInfo.MESSAGE_TITLE + GlobalInfo.CompanyName;

            //init cbCustoms
            List<tblCustom> listCustom = CustomsFacory.getAll();
            foreach (tblCustom cb in listCustom)
            {
                cb.CustomsName = cb.CustomsCode + " - " + cb.CustomsName;
            }
            listCustom = listCustom.OrderBy(g => g.CustomsCode).ToList();
            tblCustom allObj = new tblCustom();
            allObj.CustomsCode = "0";
            allObj.CustomsName = "Tất cả";
            listCustom.Insert(0, allObj);
            cbCustoms.DataSource = listCustom;
            cbCustoms.ValueMember = "CustomsCode";
            cbCustoms.DisplayMember = "CustomsName";

            //init cbCompany
            List<tblCompany> listCompany = CompanyFactory.getAllCompany();
            foreach (tblCompany cp in listCompany)
            {
                cp.CompanyName = cp.CompanyCode + " - " + cp.CompanyName;
            }
            listCompany = listCompany.OrderBy(g => g.CompanyCode).ToList();
            tblCompany allCompanyObj = new tblCompany();
            allCompanyObj.CompanyCode = "0";
            allCompanyObj.CompanyName = "Tất cả";
            listCompany.Insert(0, allCompanyObj);
            cbCompany.DataSource = listCompany;
            cbCompany.ValueMember = "CompanyCode";
            cbCompany.DisplayMember = "CompanyName";
        }
 public static int Insert(tblCustom customs)
 {
     dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     _db.Connection.Open();
     customs.CreatedDate = CommonFactory.GetCurrentDate();
     customs.ModifiedDate = CommonFactory.GetCurrentDate();
     customs.BranchId= FDHelper.RgCodeOfUnit();
     _db.AddTotblCustoms(customs);
     try
     {
         if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
         return _db.SaveChanges();
     }
     catch (Exception ex)
     {
         return -1;
     }
     finally
     {
         _db.Connection.Close();
     }
 }
예제 #5
0
        private void frmReport_Load(object sender, EventArgs e)
        {
            this.Location = new Point((_mainForm.Width - this.Width) / 2, (_mainForm.Height - this.Height) / 2);
            var list = new List<tblCustom>();
            var custom = new tblCustom {CustomsCode = "0", CustomsName = "Tất cả"};
            list.Add(custom);

            //tao danh sach don vi hai quan
            var listtblCustoms = CustomsFacory.getAll();
            list.AddRange(listtblCustoms.Select(item => new tblCustom {CustomsCode = item.CustomsCode.Trim(), CustomsName = item.CustomsName}));

            cbUnit.DisplayMember = "CustomsName";
            cbUnit.ValueMember = "CustomsCode";
            cbUnit.DataSource = list;
            if (FDHelper.RgGetSizeOfUnit() == ConstantInfo.Branch)
            {
                String unitCode= FDHelper.RgCodeOfUnit();
                cbUnit.SelectedValue = unitCode;
                cbUnit.Enabled = false;
            }

            //tao danh sach loai hinh
            List<tblType> listType = new List<tblType>();
            tblType type = new tblType();
            type.TypeCode = "";
            type.TypeName = "Tất cả";
            listType.Add(type);
            foreach (tblType obj in TypeFactory.getAllType())
            {
                tblType typeObj = new tblType();
                typeObj.TypeName = obj.TypeCode + " - " + obj.TypeName;
                typeObj.TypeCode = obj.TypeCode;
                listType.Add(typeObj);
            }
            cbType.DisplayMember = "TypeName";
            cbType.ValueMember = "TypeCode";
            cbType.DataSource = listType;
         }