public static bool Insert(SurveyEntity survey, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_SurveyInsert"); db.AddInParameter(command, "MyUniversity", DbType.String, survey.MyUniversity); db.AddInParameter(command, "UniversityName", DbType.String, survey.UniversityName); db.AddInParameter(command, "UniversityAddress", DbType.String, survey.UniversityAddress); db.AddInParameter(command, "TypeOfResidence", DbType.String, survey.TypeOfResidence); db.AddInParameter(command, "TypeOfResidenceOption", DbType.String, survey.TypeOfResidenceOption); db.AddInParameter(command, "NameOfResidence", DbType.String, survey.NameOfResidence); db.AddInParameter(command, "AddressOfResidence", DbType.String, survey.AddressOfResidence); db.AddInParameter(command, "PropertyOwnerComment", DbType.String, survey.PropertyOwnerComment); db.AddInParameter(command, "Email", DbType.String, survey.Email); if (transaction == null) { db.ExecuteNonQuery(command); } else { db.ExecuteNonQuery(command, transaction); } return true; }
public static bool Insert(SurveyEntity survey, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_SurveyInsert"); db.AddInParameter(command, "MyUniversity", DbType.String, survey.MyUniversity); db.AddInParameter(command, "UniversityName", DbType.String, survey.UniversityName); db.AddInParameter(command, "UniversityAddress", DbType.String, survey.UniversityAddress); db.AddInParameter(command, "TypeOfResidence", DbType.String, survey.TypeOfResidence); db.AddInParameter(command, "TypeOfResidenceOption", DbType.String, survey.TypeOfResidenceOption); db.AddInParameter(command, "NameOfResidence", DbType.String, survey.NameOfResidence); db.AddInParameter(command, "AddressOfResidence", DbType.String, survey.AddressOfResidence); db.AddInParameter(command, "PropertyOwnerComment", DbType.String, survey.PropertyOwnerComment); db.AddInParameter(command, "Email", DbType.String, survey.Email); if (transaction == null) { db.ExecuteNonQuery(command); } else { db.ExecuteNonQuery(command, transaction); } return(true); }
public static bool Insert(SurveyEntity survey) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); return SurveyDAO.Insert(survey, db, null); }
public static bool Insert(SurveyEntity survey) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); return(SurveyDAO.Insert(survey, db, null)); }