public static dbo_SubsidyClass Select_Record(String Subsidy_ID) { dbo_SubsidyClass clsdbo_Subsidy = new dbo_SubsidyClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[SubsidySelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Subsidy_ID", Subsidy_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_Subsidy.Subsidy_ID = reader["Subsidy_ID"] is DBNull ? null : reader["Subsidy_ID"].ToString(); clsdbo_Subsidy.Clearing_No = reader["Clearing_No"] is DBNull ? null : reader["Clearing_No"].ToString(); clsdbo_Subsidy.Subsidy_Detail = reader["Subsidy_Detail"] is DBNull ? null : reader["Subsidy_Detail"].ToString(); clsdbo_Subsidy.Subsidy_Amount = reader["Subsidy_Amount"] is DBNull ? null : (Decimal?)reader["Subsidy_Amount"]; } else { clsdbo_Subsidy = null; } reader.Close(); } catch (SqlException ex) { return(clsdbo_Subsidy); } finally { connection.Close(); } return(clsdbo_Subsidy); }
public static bool Update( dbo_SubsidyClass newdbo_SubsidyClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[SubsidyUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_SubsidyClass.Subsidy_ID != null) { updateCommand.Parameters.AddWithValue("@NewSubsidy_ID", newdbo_SubsidyClass.Subsidy_ID); } else { updateCommand.Parameters.AddWithValue("@NewSubsidy_ID", DBNull.Value); } if (newdbo_SubsidyClass.Clearing_No != null) { updateCommand.Parameters.AddWithValue("@NewClearing_No", newdbo_SubsidyClass.Clearing_No); } else { updateCommand.Parameters.AddWithValue("@NewClearing_No", DBNull.Value); } if (newdbo_SubsidyClass.Subsidy_Detail != null) { updateCommand.Parameters.AddWithValue("@NewSubsidy_Detail", newdbo_SubsidyClass.Subsidy_Detail); } else { updateCommand.Parameters.AddWithValue("@NewSubsidy_Detail", DBNull.Value); } if (newdbo_SubsidyClass.Subsidy_Amount.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewSubsidy_Amount", newdbo_SubsidyClass.Subsidy_Amount); } else { updateCommand.Parameters.AddWithValue("@NewSubsidy_Amount", 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) { return(false); } finally { connection.Close(); } }
public static bool Add(dbo_SubsidyClass clsdbo_Subsidy) { SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[dbo].[SubsidyInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_Subsidy.Subsidy_ID != null) { insertCommand.Parameters.AddWithValue("@Subsidy_ID", clsdbo_Subsidy.Subsidy_ID); } else { insertCommand.Parameters.AddWithValue("@Subsidy_ID", DBNull.Value); } if (clsdbo_Subsidy.Clearing_No != null) { insertCommand.Parameters.AddWithValue("@Clearing_No", clsdbo_Subsidy.Clearing_No); } else { insertCommand.Parameters.AddWithValue("@Clearing_No", DBNull.Value); } if (clsdbo_Subsidy.Subsidy_Detail != null) { insertCommand.Parameters.AddWithValue("@Subsidy_Detail", clsdbo_Subsidy.Subsidy_Detail); } else { insertCommand.Parameters.AddWithValue("@Subsidy_Detail", DBNull.Value); } if (clsdbo_Subsidy.Subsidy_Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Subsidy_Amount", clsdbo_Subsidy.Subsidy_Amount); } else { insertCommand.Parameters.AddWithValue("@Subsidy_Amount", 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) { return(false); } finally { connection.Close(); } }