private void btnAdd_Click(object sender, EventArgs e)
 {
     if (_mode == 0)
     {
         //validate
         if (validate())
         {
             tblCompany company = new tblCompany();
             company.CompanyCode = txtCompanyCode.Text.Trim();
             company.CompanyName = txtCompanyName.Text.Trim();
             company.Description = txtDescription.Text.Trim();
             company.CreatedBy = _userInfo.UserID;
             company.ModifiedBy = _userInfo.UserID;
             if (CompanyFactory.Insert(company) > 0)
             {
                 try
                 {
                     _frmListCompany.init();
                 }
                 catch (Exception ex)
                 {
                     //do nothing
                 }
                 MessageBox.Show("Thêm mới doanh nghiệp thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 reset();
             }
             else
             {
                 MessageBox.Show("Thêm mới doanh nghiệp không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
         }
     }
 }
        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(tblCompany company)
 {
     dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     _db.Connection.Open();
     company.CreatedDate = CommonFactory.GetCurrentDate();
     company.ModifiedDate = CommonFactory.GetCurrentDate();
     _db.AddTotblCompanies(company);
     try
     {
         if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
         return _db.SaveChanges();
     }
     catch (Exception ex)
     {
         return -1;
     }
     finally
     {
         _db.Connection.Close();
     }
 }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (_mode == 1)
            {
                if (validate())
                {
                    tblCompany company = new tblCompany();
                    company.CompanyCode = txtCompanyCode.Text;
                    company.CompanyName = txtCompanyName.Text.Trim();
                    company.Description = txtDescription.Text.Trim();
                    company.ModifiedBy = _userInfo.UserID;
                    if (CompanyFactory.Update(company) > 0)
                    {
                        try
                        {
                            _frmListCompany.search();
                        }
                        catch (Exception ex)
                        {
                            //do nothing
                        }
                        MessageBox.Show("Cập doanh nghiệp hình thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    }
                    else
                    {
                        MessageBox.Show("Cập nhật doanh nghiệp không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);

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

            tblCompany originCompany = _db.tblCompanies.Where(g => g.CompanyCode == companyObj.CompanyCode).FirstOrDefault();

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

            originCompany.CompanyName = companyObj.CompanyName;
            originCompany.Description = companyObj.Description;
            originCompany.ModifiedBy = companyObj.ModifiedBy;
            originCompany.ModifiedDate = CommonFactory.GetCurrentDate();

            try
            {
                return _db.SaveChanges();
            }
            catch (Exception ex)
            {
                return -1;
            }
            finally
            {
                _db.Connection.Close();
            }
        }