public override SuccessResult <AbstractOpportunities> OpportunitiesUpsert(AbstractOpportunities abstractOpportunities) { SuccessResult <AbstractOpportunities> Opportunities = null; var param = new DynamicParameters(); param.Add("@Id", abstractOpportunities.Id, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@Name", abstractOpportunities.Name, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@Description", abstractOpportunities.Description, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@CompanyContactId", abstractOpportunities.CompanyContactId, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@StatusId", abstractOpportunities.StatusId, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@SuccessRatePercent", abstractOpportunities.SuccessRatePercent, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@StartDate", abstractOpportunities.StartDate, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@EndDate", abstractOpportunities.EndDate, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@AssignedUserId", abstractOpportunities.AssignedUserId, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@LoginUserId", ProjectSession.UserID, dbType: DbType.Int32, direction: ParameterDirection.Input); using (SqlConnection con = new SqlConnection(Configurations.ConnectionString)) { var task = con.QueryMultiple(SQLConfig.OpportunitiesUpsert, param, commandType: CommandType.StoredProcedure); Opportunities = task.Read <SuccessResult <AbstractOpportunities> >().SingleOrDefault(); Opportunities.Item = task.Read <Opportunities>().SingleOrDefault(); } return(Opportunities); }
public abstract SuccessResult <AbstractOpportunities> OpportunitiesUpsert(AbstractOpportunities abstractOpportunities);
public override SuccessResult <AbstractOpportunities> OpportunitiesUpsert(AbstractOpportunities abstractOpportunities) { return(this.abstractOpportunitiesDao.OpportunitiesUpsert(abstractOpportunities)); }