public static bool Update(dbo_CycleAssignmentClass newdbo_CycleAssignmentClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "CycleAssignmentUpdate"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_CycleAssignmentClass.Order_Cycle_ID != null) { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", newdbo_CycleAssignmentClass.Order_Cycle_ID); } else { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", DBNull.Value); } if (newdbo_CycleAssignmentClass.CV_Code != null) { updateCommand.Parameters.AddWithValue("@NewCV_Code", newdbo_CycleAssignmentClass.CV_Code); } else { updateCommand.Parameters.AddWithValue("@NewCV_Code", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }
public static dbo_CycleAssignmentClass Select_Record(String Order_Cycle_ID, String CV_Code) { dbo_CycleAssignmentClass clsdbo_CycleAssignment = new dbo_CycleAssignmentClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "CycleAssignmentSelect"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Order_Cycle_ID", Order_Cycle_ID); selectCommand.Parameters.AddWithValue("@CV_Code", CV_Code); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_CycleAssignment.Order_Cycle_ID = reader["Order_Cycle_ID"] is DBNull ? null : reader["Order_Cycle_ID"].ToString(); clsdbo_CycleAssignment.CV_Code = reader["CV_Code"] is DBNull ? null : reader["CV_Code"].ToString(); clsdbo_CycleAssignment.AgentName = reader["AgentName"] is DBNull ? null : reader["AgentName"].ToString(); } else { clsdbo_CycleAssignment = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_CycleAssignment); } finally { connection.Close(); } return(clsdbo_CycleAssignment); }
public static bool Add(dbo_CycleAssignmentClass clsdbo_CycleAssignment, String Created_By) { SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "CycleAssignmentInsert"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_CycleAssignment.Order_Cycle_ID != null) { insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", clsdbo_CycleAssignment.Order_Cycle_ID); } else { insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", DBNull.Value); } if (clsdbo_CycleAssignment.CV_Code != null) { insertCommand.Parameters.AddWithValue("@CV_Code", clsdbo_CycleAssignment.CV_Code); } else { insertCommand.Parameters.AddWithValue("@CV_Code", DBNull.Value); } if (Created_By != null) { insertCommand.Parameters.AddWithValue("@Created_By", Created_By); } else { insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }