public string CRUD_USER(int pType, string pUser, string pPassword, string pEmail, string pProfile, string pCellPhone,
string pName, string pLastName, int pDocumentType, string pDni)
{
string res = "OK";
try
{
if (pType == TYPE_INSERT)
{
//Asociar usuario a tabla de config
vSQL = @"INSERT INTO CONFIG_USER(UserName,PROFILE_ID,NAME, LAST_NAME, CELL_PHONE,
DOCUMENT_TYPE_ID,DNI) VALUES('" + pUser + "'," + pProfile + ",'" + pName +
"','" + pLastName + "','" + pCellPhone +
"'," + pDocumentType + ",'" + pDni + "')";
Data.OPERATIONS(vSQL);
Membership.CreateUser(pUser, pPassword, pEmail);
}
else if (pType == TYPE_UPDATE)
{
MembershipUser user = Membership.GetUser(pUser);
res = user.ResetPassword();
}
else if (pType == TYPE_DELETE)
{
vSQL = "DELETE FROM CONFIG_USER WHERE UserName = '******'";
Data.OPERATIONS(vSQL);
Membership.DeleteUser(pUser);
}
else if (pType == TYPE_LOCK)
{
vSQL = @"UPDATE aspnet_Membership SET IsLockedOut = 1 WHERE UserId = '" + pUser + "'";
Data.OPERATIONS(vSQL);
}
else if (pType == TYPE_UNLOCK)
{
vSQL = @"UPDATE aspnet_Membership SET IsLockedOut = 0 WHERE UserId = '" + pUser + "'";
Data.OPERATIONS(vSQL);
}
else if (pType == TYPE_CHANGE_GENERALDATA)
{
vSQL = @"DECLARE @_userId NVARCHAR(250)
SELECT @_userId = u.UserId
FROM dbo.aspnet_Users u
WHERE u.UserName = '******'
UPDATE dbo.aspnet_Membership
SET Email = '" + pEmail + @"'
WHERE UserId = @_userId
UPDATE dbo.CONFIG_USER
SET PROFILE_ID = " + pProfile + @",
[NAME] = '" + pName + @"',
[LAST_NAME] = '" + pLastName + @"',
[CELL_PHONE] = '" + pCellPhone + @"',
[DOCUMENT_TYPE_ID] = " + pDocumentType + @",
[DNI] = '" + pDni + @"'
WHERE UserName = '******'";
Data.OPERATIONS(vSQL);
}
}
catch (Exception ex)
{
if (pType == TYPE_INSERT)
{
vSQL = "DELETE FROM CONFIG_USER WHERE UserName = '******'";
Data.OPERATIONS(vSQL);
}
res = ex.Message;
}
return(res);
}