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