public List <Activity_Log> listActivityLogs(string i_log_date_str, string i_log_date_end, string i_Account_id, string i_Company_id, int i_row_str, int i_row_limit)
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("g_activity_logs", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@i_log_date_str", i_log_date_str);
cmd.Parameters.AddWithValue("@i_log_date_end", i_log_date_end);
cmd.Parameters.AddWithValue("@i_Account_id", i_Account_id);
cmd.Parameters.AddWithValue("@i_Company_id", i_Company_id);
cmd.Parameters.AddWithValue("@i_row_str", i_row_str);
cmd.Parameters.AddWithValue("@i_row_limit", i_row_limit);
MySqlDataReader reader = cmd.ExecuteReader();
int defaultNum = 0;
string defaultString = "";
List <Activity_Log> list_data = new List <Activity_Log>();
while (reader.Read())
{
Activity_Log act_log = new Activity_Log();
act_log.log_id = reader.IsDBNull(0) ? defaultString : reader.GetString(0);
act_log.log_date = reader.IsDBNull(1) ? defaultString : reader.GetString(1);
act_log.log_details = reader.IsDBNull(2) ? defaultString : reader.GetString(2);
act_log.acc_lgn = new Account_Login();
act_log.acc_lgn.Account_id = reader.IsDBNull(3) ? defaultString : reader.GetString(3);
act_log.acc_lgn.Account_F_name = reader.IsDBNull(4) ? defaultString : reader.GetString(4);
act_log.acc_lgn.Account_N_Name = reader.IsDBNull(5) ? defaultString : reader.GetString(5);
act_log.bs_cpn = new Base_Companys();
act_log.bs_cpn.Company_id = reader.IsDBNull(6) ? defaultNum : reader.GetInt32(6);
act_log.bs_cpn.Company_code = reader.IsDBNull(7) ? defaultString : reader.GetString(7);
act_log.bs_cpn.Company_N_name = reader.IsDBNull(8) ? defaultString : reader.GetString(8);
act_log.bs_cpn.Company_F_name = reader.IsDBNull(9) ? defaultString : reader.GetString(9);
list_data.Add(act_log);
}
return(list_data);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Manager_Account --> Activity_Log_Manager --> listActivityLogs() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Manager_Account --> Activity_Log_Manager --> listActivityLogs() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
con.Dispose();
}
}
protected void Login_btn_Click(object sender, EventArgs e)
{
string username = Username_TBx.Text;
string password = Password_TBx.Text;
string ipAdd = Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? Request.ServerVariables["REMOTE_ADDR"];
if (ConnectRTAFService.AuthenUserWithADDS(username, password))
{
Admin_Users au = new Admin_User_Manager().GetCheckAdministratorLevel(username);
if (au.Admin_User_Type.Admin_Users_Type_id == 1)
{
Activity_Log log = new Activity_Log()
{
Act_log_user = au.Admin_Users_Name,
Act_log_ip = ipAdd,
Act_log_details = "LGN_ADM : Admin Authenicated and Sign-in Success"
};
new Activity_Log_Manager().AddActivityLogs(log);
Session["admin_user"] = au;
Response.Redirect("/Form_Main/Form_MainPage");
}
else if (au.Admin_User_Type.Admin_Users_Type_id == 2)
{
Activity_Log log = new Activity_Log()
{
Act_log_user = au.Admin_Users_Name,
Act_log_ip = ipAdd,
Act_log_details = "LGN_UADM : Unit Admin Authenicated and Sign-in Success"
};
new Activity_Log_Manager().AddActivityLogs(log);
Session["admin_user"] = au;
Response.Redirect("/Form_Main/Form_MainPage");
}
else if (au.Admin_User_Type.Admin_Users_Type_id == 3)
{
Activity_Log log = new Activity_Log()
{
Act_log_user = au.Admin_Users_Name,
Act_log_ip = ipAdd,
Act_log_details = "LGN_SADM : Super Admin Authenicated and Sign-in Success"
};
new Activity_Log_Manager().AddActivityLogs(log);
Session["admin_user"] = au;
Response.Redirect("/Form_Main/Form_MainPage");
}
else
{
Activity_Log log = new Activity_Log()
{
Act_log_user = username,
Act_log_ip = ipAdd,
Act_log_details = "LGN_NMU : Normal User Authenicated and Sign-in Success"
};
new Activity_Log_Manager().AddActivityLogs(log);
Response.Redirect("/Form_Main/Form_MainPage");
}
}
else
{
Activity_Log log = new Activity_Log()
{
Act_log_user = username,
Act_log_ip = ipAdd,
Act_log_details = "LGN_WAR : Unknown User Attempting Sign in System With Authenticate"
};
new Activity_Log_Manager().AddActivityLogs(log);
}
//Admin_Users au = new Admin_Users()
//{
// Admin_User_Type = new Admin_Users_Type()
// {
// Admin_Users_Type_id = 3,
// Admin_Users_Type_Name = "Super Admin"
// }
//};
//Session["admin_user"] = au;
//Response.Redirect("/Form_Main/Form_MainPage");
}
