public bool InsertDonation(DonationModel donationDetails)
{
GenericInitialization gen = new GenericInitialization();
try
{
using (gen.sqlConnection = new SqlConnection(gen.connectionString))
{
gen.sqlConnection.Open();
gen.queryString = "INSERT INTO [ReachHelp].[dbo].[Donations] VALUES(GETDATE(),@donatedBy,@amount,@transactionId,@status)";
using (gen.sqlCommand = new SqlCommand(gen.queryString, gen.sqlConnection))
{
gen.sqlCommand.Parameters.AddWithValue("@donatedBy", donationDetails.donatedBy);
gen.sqlCommand.Parameters.AddWithValue("@amount", donationDetails.amount);
gen.sqlCommand.Parameters.AddWithValue("@transactionId", donationDetails.transactionId);
gen.sqlCommand.Parameters.AddWithValue("@status", donationDetails.status);
//gen.sqlCommand.Parameters.AddWithValue("@remarks", donationDetails.remarks);
if (gen.sqlCommand.ExecuteNonQuery() > 0)
{
return(true);
}
}
}
}
catch (SqlException ex)
{
return(false);
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public List <IDonations> DonationDetails(DonationModel donationDetails)
{
GenericInitialization gen = new GenericInitialization();
List <IDonations> donationInfo = new List <IDonations>();
try
{
using (gen.sqlConnection = new SqlConnection(gen.connectionString))
{
gen.sqlConnection.Open();
gen.queryString = "SELECT [Sl_No],[Donation_Date],UR.[User_Id],UR.[User_Name],[Amount],[Transaction_Id],[Status] FROM [ReachHelp].[dbo].[Donations]D JOIN [ReachHelp].[dbo].[User_Register]UR ON UR.User_Id=D.User_Id WHERE [User_Id] = CASE @donatedBy='' THEN [User_Id] ELSE @userId END ";
using (gen.sqlCommand = new SqlCommand(gen.queryString, gen.sqlConnection))
{
gen.sqlCommand.Parameters.AddWithValue("@donatedBy", donationDetails.donatedBy);
using (gen.sqlDataReader = gen.sqlCommand.ExecuteReader())
{
if (gen.sqlDataReader.HasRows)
{
while (gen.sqlDataReader.Read())
{
donationInfo.Add(new DonationModel
{
donationDate = gen.sqlDataReader["Donation_Date"].ToString(),
donatedBy = Int64.Parse(gen.sqlDataReader["User_Id"].ToString()),
amount = Int64.Parse(gen.sqlDataReader["Amount"].ToString()),
transactionId = gen.sqlDataReader["Transaction_Id"].ToString(),
status = gen.sqlDataReader["Status"].ToString(),
userName = gen.sqlDataReader["User_Name"].ToString(),
donationId = gen.sqlDataReader["Sl_No"].ToString()
});
}
}
}
}
}
}
catch (SqlException ex)
{
donationInfo.Add(new DonationModel
{
error = "Error"
});
}
catch (Exception ex)
{
donationInfo.Add(new DonationModel
{
error = "Error"
});
}
return(donationInfo);
}