public PaymentObject GetPaymentById(int id)
{
PaymentObject payment = new PaymentObject();
try
{
db.OpenConnection();
string sql = $"Select * From tbl_Payment WHERE ID = '{id}'";
SqlCommand myCommand = new SqlCommand(sql, db._connection);
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
while (myDataReader.Read())
{
payment.paymentId = int.Parse(myDataReader["ID"].ToString());
payment.payment = myDataReader["Provider"].ToString();
payment.service = myDataReader["Service"].ToString();
payment.price = decimal.Parse(myDataReader["Price"].ToString());
}
}
}
catch
{
return(null);
}
finally
{
db.CloseConnection();
}
return(payment);
}
internal List <PaymentObject> GetAllPayments()
{
List <PaymentObject> result = new List <PaymentObject>();
try
{
db.OpenConnection();
string sql = "Select * From tbl_Payment";
SqlCommand myCommand = new SqlCommand(sql, db._connection);
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
while (myDataReader.Read())
{
PaymentObject p = new PaymentObject();
p.paymentId = int.Parse(myDataReader["ID"].ToString());
p.service = myDataReader["Service"].ToString();
p.price = decimal.Parse(myDataReader["Price"].ToString());
p.payment = myDataReader["Provider"].ToString();
result.Add(p);
}
return(result);
}
}
catch
{
return(null);
}
finally
{
db.CloseConnection();
}
}
public void UppdatePayment(PaymentObject payment, int id)
{
try
{
db.OpenConnection();
string sql = $"UPDATE tbl_Payment SET Provider = '{payment.payment}', Service = '{payment.service}', Price = '{payment.price}' WHERE ID = '{id}'";
SqlCommand insertCmd = new SqlCommand(sql, db._connection);
insertCmd.ExecuteNonQuery();
}
catch
{
//TODO Exeption
}
finally
{
db.CloseConnection();
}
}
public void AddPayment(PaymentObject payment)
{
try
{
db.OpenConnection();
string sql = $"Insert Into tbl_Payment (Provider, Service, Price ) Values('{payment.payment}', '{payment.service}', '{payment.price}' )";
SqlCommand insertCmd = new SqlCommand(sql, db._connection);
insertCmd.ExecuteNonQuery();
}
catch
{
//TODO exeption
}
finally
{
db.CloseConnection();
}
}