public void Add(PayDayCodeUnit oUnit)
{
SqlCommand oCommand = new SqlCommand();
oCommand.Connection = this.Connection;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandText = "SP_TRANS_INSERT_PAYDAYCODE";
oCommand.Parameters.Add(new SqlParameter("@PayDayCode", oUnit.Code));
oCommand.Parameters.Add(new SqlParameter("@Remarks", oUnit.Description));
oCommand.Parameters.Add(new SqlParameter("@DateCreated", oUnit.DateCreated));
oCommand.Parameters.Add(new SqlParameter("@CreatedBy", oUnit.CreatedBy));
oCommand.Parameters.Add(new SqlParameter("@DateModified", oUnit.DateModified));
oCommand.Parameters.Add(new SqlParameter("@ModifiedBy", oUnit.ModifiedBy));
oCommand.ExecuteNonQuery();
foreach (DataRow oRow in oUnit.LineItems.Rows)
{
SqlCommand oLineCommand = new SqlCommand();
oLineCommand.Connection = this.Connection;
oLineCommand.CommandType = CommandType.StoredProcedure;
oLineCommand.CommandText = "SP_TRANS_INSERT_PAYDAYCODE_LINES";
oLineCommand.Parameters.Add(new SqlParameter("@PayDayCode", oUnit.Code));
oLineCommand.Parameters.Add(new SqlParameter("@Interval", oRow["Interval"].ToString()));
oLineCommand.Parameters.Add(new SqlParameter("@DayWeekNo", oRow["DayWeekNo"].ToString()));
oLineCommand.ExecuteNonQuery();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PayDayCodeManager oManager = new PayDayCodeManager();
PayDayCodeUnit oUnit = new PayDayCodeUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
oUnit.Code = txtCode.Text;
oUnit.Description = txtDescription.Text;
oUnit.DateCreated = Convert.ToDateTime(dtCreated.EditValue);
oUnit.CreatedBy = txtCreatedBy.Text;
oUnit.DateModified = Convert.ToDateTime(dtModified.EditValue);
oUnit.ModifiedBy = txtModifiedBy.Text;
oUnit.LineItems = this.LineItems;
oManager.Add(oUnit);
oManager.Close();
this.MainMenu.RefreshMainMenu();
}