public void UpdateWhdMstr(model.whdMstrModel in_whdMstr) { //UPDATE BY ID string sqlCommandWhdMstr = "update whd_mstr set " + "whdm_date = @whdm_date, " + "whdm_nbr = @whdm_nbr, " + "whdm_cust = @whdm_cust, " + "whdm_name = @whdm_name, " + "whdm_netto = @whdm_netto, " + "whdm_brutto = @whdm_brutto " + "where whdm_id = @whdm_id"; try { using (TransactionScope scope = new TransactionScope()) { using (SqlConnection connection = new SqlConnection()) { connection.Open(); using (SqlCommand SqlCmd = new SqlCommand(sqlCommandWhdMstr, connection)) { SqlCmd.Parameters.Add("@whdm_date", SqlDbType.DateTime); SqlCmd.Parameters.Add("@whdm_nbr", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_cust", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_name", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_netto", SqlDbType.Decimal); SqlCmd.Parameters.Add("@whdm_brutto", SqlDbType.Decimal); SqlCmd.Parameters.Add("@whdm_id", SqlDbType.Int); SqlCmd.Parameters["@whdm_date"].Value = in_whdMstr.Whdm_date; SqlCmd.Parameters["@whdm_nbr"].Value = in_whdMstr.Whdm_nbr; SqlCmd.Parameters["@whdm_cust"].Value = in_whdMstr.Whdm_cust; SqlCmd.Parameters["@whdm_name"].Value = in_whdMstr.Whdm_name; SqlCmd.Parameters["@whdm_netto"].Value = in_whdMstr.Whdm_netto; SqlCmd.Parameters["@whdm_brutto"].Value = in_whdMstr.Whdm_brutto; SqlCmd.Parameters["@whdm_id"].Value = in_whdMstr.Whdm_id; foreach (SqlParameter sqlParameter in SqlCmd.Parameters) { if (sqlParameter.Value == null) { sqlParameter.Value = DBNull.Value; } } SqlCmd.ExecuteNonQuery(); } trhMstrDataAccess trhist = new trhMstrDataAccess(); trhist.CreateTrhMstr(connection, in_whdMstr, "UPDATED"); } scope.Complete(); } } catch (Exception) { throw; } }
public void DeleteWhdMstr(model.whdMstrModel in_whdMstr) { //DELETE BY ID string sqlcommandWhdMstr = "delete from whd_mstr where whdm_id = @whdm_id"; string sqlcommandWhdDet = "delete from whd_det where whdd_whdm_id = @whdm_id"; try { using (TransactionScope scope = new TransactionScope()) { using (SqlConnection connection = new SqlConnection()) { connection.Open(); using (SqlCommand SqlCmd = new SqlCommand(sqlcommandWhdMstr, connection)) { SqlCmd.Parameters.Add("@whdm_id", SqlDbType.Int); SqlCmd.Parameters["@whdm_id"].Value = in_whdMstr.Whdm_id; foreach (SqlParameter sqlParameter in SqlCmd.Parameters) { if (sqlParameter.Value == null) { sqlParameter.Value = DBNull.Value; } } SqlCmd.ExecuteNonQuery(); } using (SqlCommand SqlCmd = new SqlCommand(sqlcommandWhdDet, connection)) { SqlCmd.Parameters.Add("@whdm_id", SqlDbType.Int); SqlCmd.Parameters["@whdm_id"].Value = in_whdMstr.Whdm_id; foreach (SqlParameter sqlParameter in SqlCmd.Parameters) { if (sqlParameter.Value == null) { sqlParameter.Value = DBNull.Value; } } SqlCmd.ExecuteNonQuery(); } trhMstrDataAccess trhist = new trhMstrDataAccess(); trhist.CreateTrhMstr(connection, in_whdMstr, "DELETED"); } scope.Complete(); } } catch (Exception Ex) { throw; } }
public void CreateWhdMstr(model.whdMstrModel in_whdMstr) { //CREATE BY NEXT ID - SQL SHOULD HANDLE ID NUMERATION string sqlCommandWhdMstr = "insert into whd_mstr " + "(whdm_date, whdm_nbr, whdm_cust, whdm_name, whdm_netto, whdm_brutto) " + "values " + "(@whdm_date, @whdm_nbr, @whdm_cust, @whdm_name, @whdm_netto, @whdm_brutto)"; try { using (TransactionScope scope = new TransactionScope()) { using (SqlConnection connection = new SqlConnection()) { connection.Open(); using (SqlCommand SqlCmd = new SqlCommand(sqlCommandWhdMstr, connection)) { SqlCmd.Parameters.Add("@whdm_date", SqlDbType.DateTime); SqlCmd.Parameters.Add("@whdm_nbr", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_cust", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_name", SqlDbType.NVarChar); SqlCmd.Parameters.Add("@whdm_netto", SqlDbType.Decimal); SqlCmd.Parameters.Add("@whdm_brutto", SqlDbType.Decimal); SqlCmd.Parameters["@whdm_date"].Value = in_whdMstr.Whdm_date; SqlCmd.Parameters["@whdm_nbr"].Value = in_whdMstr.Whdm_nbr; SqlCmd.Parameters["@whdm_cust"].Value = in_whdMstr.Whdm_cust; SqlCmd.Parameters["@whdm_name"].Value = in_whdMstr.Whdm_name; SqlCmd.Parameters["@whdm_netto"].Value = in_whdMstr.Whdm_netto; SqlCmd.Parameters["@whdm_brutto"].Value = in_whdMstr.Whdm_brutto; foreach (SqlParameter sqlParameter in SqlCmd.Parameters) { if (sqlParameter.Value == null) { sqlParameter.Value = DBNull.Value; } } SqlCmd.ExecuteNonQuery(); } trhMstrDataAccess trhist = new trhMstrDataAccess(); trhist.CreateTrhMstr(connection, in_whdMstr, "CREATED"); } scope.Complete(); } } catch (Exception Ex) { throw; } }