public static int?UserInsert(User user, int iUserManagerId, int userType)
{
try
{
List <SqlParameter> parameters = ObjectGenerator <User> .GetSqlParametersFromObject(user);
parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId));
parameters.Add(new SqlParameter("userType", userType));
if (userType == 3)
{
parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lLanguage, "int", "lLanguage"));
parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lOrderType, "int", "lOrderType"));
}
if (userType == 1)
{
user.iEntitlementTypeId = null;
user.iCommunicationCart = null;
}
DataSet ds = SqlDataAccess.ExecuteDatasetSP("TUser_INS", parameters);
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
catch (Exception ex)
{
Log.ExceptionLog(ex.Message, "UserInsert");
return(-1);
}
}
public static int?UserUpdate(User user, int iUserManagerId, int changeEligibility)
{
try
{
List <SqlParameter> parameters = ObjectGenerator <User> .GetSqlParametersFromObject(user);
parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId));
parameters.Add(new SqlParameter("changeEligibility", changeEligibility));
if (user.lLanguage != null && user.lLanguage.Count != 0)
{
parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lLanguage, "int", "lLanguage"));
}
if (user.lOrderType != null && user.lOrderType.Count != 0)
{
parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lOrderType, "int", "lOrderType"));
}
DataSet ds = SqlDataAccess.ExecuteDatasetSP("User_UPD", parameters);
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
catch (Exception ex)
{
Log.ExceptionLog(ex.Message, "UserUpdate");
return(-1);
}
}