//Изменить тип доп. выплат
public bool ModifyTypeAddPayment(RefTypeAddPayment typeAddPayment, out string error)
{
error = string.Empty;
if (conn == null)
{
error = "conn == null";
return(false);
}
if (typeAddPayment == null)
{
error = "typeAddPayment == null";
return(false);
}
SqlCommand command = new SqlCommand(spRefTypeAddPaymentUpdate, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefTypeAddPayment_Id", typeAddPayment.RefTypeAddPayment_Id);
command.Parameters.AddWithValue("@inRefTypeAddPayment_Cd", typeAddPayment.RefTypeAddPayment_Cd);
command.Parameters.AddWithValue("@inRefTypeAddPayment_Nm", typeAddPayment.RefTypeAddPayment_Nm);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
//Физическое удаление строки
private void DeleteRecord()
{
if (dgvRefTypeAddPayment.CurrentRow == null)
{
return;
}
if (MessageBox.Show("Ви впевнені, що бажаєте видалити рядок?", "Видалення", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
RefTypeAddPayment typeAddPayment = dgvRefTypeAddPayment.CurrentRow.DataBoundItem as RefTypeAddPayment;
if (typeAddPayment == null)
{
MessageBox.Show("Не знайдений рядок для видалення", "Помилка");
return;
}
string error;
if (!_repository.DeleteTypeAddPayment(typeAddPayment.RefTypeAddPayment_Id, out error))
{
MessageBox.Show("Помилка видалення рядка.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
}
//Обновление строки
private void UpdateRecord()
{
if (dgvRefTypeAddPayment.CurrentRow == null)
{
return;
}
string error;
RefTypeAddPayment typeAddPayment = dgvRefTypeAddPayment.CurrentRow.DataBoundItem as RefTypeAddPayment;
if (typeAddPayment == null)
{
MessageBox.Show("Не знайдений рядок для оновлення", "Помилка");
return;
}
fmRefTypeAddPaymentEdit fmEdit = new fmRefTypeAddPaymentEdit("Зміна типу додаткових виплат");
fmEdit.SetData(typeAddPayment);
if (fmEdit.ShowDialog() == DialogResult.OK)
{
typeAddPayment = fmEdit.GetData();
if (!_repository.ModifyTypeAddPayment(typeAddPayment, out error))
{
MessageBox.Show("Помилка оновлення рядка.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
}
}
public void SetData(RefTypeAddPayment typeAddPayment)
{
if (typeAddPayment == null)
{
return;
}
id = typeAddPayment.RefTypeAddPayment_Id;
tbCode.Text = typeAddPayment.RefTypeAddPayment_Cd;
tbName.Text = typeAddPayment.RefTypeAddPayment_Nm;
}
private void FillDataRec(SqlDataReader reader, RefTypeAddPayment typeAddPayment)
{
int resInt = 0;
if (int.TryParse(reader["RefTypeAddPayment_Id"].ToString(), out resInt))
{
typeAddPayment.RefTypeAddPayment_Id = resInt;
}
typeAddPayment.RefTypeAddPayment_Cd = reader["RefTypeAddPayment_Cd"].ToString();
typeAddPayment.RefTypeAddPayment_Nm = reader["RefTypeAddPayment_Nm"].ToString();
}
private List <RefTypeAddPayment> typeAddPayments = null; //Кеширование
//Вставка строки
private void InsertRecord()
{
fmRefTypeAddPaymentEdit fmEdit = new fmRefTypeAddPaymentEdit("Створення типу додаткових виплат");
if (fmEdit.ShowDialog() == DialogResult.OK)
{
string error;
RefTypeAddPayment typeAddPayment = fmEdit.GetData();
int id = _repository.AddTypeAddPayment(typeAddPayment, out error);
if (id == 0)
{
MessageBox.Show("Помилка додавання рядка.\nТехнічна інформація: " + error, "Помилка");
return;
}
RefreshTable();
dgvRefTypeAddPayment.SetPositionRow <RefTypeAddPayment>("RefTypeAddPayment_Id", id.ToString());
}
}
//Добавить тип доп. выплат
public int AddTypeAddPayment(RefTypeAddPayment typeAddPayment, out string error)
{
error = string.Empty;
if (typeAddPayment == null)
{
error = "typeAddPayment == null";
return(0);
}
if (conn == null)
{
error = "conn == null";
return(0);
}
SqlCommand command = new SqlCommand(spRefTypeAddPaymentInsert, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefTypeAddPayment_Cd", typeAddPayment.RefTypeAddPayment_Cd);
command.Parameters.AddWithValue("@inRefTypeAddPayment_Nm", typeAddPayment.RefTypeAddPayment_Nm);
// определяем выходной параметр
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);
}
//Получить все типы доп. выплат
public List <RefTypeAddPayment> GetAllTypeAddPayments(out string error)
{
error = string.Empty;
List <RefTypeAddPayment> typeAddPayments = new List <RefTypeAddPayment>();
if (conn == null)
{
error = "conn == null";
return(typeAddPayments);
}
SqlCommand command = new SqlCommand(spRefTypeAddPaymentSelect, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = null;
try
{
reader = command.ExecuteReader();
while (reader.Read())
{
RefTypeAddPayment typeAddPayment = new RefTypeAddPayment();
FillDataRec(reader, typeAddPayment);
typeAddPayments.Add(typeAddPayment);
}
}
catch (Exception exc)
{
error = exc.Message;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(typeAddPayments);
}
//Получить тип доп. выплат id
public RefTypeAddPayment GetTypeAddPaymentById(int id, out string error)
{
error = string.Empty;
RefTypeAddPayment resTypeAddPayment = null;
if (conn == null)
{
error = "conn == null";
return(null);
}
SqlCommand command = new SqlCommand(spRefTypeAddPaymentSelect, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@inRefTypeAddPayment_Id", id);
SqlDataReader reader = null;
try
{
reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
resTypeAddPayment = new RefTypeAddPayment();
FillDataRec(reader, resTypeAddPayment);
}
}
catch (Exception ex)
{
error = ex.Message;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(resTypeAddPayment);
}
