public ActionResult addReminder(Rem_user_reminder item)
{
item.is_deleted = 0;
item.IP = GetIPAddress();
item.date = DateTime.Now;
bool result = methods.addReminder(item);
return(Json(result, JsonRequestBehavior.AllowGet));
}
//reminder methods
public bool addReminder(Rem_user_reminder item)
{
try
{
List <Rem_user_reminder> lu = new List <Rem_user_reminder>();
string sql = @"INSERT INTO rem_user_reminder
(fk_id_rem_user, date, reminder_date, IP, note, is_deleted)
VALUES (@fk_id_rem_user, @date, @reminder_date, @IP, @note, @is_deleted)";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
SqlParameter[] p = new SqlParameter[6];
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 = "@reminder_date";
p[2].Value = item.reminder_date;
p[3] = new SqlParameter();
p[3].ParameterName = "@IP";
p[3].Value = item.IP;
p[4] = new SqlParameter();
p[4].ParameterName = "@note";
p[4].Value = item.note;
p[5] = new SqlParameter();
p[5].ParameterName = "@is_deleted";
p[5].Value = item.is_deleted;
cmd.Parameters.AddRange(p);
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
catch (Exception ex)
{
sqlConnection.Close();
return(false);
}
}
