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