private void btnUpdate_Click(object sender, EventArgs e) { int _enableRegulations = 0; if (chkUseRegulationsFour.Checked) { _enableRegulations = 1; } m_RegulationsObject = new CRegulationsDTO((int)spMinimumQuantityImport.Value, (int)spDebitMaximum.Value, (int)spMinimumSurvival.Value, (int)spMaximumSurvival.Value, _enableRegulations, (int)spMinimumAge.Value, (int)spMaximumAge.Value, (int)spProfit.Value); m_RegulationsExecute.UpdateRegulationsToDatabase(m_RegulationsObject); }
public bool AddRegulationsToDatabase(CRegulationsDTO _RegulationsObject) { m_cmd = new SqlCommand(); m_cmd.CommandType = CommandType.StoredProcedure; m_cmd.CommandText = "AddRegulationsDataToDatabase"; m_cmd.Parameters.Add("SoLuongNhapToiThieu", SqlDbType.Int).Value = _RegulationsObject.soLuongNhapToiThieu; m_cmd.Parameters.Add("SoTienNoToiDa", SqlDbType.Int).Value = _RegulationsObject.soTienNoToiDa; m_cmd.Parameters.Add("SoLuongTonToiThieuSauBan", SqlDbType.Int).Value = _RegulationsObject.soLuongTonToiThieuSauBan; m_cmd.Parameters.Add("SoLuongTonToiDaTruocNhap", SqlDbType.Int).Value = _RegulationsObject.soLuongTonToiDaTruocNhap; m_cmd.Parameters.Add("SuDungQuyDinh4", SqlDbType.Bit).Value = _RegulationsObject.suDungQuyDinh4; m_cmd.Parameters.Add("DoTuoiNhanVienToiThieu", SqlDbType.Int).Value = _RegulationsObject.doTuoiNhanVienToiThieu; m_cmd.Parameters.Add("DoTuoiNhanVienToiDa", SqlDbType.Int).Value = _RegulationsObject.doTuoiNhanVienToiDa; m_cmd.Parameters.Add("MucLoiNhuan", SqlDbType.Int).Value = _RegulationsObject.mucLoiNhuan; return(m_RegulationsExecute.updateData(m_cmd) > 0); }
public bool UpdateRegulationsToDatabase(CRegulationsDTO _RegulationsObject) { return(m_RegulationsDAL.UpdateRegulationsToDatabase(_RegulationsObject)); }
public bool AddRegulationsToDatabase(CRegulationsDTO _RegulationsObject) { return(m_RegulationsDAL.AddRegulationsToDatabase(_RegulationsObject)); }
public CRegulationsDAL() { m_RegulationsObject = null; m_RegulationsExecute = new CDataExecute(); m_cmd = new SqlCommand(); }
public CRegulationsDAL(CRegulationsDTO _RegulationsObject) { m_RegulationsObject = _RegulationsObject; m_RegulationsExecute = new CDataExecute(); m_cmd = new SqlCommand(); }