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); } }