public ActionResult updateUser(Rem_user item)
{
item = correctInputs(item);
bool result = methods.updateUser(item);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool addUser(Rem_user item)
{
try
{
List <Rem_user_note> lu = new List <Rem_user_note>();
string sql = @"INSERT INTO rem_user
([user], office_name, full_name, reference, MAC, service_price, phone_number,
phone_number_ex, email_address, start_date, reading_data_count, fk_id_rem_user_type, believe,
is_active, fk_id_message_type, last_IP, last_request_date, last_request_result, version, note,
subscriber_tag, tag, is_deleted, additional_client)
VALUES (@user, @office_name, @full_name, @reference, @MAC, @service_price, @phone_number,
@phone_number_ex, @email_address, @start_date, @reading_data_count, @fk_id_rem_user_type, @believe,
@is_active, @fk_id_message_type, @last_IP, @last_request_date, @last_request_result, @version, @note,
@subscriber_tag, @tag, @is_deleted, @additional_client)";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.AddWithValue("@user", item.user);
cmd.Parameters.AddWithValue("@office_name", item.office_name);
cmd.Parameters.AddWithValue("@full_name", item.full_name);
cmd.Parameters.AddWithValue("@reference", item.reference);
cmd.Parameters.AddWithValue("@MAC", item.MAC);
cmd.Parameters.AddWithValue("@service_price", item.service_price);
cmd.Parameters.AddWithValue("@phone_number", item.phone_number);
cmd.Parameters.AddWithValue("@phone_number_ex", item.phone_number_ex);
cmd.Parameters.AddWithValue("@email_address", item.email_address);
cmd.Parameters.AddWithValue("@start_date", item.start_date);
cmd.Parameters.AddWithValue("@reading_data_count", item.reading_data_count);
cmd.Parameters.AddWithValue("@fk_id_rem_user_type", item.fk_id_rem_user_type);
cmd.Parameters.AddWithValue("@believe", item.believe);
cmd.Parameters.AddWithValue("@is_active", item.is_active);
cmd.Parameters.AddWithValue("@fk_id_message_type", item.fk_id_message_type);
cmd.Parameters.AddWithValue("@last_IP", item.last_IP);
cmd.Parameters.AddWithValue("@last_request_date", item.last_request_date);
cmd.Parameters.AddWithValue("@last_request_result", item.last_request_result);
cmd.Parameters.AddWithValue("@version", item.version);
cmd.Parameters.AddWithValue("@note", item.note);
cmd.Parameters.AddWithValue("@subscriber_tag", item.subscriber_tag);
cmd.Parameters.AddWithValue("@tag", item.tag);
cmd.Parameters.AddWithValue("@is_deleted", item.is_deleted);
cmd.Parameters.AddWithValue("@additional_client", item.additional_client);
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
catch (Exception ex)
{
sqlConnection.Close();
return(false);
}
}
//update user methods
public Rem_user getUserInfoForUpdateUser(int id_user)
{
try
{
string sql = @"SELECT id_rem_user, [user], office_name, full_name, reference, MAC, service_price, phone_number,
phone_number_ex, email_address, start_date, reading_data_count, fk_id_rem_user_type, believe,
fk_id_message_type, last_IP, last_request_date, last_request_result, version, note, tag, is_active, is_deleted, subscriber_tag
FROM rem_user WHERE id_rem_user=@id_user";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.AddWithValue("@id_user", id_user);
sqlConnection.Open();
SqlDataReader reader = cmd.ExecuteReader();
Rem_user u = new Rem_user();
while (reader.Read())
{
u.id_rem_user = reader.GetInt32(0);
u.user = SafeGetInt(reader, 1);
u.office_name = SafeGetString(reader, 2);
u.full_name = SafeGetString(reader, 3);
u.reference = SafeGetString(reader, 4);
u.MAC = SafeGetString(reader, 5);
u.service_price = SafeGetInt(reader, 6);
u.phone_number = SafeGetString(reader, 7);
u.phone_number_ex = SafeGetString(reader, 8);
u.email_address = SafeGetString(reader, 9);
u.start_date = SafeGetDate(reader, 10);
u.reading_data_count = reader.GetInt32(11);
u.fk_id_rem_user_type = SafeGetInt(reader, 12);
u.believe = SafeGetInt(reader, 13);
u.fk_id_message_type = SafeGetInt(reader, 14);
u.last_IP = SafeGetString(reader, 15);
u.last_request_date = SafeGetDate(reader, 16);
u.last_request_result = SafeGetInt(reader, 17);
u.version = SafeGetString(reader, 18);
u.note = SafeGetString(reader, 19);
u.tag = SafeGetInt(reader, 20);
u.is_active = SafeGetInt(reader, 21);
u.is_deleted = SafeGetInt(reader, 22);
u.subscriber_tag = SafeGetInt(reader, 23);
}
sqlConnection.Close();
return(u);
}
catch (Exception ex)
{
sqlConnection.Close();
throw ex;
}
}
public Rem_user correctInputs(Rem_user item)
{
if (item.is_deleted == null)
{
item.is_deleted = 0;
}
if (item.is_active == null)
{
item.is_active = 0;
}
if (item.subscriber_tag == null)
{
item.subscriber_tag = 0;
}
if (item.tag == null)
{
item.tag = 0;
}
if (item.believe == null)
{
item.believe = 0;
}
if (item.additional_client == null)
{
item.additional_client = 0;
}
if (item.MAC == null)
{
item.MAC = "";
}
if (item.last_IP == null)
{
item.last_IP = "";
}
if (item.last_request_result == null)
{
item.last_request_result = 0;
}
return(item);
}
public ActionResult getUserInfoForUpdateUser(int id_user)
{
Rem_user result = methods.getUserInfoForUpdateUser(id_user);
return(Json(result, JsonRequestBehavior.AllowGet));
}
