//filter method
public List <View_rem_user> filterUsers(int filter)
{
try
{
List <View_rem_user> lu = new List <View_rem_user>();
string sql = @"SELECT * FROM VIEW_REM_USER t WHERE " + getCondition(filter);
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
sqlConnection.Open();
SqlDataReader reader = cmd.ExecuteReader();
rowCount = 0;
rowGroup = 0;
int rowGeneral = 0;
while (reader.Read())
{
rowCount++;
rowGeneral++;
View_rem_user u = new View_rem_user();
u.id_user = reader.GetInt32(0);
u.fk_id_rem_user_type = SafeGetInt(reader, 1);
u.user_type_name = SafeGetString(reader, 2);
u.user = SafeGetInt(reader, 3);
u.office_name = SafeGetString(reader, 4);
u.full_name = 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.is_active = SafeGetInt(reader, 11);
u.is_deleted = SafeGetInt(reader, 12);
u.tag = SafeGetInt(reader, 13);
u.subscriber_tag = SafeGetInt(reader, 14);
u.last_request_date = SafeGetDate(reader, 15);
u.version = SafeGetString(reader, 16);
u.last_request_result = SafeGetInt(reader, 17);
u.payment_date = SafeGetDate(reader, 18);
u.reminder_date = SafeGetDate(reader, 19);
u.reminder_note = SafeGetString(reader, 20);
u.utils = utils(u, rowGeneral);
lu.Add(u);
}
sqlConnection.Close();
return(lu);
}
catch (Exception ex)
{
sqlConnection.Close();
throw ex;
}
}
public Util utils(View_rem_user item, int rowGeneral)
{
Util u = new Util();
string s = "";
if (item.is_active == 1)
{
s = "Aktiv";
u.trFontStyle = "normal";
}
else
{
s = "Deaktiv";
u.trFontStyle = "italic";
};
u.trBgColor = item.fk_id_rem_user_type == 2 ? "#e8e8e8" : "white";
u.last_request_period = Convert.ToInt32(DateTime.Now.Subtract(Convert.ToDateTime(item.last_request_date)).TotalDays);
if (u.last_request_period <= 2)
{
u.status = s + ", Yaxşı";
u.trTextColor = "green";
rowCount = rowGroup != 1 ? 1 : rowCount;
rowGroup = 1;
}
else if (u.last_request_period <= 12)
{
u.status = s + ", Normal";
u.trTextColor = "black";
rowCount = rowGroup != 2 ? 1 : rowCount;
rowGroup = 2;
}
else if (u.last_request_period >= 12 && u.last_request_period <= 24)
{
u.status = s + ", Gecikmə";
u.trTextColor = "#CA6F1E";
rowCount = rowGroup != 3 ? 1 : rowCount;
rowGroup = 3;
}
else if (u.last_request_period > 24 && u.last_request_period <= 36)
{
u.status = s + ", Gecikmə +24";
u.trTextColor = "#C0392B";
rowCount = rowGroup != 4 ? 1 : rowCount;
rowGroup = 4;
}
else if (u.last_request_period > 36)
{
u.status = s + ", Gecikmə +36";
u.trTextColor = "#78281F";
rowCount = rowGroup != 5 ? 1 : rowCount;
rowGroup = 5;
}
u.rowCount = rowCount;
u.rowGeneral = rowGeneral;
u.reminderColor = item.reminder_date != null && item.reminder_date != DateTime.MinValue ? DateTime.Now >= item.reminder_date ? "bgcolor04" : "" : "";
u.readingStatusLastDate = item.last_request_date != null?Convert.ToDateTime(item.last_request_date).ToString("yyyy-MM-dd hh:mm:ss") : DateTime.MinValue.ToString("yyyy-MM-dd hh:mm:ss");
u.readingStatusHours = Convert.ToInt32(DateTime.Now.Subtract(Convert.ToDateTime(item.last_request_date)).TotalHours);
u.readingStatusVersion = " versiya : " + item.version + ", elan: " + item.last_request_result;
u.subscriberColor = item.subscriber_tag == 1 ? "bgcolor03" : item.subscriber_tag == 2 ? "bgcolor05" : "";
u.tagColor = item.tag == 1 ? "bgcolor02" : "";
return(u);
}
