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; } }