public ExecuteModels DelPermission(PermissionModels val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseAuth())
{
string _SQL = "delete from [permission] where permission_id = " + val.permission_id;
SqlCommand cmd = new SqlCommand(_SQL, con);
try
{
if (Int32.Parse(cmd.ExecuteNonQuery().ToString()) >= 1)
{
ecm.result = 0;
ecm.code = "OK";
}
else
{
ecm.result = 1;
ecm.code = _SQL;
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
con.Close();
}
return(ecm);
}
public List <PermissionModels> GetPermissionAll()
{
HomeController hc = new HomeController();
List <PermissionModels> ul = new List <PermissionModels>();
using (SqlConnection con = hc.ConnectDatabaseAuth())
{
string _SQL = "select * from permission";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
DataTable _Dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
foreach (DataRow _Item in _Dt.Rows)
{
PermissionModels m = new PermissionModels();
m.permission_id = _Item["permission_id"].ToString();
m.access_id = _Item["access_id"].ToString();
m.app_id = _Item["app_id"].ToString();
m.group_id = _Item["group_id"].ToString();
ul.Add(m);
}
}
con.Close();
}
return(ul);
}
public ExecuteModels InsertPermission(PermissionModels val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseAuth())
{
string _SQL = "insert into [permission] (group_id, app_id, access_id, create_by_user_id) output inserted.permission_id " +
"values (N'" + val.group_id + "', N'" + val.app_id + "', '" + val.access_id + "', 1)";
SqlCommand cmd = new SqlCommand(_SQL, con);
try
{
var id_return = Int32.Parse(cmd.ExecuteScalar().ToString());
if (id_return >= 1)
{
ecm.result = 0;
ecm.code = "OK";
ecm.id_return = id_return.ToString();
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
con.Close();
}
return(ecm);
}
public LoginViews CheckLogin(LoginModels val)
{
LoginViews lm = new LoginViews();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseAuth())
{
string _SQL = "select * from account where username = '******' and password = '******'";
SqlCommand cmd = new SqlCommand(_SQL, con);
DataTable _Dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
if (_Dt.Rows.Count > 0)
{
lm.user_id = _Dt.Rows[0]["user_id"].ToString();
lm.firstname = _Dt.Rows[0]["firstname"].ToString();
lm.lastname = _Dt.Rows[0]["lastname"].ToString();
lm.tel = _Dt.Rows[0]["tel"].ToString();
lm.address = _Dt.Rows[0]["address"].ToString();
lm.email = _Dt.Rows[0]["email"].ToString();
lm.group_id = _Dt.Rows[0]["group_id"].ToString();
_SQL = "select * from permission where group_id = " + lm.group_id;
cmd = new SqlCommand(_SQL, con);
_Dt = new DataTable();
da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
foreach (DataRow _Item in _Dt.Rows)
{
PermissionModels p = new PermissionModels();
p.app_id = _Item["app_id"].ToString();
p.access_id = _Item["access_id"].ToString();
lm.lsPermission.Add(p);
}
}
con.Close();
}
return(lm);
}
