public abstract SuccessResult <AbstractProjectsTimeTracking> ProjectTimeTrackingUpsert(AbstractProjectsTimeTracking abstractProjectsTimeTracking);
public override SuccessResult <AbstractProjectsTimeTracking> ProjectTimeTrackingUpsert(AbstractProjectsTimeTracking abstractProjectsTimeTracking)
{
SuccessResult <AbstractProjectsTimeTracking> company = null;
var param = new DynamicParameters();
param.Add("@Id", abstractProjectsTimeTracking.Id, dbType: DbType.Int32, direction: ParameterDirection.Input);
param.Add("@WorkDone", abstractProjectsTimeTracking.WorkDone, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@WorkDescription", abstractProjectsTimeTracking.WorkDescription, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@ProjectId", abstractProjectsTimeTracking.ProjectId, dbType: DbType.Int32, direction: ParameterDirection.Input);
param.Add("@AssignedUserId", abstractProjectsTimeTracking.AssignedUserId, dbType: DbType.Int32, direction: ParameterDirection.Input);
param.Add("@StartDate", abstractProjectsTimeTracking.StartDate, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@EndDate", abstractProjectsTimeTracking.EndDate, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add("@TotalHrs", abstractProjectsTimeTracking.TotalHrs, 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.ProjectTimeTrackingUpsert, param, commandType: CommandType.StoredProcedure);
company = task.Read <SuccessResult <AbstractProjectsTimeTracking> >().SingleOrDefault();
company.Item = task.Read <ProjectsTimeTracking>().SingleOrDefault();
}
return(company);
}
public override SuccessResult <AbstractProjectsTimeTracking> ProjectTimeTrackingUpsert(AbstractProjectsTimeTracking abstractProjectsTimeTracking)
{
return(this.abstractProjectsTimeTrackingDao.ProjectTimeTrackingUpsert(abstractProjectsTimeTracking));
}
