//Обновление строки
private void UpdateRecord()
{
if (dgvGradeAllwnc.CurrentRow == null)
{
return;
}
v_RefGradeAllwnc v_allowance = dgvGradeAllwnc.CurrentRow.DataBoundItem as v_RefGradeAllwnc;
if (v_allowance == null)
{
MessageBox.Show("Не знайдений рядок для оновлення", "Помилка");
return;
}
fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Edit, "Зміна надбавки за класність");
fmEdit.SetData(_refGradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Id == v_allowance.RefGradeAllwnc_Id));
if (fmEdit.ShowDialog() == DialogResult.OK)
{
RefGradeAllwnc allowance = fmEdit.GetData();
string error;
if (!_repository.ModifyGradeAllwnc(allowance, out error))
{
MessageBox.Show("Помилка оновлення рядка.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
}
}
private void tbCd_Validating(object sender, CancelEventArgs e)
{
if (_cmbParams.tbCd.Text == string.Empty)
{
_cmbParams.ClearParams();
return;
}
RefGradeAllwnc allwnc = _cmbParams.gradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Cd == _cmbParams.tbCd.Text);
if (allwnc != null)
{
_cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id;
if (_cmbParams.tbCd != null)
{
_cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd;
}
if (_cmbParams.tbNm != null)
{
_cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm;
}
if (_cmbParams.tbPct != null)
{
_cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00");
}
}
else
{
_cmbParams.ClearParams();
btn_Click(sender, e);
}
}
public void ReadCombobox(int id)
{
if (_cmbParams == null)
{
return;
}
if (_cmbParams.gradeAllwncs == null)
{
return;
}
RefGradeAllwnc allwnc = _cmbParams.gradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Id == id);
if (allwnc == null)
{
_cmbParams.ClearParams();
return;
}
_cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id;
if (_cmbParams.tbCd != null)
{
_cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd;
}
if (_cmbParams.tbNm != null)
{
_cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm;
}
if (_cmbParams.tbPct != null)
{
_cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00");
}
}
private void FillDataRec(SqlDataReader reader, RefGradeAllwnc gradeAllwnc)
{
int resInt = 0;
decimal resDecimal = 0;
DateTime resDt = DateTime.MinValue;
if (int.TryParse(reader["RefGradeAllwnc_Id"].ToString(), out resInt))
{
gradeAllwnc.RefGradeAllwnc_Id = resInt;
}
gradeAllwnc.RefGradeAllwnc_Cd = reader["RefGradeAllwnc_Cd"].ToString();
gradeAllwnc.RefGradeAllwnc_Nm = reader["RefGradeAllwnc_Nm"].ToString();
if (decimal.TryParse(reader["RefGradeAllwnc_Pct"].ToString(), out resDecimal))
{
gradeAllwnc.RefGradeAllwnc_Pct = resDecimal;
}
if (int.TryParse(reader["RefGradeAllwnc_Grade"].ToString(), out resInt))
{
gradeAllwnc.RefGradeAllwnc_Grade = resInt;
}
if (int.TryParse(reader["RefGradeAllwnc_RefDep_Id"].ToString(), out resInt))
{
gradeAllwnc.RefGradeAllwnc_RefDep_Id = resInt;
}
if (int.TryParse(reader["RefGradeAllwnc_Flg"].ToString(), out resInt))
{
gradeAllwnc.RefGradeAllwnc_Flg = resInt;
}
}
public RefGradeAllwnc GetData()
{
RefGradeAllwnc allwnc = new RefGradeAllwnc();
allwnc.RefGradeAllwnc_Id = _id;
allwnc.RefGradeAllwnc_Cd = tbCd.Text;
allwnc.RefGradeAllwnc_Nm = tbNm.Text;
decimal resDec = 0;
if (decimal.TryParse(tbPct.Text, out resDec))
{
allwnc.RefGradeAllwnc_Pct = resDec;
}
int resInt = 0;
if (int.TryParse(tbGrade.Text, out resInt))
{
allwnc.RefGradeAllwnc_Grade = resInt;
}
allwnc.RefGradeAllwnc_RefDep_Id = _cmbDepParams.RefDep_Id;
if (cbUse.Checked)
{
allwnc.RefGradeAllwnc_Flg &= ~(int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE;
}
else
{
allwnc.RefGradeAllwnc_Flg |= (int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE;
}
return(allwnc);
}
//Добавить надбавку
public bool AddGradeAllwnc(RefGradeAllwnc allowance, out string error)
{
error = string.Empty;
if (allowance == null)
{
error = "allowance == null";
return(false);
}
if (conn == null)
{
error = "conn == null";
return(false);
}
SqlCommand command = new SqlCommand(spRefGradeAllwncInsert, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefGradeAllwnc_Cd", allowance.RefGradeAllwnc_Cd);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Nm", allowance.RefGradeAllwnc_Nm);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Pct", allowance.RefGradeAllwnc_Pct);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Grade", allowance.RefGradeAllwnc_Grade);
command.Parameters.AddWithValue("@inRefGradeAllwnc_RefDep_Id",
allowance.RefGradeAllwnc_RefDep_Id == 0 ? Convert.DBNull : allowance.RefGradeAllwnc_RefDep_Id);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Flg", allowance.RefGradeAllwnc_Flg);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
public RefGradeAllwnc GetData()
{
if (dgvGradeAllwnc.CurrentRow == null)
{
return(null);
}
RefGradeAllwnc allowance = dgvGradeAllwnc.CurrentRow.DataBoundItem as RefGradeAllwnc;
return(allowance);
}
public void SetData(RefGradeAllwnc allowance)
{
if (allowance == null)
{
return;
}
_id = allowance.RefGradeAllwnc_Id;
_cmbDep.ReadCombobox(allowance.RefGradeAllwnc_RefDep_Id);
tbCd.Text = allowance.RefGradeAllwnc_Cd;
tbNm.Text = allowance.RefGradeAllwnc_Nm;
tbPct.Text = allowance.RefGradeAllwnc_Pct.ToString("0.00");
tbGrade.Text = allowance.RefGradeAllwnc_Grade.ToString();
cbUse.Checked = (allowance.RefGradeAllwnc_Flg & (int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE) > 0 ? false : true;
}
//Добавить надбавку
public int AddGradeAllwnc(RefGradeAllwnc allowance, out string error)
{
error = string.Empty;
if (allowance == null)
{
error = "allowance == null";
return(0);
}
if (conn == null)
{
error = "conn == null";
return(0);
}
SqlCommand command = new SqlCommand(spRefGradeAllwncInsert, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefGradeAllwnc_Cd", allowance.RefGradeAllwnc_Cd);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Nm", allowance.RefGradeAllwnc_Nm);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Pct", allowance.RefGradeAllwnc_Pct);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Grade", allowance.RefGradeAllwnc_Grade);
command.Parameters.AddWithValue("@inRefGradeAllwnc_RefDep_Id",
allowance.RefGradeAllwnc_RefDep_Id == 0 ? Convert.DBNull : allowance.RefGradeAllwnc_RefDep_Id);
command.Parameters.AddWithValue("@inRefGradeAllwnc_Flg", allowance.RefGradeAllwnc_Flg);
// определяем выходной параметр
SqlParameter outId = new SqlParameter
{
ParameterName = "outId",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
};
command.Parameters.Add(outId);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
error = ex.Message;
return(0);
}
int id = 0;
int.TryParse(command.Parameters["outId"].Value.ToString(), out id);
return(id);
}
//Вставка строки
private void InsertRecord()
{
fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Insert, "Створення доплати");
if (fmEdit.ShowDialog() == DialogResult.OK)
{
string error;
RefGradeAllwnc gradeAllwncs = fmEdit.GetData();
if (!_repository.AddGradeAllwnc(gradeAllwncs, out error))
{
MessageBox.Show("Помилка додавання доплати.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
}
}
//Вставка строки
private void InsertRecord()
{
fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Insert, "Створення надбавки за класність");
if (fmEdit.ShowDialog() == DialogResult.OK)
{
string error;
RefGradeAllwnc gradeAllwncs = fmEdit.GetData();
int id = _repository.AddGradeAllwnc(gradeAllwncs, out error);
if (id == 0)
{
MessageBox.Show("Помилка додавання рядка.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
dgvGradeAllwnc.SetPositionRow <v_RefGradeAllwnc>("RefGradeAllwnc_Id", id.ToString());
}
}
////Получить надбавки
public List <RefGradeAllwnc> GetAllGradeAllwnc(out string error)
{
error = string.Empty;
List <RefGradeAllwnc> allowances = new List <RefGradeAllwnc>();
if (conn == null)
{
error = "conn == null";
return(allowances);
}
SqlCommand command = new SqlCommand(spRefGradeAllwncSelect, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = null;
try
{
reader = command.ExecuteReader();
while (reader.Read())
{
RefGradeAllwnc allowance = new RefGradeAllwnc();
FillDataRec(reader, allowance);
allowances.Add(allowance);
}
}
catch (Exception exc)
{
error = exc.Message;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(allowances);
}
//Получить надбавку по id
public RefGradeAllwnc GetGradeAllwncById(int id, out string error)
{
error = string.Empty;
RefGradeAllwnc allowance = null;
if (conn == null)
{
error = "conn == null";
return(null);
}
SqlCommand command = new SqlCommand(spRefGradeAllwncSelect, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefGradeAllwnc_Id", id);
SqlDataReader reader = null;
try
{
reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
allowance = new RefGradeAllwnc();
FillDataRec(reader, allowance);
}
}
catch (Exception ex)
{
error = ex.Message;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(allowance);
}
private void btn_Click(object sender, EventArgs e)
{
fmCmbGradeAllwnc fmCmbAllwnc = new fmCmbGradeAllwnc(_cmbParams.gradeAllwncs);
if (fmCmbAllwnc.ShowDialog() == DialogResult.OK)
{
RefGradeAllwnc allwnc = fmCmbAllwnc.GetData();
_cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id;
if (_cmbParams.tbCd != null)
{
_cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd;
}
if (_cmbParams.tbPct != null)
{
_cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00");
}
if (_cmbParams.tbNm != null)
{
_cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm;
}
}
}
