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