public ActionResult addPayment(Rem_user_payment item)
{
item.id_deleted = 0;
item.IP = GetIPAddress();
item.date = DateTime.Now;
bool result = methods.addPayment(item);
return(Json(result, JsonRequestBehavior.AllowGet));
}
//payment methoda
public bool addPayment(Rem_user_payment item)
{
try
{
string sql = @"INSERT INTO rem_user_payment
(fk_id_rem_user, date, payment_date, sum, note, IP, id_deleted)
VALUES (@fk_id_rem_user, @date, @payment_date, @sum, @note, @IP, @is_deleted)";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
SqlParameter[] p = new SqlParameter[7];
p[0] = new SqlParameter();
p[0].ParameterName = "@fk_id_rem_user";
p[0].Value = item.fk_id_rem_user;
p[1] = new SqlParameter();
p[1].ParameterName = "@date";
p[1].Value = item.date;
p[2] = new SqlParameter();
p[2].ParameterName = "@payment_date";
p[2].Value = item.payment_date;
p[3] = new SqlParameter();
p[3].ParameterName = "@sum";
p[3].Value = item.sum;
p[4] = new SqlParameter();
p[4].ParameterName = "@note";
p[4].Value = item.note;
p[5] = new SqlParameter();
p[5].ParameterName = "@IP";
p[5].Value = item.IP;
p[6] = new SqlParameter();
p[6].ParameterName = "@is_deleted";
p[6].Value = item.id_deleted;
cmd.Parameters.AddRange(p);
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
catch (Exception ex)
{
sqlConnection.Close();
return(false);
}
}
public List <Rem_user_payment> showPayment(int userId)
{
try
{
List <Rem_user_payment> lu = new List <Rem_user_payment>();
string sql = @"SELECT * FROM rem_user_payment WHERE fk_id_rem_user=@userId";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter();
p[0].ParameterName = "@userId";
p[0].Value = userId;
cmd.Parameters.AddRange(p);
sqlConnection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Rem_user_payment u = new Rem_user_payment();
u.id_user_payment = reader.GetInt32(0);
u.fk_id_rem_user = SafeGetInt(reader, 1);
u.date = SafeGetDate(reader, 2);
u.payment_date = SafeGetDate(reader, 3);
u.sum = SafeGetInt(reader, 4);
u.note = SafeGetString(reader, 5);
u.IP = SafeGetString(reader, 6);
u.id_deleted = SafeGetInt(reader, 7);
lu.Add(u);
}
sqlConnection.Close();
return(lu);
}
catch (Exception ex)
{
sqlConnection.Close();
throw ex;
}
}
