public string SavePermissionType(PermissionTypeModels permissionTypeModel)
{
PermissionTypeDTO permissionType = new PermissionTypeDTO();
MessageDTO message = new MessageDTO();
permissionType.Company = new CompanyDTO {
CompanyId = Convert.ToInt32(permissionTypeModel.CompanyId)
};
permissionType.User = new UserDTO {
UserId = Convert.ToInt32(permissionTypeModel.UserId)
};
permissionType.PermissionTypeDescription = permissionTypeModel.PermissionTypeDescription;
permissionType.PermissionTypeId = Convert.ToInt32(permissionTypeModel.Id);
permissionType.PermissionTypeType = permissionTypeModel.PermissionTypeType;
permissionType.PermissionTypeStatus = permissionTypeModel.PermissionTypeStatus;
if (String.Compare(permissionTypeModel.Operation, "add", StringComparison.Ordinal) == 0)
{
message = business.SavePermissionType(permissionType, "I");
}
else if (String.Compare(permissionTypeModel.Operation, "edit", StringComparison.Ordinal) == 0)
{
message = business.SavePermissionType(permissionType, "U");
}
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
public PermissionTypeDTO ToDTO(PermissionTypeEntity entity)
{
PermissionTypeDTO dto = new PermissionTypeDTO();
dto.CreateTime = entity.CreateTime;
dto.Description = entity.Description;
dto.Id = entity.Id;
dto.Name = entity.Name;
return(dto);
}
/// <summary>
///
/// </summary>
/// <param name="whereClause"></param>
/// <param name="dataTable"></param>
/// <returns></returns>
public List <PermissionTypeDTO> GetPermissionTypes(Dictionary <string, string> whereClause, ref DataTable dataTable)
{
DataSet dataSet = new DataSet();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
var permissionTypes = new List <PermissionTypeDTO>();
int companyId = Convert.ToInt32(whereClause["companyId"]);
int pageSize = Convert.ToInt32(whereClause["pageSize"]);
int pageNumber = Convert.ToInt32(whereClause["pageNumber"]);
string sortColumn = whereClause["sortColumn"].ToString();
string sortOrder = whereClause["sortOrder"].ToString();
try
{
//Todos los registros
object[] parameters = new object[] { companyId, pageSize, pageNumber, sortColumn, sortOrder };
connector.FillDataSet(dataSet, CommandType.StoredProcedure, "GetPermissionTypes", parameters);
if (dataSet.Tables[1].Rows.Count > 0)
{
dataTable = dataSet.Tables[0];
foreach (DataRow row in dataSet.Tables[1].Rows)
{
PermissionTypeDTO permissionType = new PermissionTypeDTO
{
Company = new CompanyDTO {
CompanyId = Convert.ToInt32(row["COMPANY_ID"])
},
PermissionTypeDescription = row["PERMISSION_TYPE_DESCRIPTION"].ToString(),
PermissionTypeId = Convert.ToInt32(row["PERMISSION_TYPE_ID"]),
PermissionTypeStatus = row["PERMISSION_TYPE_STATUS"].ToString(),
PermissionTypeType = row["PERMISSION_TYPE_TYPE"].ToString()
};
permissionTypes.Add(permissionType);
}
}
else
{
permissionTypes = null;
}
}
catch (Exception exception)
{
permissionTypes = null;
}
finally
{
connector.Dispose();
}
return(permissionTypes);
}
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
#region PermissionType
/// <summary>
///
/// </summary>
/// <param name="permissionType"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SavePermissionType(PermissionTypeDTO permissionType, string operation)
{
DataTable dataTable = new DataTable();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
MessageDTO message = new MessageDTO();
try
{
connector.BeginTransaction();
//Todos los registros
object[] parameters = new object[] { permissionType.Company.CompanyId, permissionType.PermissionTypeId,
permissionType.User.UserId, permissionType.PermissionTypeDescription,
permissionType.PermissionTypeType, permissionType.PermissionTypeStatus,
operation };
//connector.ExecuteNonQuery(CommandType.StoredProcedure, "SavePermissionType", parameters);
dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SavePermissionType", parameters);
foreach (DataRow row in dataTable.Rows)
{
message.ErrorCode = row["ERROR_NUMBER"].ToString();
message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
}
if (message.ErrorCode == "0")
{
connector.Commit();
}
else
{
connector.RollBack();
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.ToString();
connector.RollBack();
}
finally
{
connector.Dispose();
}
return(message);
}
public string DeletePermissionType(int permissionTypeId, int companyId, int userId)
{
PermissionTypeDTO permissionType = new PermissionTypeDTO();
MessageDTO message = new MessageDTO();
permissionType.Company = new CompanyDTO {
CompanyId = companyId
};
permissionType.User = new UserDTO {
UserId = userId
};
permissionType.PermissionTypeDescription = "";
permissionType.PermissionTypeId = permissionTypeId;
permissionType.PermissionTypeType = "";
permissionType.PermissionTypeStatus = "";
message = business.SavePermissionType(permissionType, "D");
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
/// <summary>
///
/// </summary>
/// <param name="permissionType"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SavePermissionType(PermissionTypeDTO permissionType, string operation)
{
return(permissionTypeDao.SavePermissionType(permissionType, operation));
}