public int InsertIntroducer(ChangeIntroducer theIntroducer) { int ReturnValue = 0; using (SqlCommand InsertCommand = new SqlCommand()) { InsertCommand.CommandType = CommandType.StoredProcedure; InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; InsertCommand.Parameters.Add(GetParameter("@CustomerAccountID", SqlDbType.Int, theIntroducer.CustomerAccountID)); InsertCommand.Parameters.Add(GetParameter("@NewFieldForceID", SqlDbType.Int, theIntroducer.NewFieldForceID)); InsertCommand.Parameters.Add(GetParameter("@TodaysDate", SqlDbType.VarChar, theIntroducer.TodaysDate)); InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); InsertCommand.CommandText = "pCRM_ChangeIntroducers_Insert"; ExecuteStoredProcedure(InsertCommand); ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public int InsertIntroducer(ChangeIntroducer theIntroducer) { return(ChangeIntroducerIntegration.InsertIntroducer(theIntroducer)); }
public static int InsertIntroducer(ChangeIntroducer theIntroducer) { return(ChangeIntroducerDataAccess.GetInstance.InsertIntroducer(theIntroducer)); }