public void paymentCalculation(fee f, gymMember g)
{
if (string.IsNullOrWhiteSpace(f.lastVPaymentDate))
{
f.lastVPaymentDate = g.joinedDate;
}
}
public bool addFee(fee f, gymMember g)
{
try
{
paymentCalculation(f, g);
DataLayer.dbConnect dbfee = new DataLayer.dbConnect();
dbfee.openConnection();
string qf1 = "insert into tbl_fee (amount,service,valde_date,paid_date,paid_time,memberID) values(@amount,@service,@valid_date,@paid_date,@paidTime,@memerID)";
SqlCommand cmd1 = new SqlCommand(qf1, dbfee.getConnection());
cmd1.Parameters.AddWithValue("@amount", f.newAmount);
cmd1.Parameters.AddWithValue("@service", f.service);
cmd1.Parameters.AddWithValue("@valid_date", f.PaymentvalidDate);
cmd1.Parameters.AddWithValue("@paid_date", f.paidDate);
cmd1.Parameters.AddWithValue("@memerID", f.memberID);
cmd1.Parameters.AddWithValue("@paidTime", f.paidTime);
cmd1.ExecuteNonQuery();
return(true);
}
catch (Exception ext)
{
MessageBox.Show(ext.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
public bool checkPaymentDetails(fee f)
{
DataLayer.dbConnect fpay = new DataLayer.dbConnect();
fpay.openConnection();
string qf = "select * from tbl_fee where memberID=@id and feeID = (select max(feeID) from tbl_fee) ";
SqlCommand cmdf = new SqlCommand(qf, fpay.getConnection());
cmdf.Parameters.AddWithValue("@id", f.memberID);
DataTable dtx = new DataTable();
SqlDataAdapter daf = new SqlDataAdapter(cmdf);
bool testf1 = false;
daf.Fill(dtx);
if (dtx.Rows.Count > 0)
{
f.LastPaid_amount = double.Parse(dtx.Rows[0]["amount"].ToString());
f.service = dtx.Rows[0]["service"].ToString();
f.lastVPaymentDate = dtx.Rows[0]["valde_date"].ToString();
f.lastPaidDate = dtx.Rows[0]["paid_date"].ToString();
f.lastPaidTime = dtx.Rows[0]["paid_time"].ToString();
testf1 = true;
}
if (testf1 == true)
{
return(true);
}
else
{
return(false);
}
}