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