public override SuccessResult <AbstractProjects> ProjectsUpsert(AbstractProjects abstractProjects) { SuccessResult <AbstractProjects> company = null; var param = new DynamicParameters(); param.Add("@Id", abstractProjects.Id, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@Name", abstractProjects.Name, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@Description", abstractProjects.Description, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@CompanyContactId", abstractProjects.CompanyContactId, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@StatusId", abstractProjects.StatusId, dbType: DbType.Int32, direction: ParameterDirection.Input); param.Add("@StartDate", abstractProjects.StartDate, dbType: DbType.String, direction: ParameterDirection.Input); param.Add("@EndDate", abstractProjects.EndDate, dbType: DbType.String, 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.ProjectsUpsert, param, commandType: CommandType.StoredProcedure); company = task.Read <SuccessResult <AbstractProjects> >().SingleOrDefault(); company.Item = task.Read <Projects>().SingleOrDefault(); } return(company); }
public abstract SuccessResult <AbstractProjects> ProjectsUpsert(AbstractProjects abstractProjects);
public override SuccessResult <AbstractProjects> ProjectsUpsert(AbstractProjects abstractProjects) { return(this.abstractProjectsDao.ProjectsUpsert(abstractProjects)); }