/// <summary>
/// Заполняет поля
/// </summary>
/// <param name="row"></param>
/// <param name="item"></param>
public static void Fill(DataRow row, UsersPermission item)
{
item.PermissionId = DbTypes.ToInt32(row["UsersPermissionPermissionId"]);
item.UserId = DbTypes.ToInt32(row["UsersPermissionUserId"]);
item.OperatorId = DbTypes.ToInt32(row["UsersPermissionOperatorId"]);
}
public List <UsersPermission> SearchPermissions(string PermissionNo, string Status)
{
SqlCommand command = null;
SqlDataAdapter adapter = null;
List <UsersPermission> UsersPermissionList = null;
UsersPermission _objUsersPermission = null;
try
{
// Define the command.
command = mDbConnection.CreateCommand();
command.CommandText = "SearchUserPermissions";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@PermissionNo", SqlDbType.NVarChar).Value = PermissionNo;
command.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Status;
adapter = new SqlDataAdapter(command);
//Define the DataTable.
DataTable UsersPermissionDt = new DataTable();
adapter.Fill(UsersPermissionDt);
if (UsersPermissionDt.Rows.Count > 0)
{
UsersPermissionList = new List <UsersPermission>(UsersPermissionDt.Rows.Count);
foreach (DataRow row in UsersPermissionDt.Rows)
{
//create a instances for Project.
_objUsersPermission = new UsersPermission(Convert.ToInt32(row["PermissionId"]));
_objUsersPermission.PermissionId = Convert.ToInt32(row["PermissionId"]);
_objUsersPermission.PermissionNo = Convert.ToString(row["PermissionNo"]);
_objUsersPermission.PermissionName = Convert.ToString(row["PermissionName"]);
_objUsersPermission.CustomData.Add("LocationNames", Convert.ToString(row["LocationNames"]));
_objUsersPermission.IsActive = bool.Parse(Convert.ToString(row["IsActive"]));
_objUsersPermission.CustomData.Add("LastUpdateUserName", Convert.ToString(row["LastUpdateUserName"]));
_objUsersPermission.LastUpdateDate = DateTime.Parse(Convert.ToString(row["LastUpdateDate"]));
//Add to the List
UsersPermissionList.Add(_objUsersPermission);
}
}
return(UsersPermissionList);
}
catch { throw; }
finally
{
if (adapter != null)
{
adapter.Dispose();
}
if (command != null)
{
command.Dispose();
}
}
}
public int Delete(UsersPermission model)
{
string sql = "delete from UsersPermission where Id=@Id";
SqlParameter[] param =
{
new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
public Dictionary <string, List <string> > AllPermissions()
{
var dict = new Dictionary <string, List <string> >
{
{ typeof(UsersPermission).Name, UsersPermission.All() },
{ typeof(RolesPermission).Name, RolesPermission.All() }
};
return(dict);
}
/// <summary>
/// Возвращает список параметров, которые могут использоваться в запросах
/// </summary>
public static SqlParameter[] GetParameters(UsersPermission item)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@PermissionId", DbTypes.DbObject(item.PermissionId)));
parameters.Add(new SqlParameter("@UserId", DbTypes.DbObject(item.UserId)));
parameters.Add(new SqlParameter("@OperatorId", DbTypes.DbObject(item.OperatorId)));
return parameters.ToArray();
}
public int Add(UsersPermission model)
{
string sql = "insert into UsersPermission(RolesId,SystemMenuId) values(@RolesId,@SystemMenuId)";
SqlParameter[] param =
{
new SqlParameter("@RolesId", model.RolesId),
new SqlParameter("@SystemMenuId", model.SystemMenuId)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
/// <summary>
/// Получает список воздушных судов из запроса
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static List<UsersPermission> GetUsersPermissionList(DataTable table)
{
List<UsersPermission> items = new List<UsersPermission>();
for (int i=0; i < table.Rows.Count;i++)
{
UsersPermission item = new UsersPermission();
Fill(table.Rows[i], item);
items.Add(item);
}
//
return items;
}
public int Edit(UsersPermission model)
{
string sql = "update UsersPermission set RolesId = @RolesId,SystemMenuId=@SystemMenuId where Id=@Id";
SqlParameter[] param =
{
new SqlParameter("@RolesId", model.RolesId),
new SqlParameter("@SystemMenuId", model.SystemMenuId),
new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
public List <UsersPermission> GetUsersPermissionsByRolesId(int rid)
{
string sql = "select Id,RolesId,SystemMenuId from UsersPermission where RolesId = @RolesId";
SqlParameter[] param =
{
new SqlParameter("@RolesId", rid)
};
var dt = SqlHelper.Query(sql, param);
var list = new List <UsersPermission>();
foreach (DataRow dr in dt.Rows)
{
UsersPermission up = new UsersPermission()
{
Id = int.Parse(dr["Id"].ToString()),
RolesId = int.Parse(dr["RolesId"].ToString()),
SystemMenuId = int.Parse(dr["SystemMenuId"].ToString())
};
list.Add(up);
}
return(list);
}
public int Delete(UsersPermission model)
{
return(dal.Delete(model));
}
public int Edit(UsersPermission model)
{
return(dal.Edit(model));
}
public int Add(UsersPermission model)
{
return(dal.Add(model));
}
public void AddEditUserPermissions(UsersPermission Permission, List <PermissionAccess> PermissionAccessList, List <ClientAccess> ClientAccessList, List <ReportAccess> ReportAccessList)
{
SqlCommand command = null;
SqlTransaction transaction = null;
StringBuilder process = null;
try
{
process = new StringBuilder();
// Build xml criteria.
// Define command.
command = mDbConnection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Proc_AddEditUserPermissions";
command.Parameters.Add("@DataPermission", SqlDbType.Xml).Value = Permission.GetXml();
command.Parameters.Add("@DataPermissionAccess", SqlDbType.Xml).Value = PermissionAccess.GetXml(PermissionAccessList);
command.Parameters.Add("@DataClientAccess", SqlDbType.Xml).Value = ClientAccess.GetXml(ClientAccessList);
command.Parameters.Add("@DataReportAccess", SqlDbType.Xml).Value = ReportAccess.GetXml(ReportAccessList);
command.Parameters.Add("@hasError", SqlDbType.Bit).Direction = ParameterDirection.Output;
command.Parameters.Add("@ErrorMessage", SqlDbType.VarChar, 255).Direction = ParameterDirection.Output;
try
{
// Execute command within transaction.
transaction = mDbConnection.BeginTransaction();
command.Transaction = transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
catch
{
if (transaction != null)
{
if (transaction.Connection != null)
{
transaction.Rollback();
}
}
throw;
}
// Get output parameters.
bool IshasError = bool.Parse(command.Parameters["@hasError"].Value.ToString());
string errorMessage = command.Parameters["@ErrorMessage"].Value.ToString();
if (IshasError)
{
// Create exception instance.
ValidationException exception = new ValidationException("Validation error occurred.");
exception.Data.Add("PERMISSION_Error", errorMessage);
throw exception;
}
}
catch { throw; }
finally
{
if (transaction != null)
{
transaction.Dispose();
}
if (command != null)
{
command.Dispose();
}
}
}
private void AddToUsers_Click(object sender, EventArgs e)
{
if (User_Name.Text == "" || Email.Text == "" || Password.Text == "")
{
MessageBox.Show("Inputs cant be empty", "Invalid inputs", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
user.insert(User_Name.Text, Email.Text, Password.Text);
dgv_users.DataSource = user.SelectAll();
Reset();
if (ViewOnly_Stock.Checked)
{
this.stockPermission[0] = true;
}
else
{
if (Insert_Stock.Checked)
{
this.stockPermission[1] = true;
}
if (Update_Stock.Checked)
{
this.stockPermission[2] = true;
}
if (Delete_Stock.Checked)
{
this.stockPermission[3] = true;
}
}
if (ViewOnly_Users.Checked)
{
this.usersPermission[0] = true;
}
else
{
if (Insert_Users.Checked)
{
this.usersPermission[1] = true;
}
if (Update_Users.Checked)
{
this.usersPermission[2] = true;
}
if (Delete_Users.Checked)
{
this.usersPermission[3] = true;
}
}
if (ViewOnly_Bills.Checked)
{
this.stockPermission[0] = true;
}
else
{
if (Insert_Bills.Checked)
{
this.billsPermission[1] = true;
}
if (Update_Bills.Checked)
{
this.billsPermission[2] = true;
}
if (Delete_Bills.Checked)
{
this.billsPermission[3] = true;
}
}
IPermission p = new UserPermission();
StockPermission s = new StockPermission(p, stockPermission);
BillsPermission b = new BillsPermission(s, billsPermission);
UsersPermission u = new UsersPermission(b, usersPermission);
IPermission permissions = u;
permissions.addPermission();
for (int i = 0; i < stockPermission.Length; i++)
{
stockPermission[i] = false;
}
for (int i = 0; i < billsPermission.Length; i++)
{
billsPermission[i] = false;
}
for (int i = 0; i < usersPermission.Length; i++)
{
usersPermission[i] = false;
}
}
}
private int AddEditPermissions()
{
int id = 0;
try
{
UsersPermission _objUsersPermission = new UsersPermission(PermissionId);
_objUsersPermission.PermissionId = PermissionId;
_objUsersPermission.PermissionName = lblPermissionName.Text;
_objUsersPermission.LastUpdateUserId = mAppManager.LoginUser.Id;
if (UIMODEPERMISSION == UIMODEPERMISSION.EDIT)
{
_objUsersPermission.IsActive = chkActive.Checked;
_objUsersPermission.Reason = Convert.ToString(txtReason.Value);
}
//*** Locations and Departments ***//
List <PermissionAccess> _objPermissionAccessList = new List <PermissionAccess>();
foreach (TreeNode node in tvLocations.Nodes)
{
//If node has child nodes
if (node.Checked == true) //it is better to first check if it is "checked" then proceed to count child nodes
{
int _objLocationId = string.IsNullOrEmpty(node.Value) ? 0 : Convert.ToInt32(node.Value);
if (node.ChildNodes.Count > 0) //check if node has any child nodes
{
//Check all the child nodes.
foreach (TreeNode childNode in node.ChildNodes)
{
if (childNode.Checked == true)
{
PermissionAccess _objPermissionAccess = new PermissionAccess();
_objPermissionAccess.LocationId = _objLocationId;
_objPermissionAccess.DepartmentId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value);
_objPermissionAccessList.Add(_objPermissionAccess);
}
}
}
}
}
//*** Clients ***//
List <ClientAccess> _objClientAccessList = new List <ClientAccess>();
foreach (TreeNode node in tvClients.Nodes)
{
if (node.Checked == true)
{
if (node.ChildNodes.Count > 0) //check if node has any child nodes
{
//Check all the child nodes.
foreach (TreeNode childNode in node.ChildNodes)
{
if (childNode.Checked == true)
{
_objClientAccessList.Add(new ClientAccess {
ClientId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value)
});
}
}
}
}
}
//*** Reports ***//
List <ReportAccess> _objReportAccessList = new List <ReportAccess>();
foreach (TreeNode node in tvReports.Nodes)
{
if (node.Checked == true)
{
if (node.ChildNodes.Count > 0) //check if node has any child nodes
{
//Check all the child nodes.
foreach (TreeNode childNode in node.ChildNodes)
{
if (childNode.Checked == true)
{
_objReportAccessList.Add(new ReportAccess {
ReportId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value)
});
}
}
}
}
}
IUsersProfile mUserProfile = null;
mUserProfile = AppService.Create <IUsersProfile>();
mUserProfile.AppManager = this.mAppManager;
mUserProfile.AddEditUserPermissions(_objUsersPermission, _objPermissionAccessList, _objClientAccessList, _objReportAccessList);
id = 1;
}
catch (ValidationException ve)
{
throw ve;
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
