public Status InsertUser(UserExtend user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.Email.ToString(), SqlDbType.VarChar, 30, user.Email, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 30, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 30, user.Password, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.FirstName.ToString(), SqlDbType.VarChar, 30, user.FirstName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.LastName.ToString(), SqlDbType.VarChar, 30, user.LastName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Gender.ToString(), SqlDbType.Int, 20, user.Gender, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.DOB.ToString(), SqlDbType.DateTime, 30, user.DOB, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Status.ToString(), SqlDbType.Int, 10, user.Status, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.SaltKey.ToString(), SqlDbType.VarChar, 6, CommonFunctions.SaltKey(), ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.ActiveGuid.ToString(), SqlDbType.VarChar, 50, Guid.NewGuid().ToString(), ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery(spUser.spUserInsert.ToString(), parameter), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status CheckGroup(string group)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(DbGroupDetails.GroupName.ToString(), SqlDbType.VarChar, 50, group, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery("spGroupCheck", parameter, true), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status Login1(UserEnity user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spUserLogin.ToString(), parameter, true);
string success = string.Empty;
switch (RES)
{
case 1:
success = AppConstant.SuccessMsg;
break;
case 2:
success = "User Removed";
break;
case 8:
success = "User Locked";
break;
case 9:
success = "Not activation";
break;
}
return(new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status Insert(GroupDetails objGroup)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(DbGroupDetails.GroupName.ToString(), SqlDbType.VarChar, 50, objGroup.GroupName, ParameterDirection.Input),
DataParameter.GetSqlParam(DbGroupDetails.Desc.ToString(), SqlDbType.VarChar, 500, objGroup.Desc, ParameterDirection.Input),
DataParameter.GetSqlParam(DbGroupDetails.CreatedBy.ToString(), SqlDbType.Int, 11, objGroup.CreatedUser, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery("spGroupInsert", parameter, true), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status CheckUserActivation(string guid)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.ActiveGuid.ToString(), SqlDbType.VarChar, 50, guid, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spCheckActivation.ToString(), parameter, true);
string success = (RES == 1) ? AppConstant.SuccessMsg : (RES == 2) ? "Activation done already" : "No activation code";
return(new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
});
}
catch (SqlException ex)
{
throw ex;
}
}
