public bool Delete(SubContractorJob c) { using (var db = DBConnection.GetConnection()) { return(SubContractorJob.Delete <SubContractorJob>(db, c)); } }
public bool Post([FromBody] SubContractorJob c) { using (var db = DBConnection.GetConnection()) { return(SubContractorJob.Persist <SubContractorJob>(db, c)); } }
public SubContractorJob Get(int id) { using (var db = DBConnection.GetConnection()) { return(SubContractorJob.GetById <SubContractorJob>(db, id)); } }
public IEnumerable <SubContractorJob> Get() { using (var db = DBConnection.GetConnection()) { return(SubContractorJob.GetAll <SubContractorJob>(db)); } }
public void SubJobDBOperationsTest() { IDbConnection db = DBConnection.GetConnection(); SubContractorJob s1 = new SubContractorJob() { SubContractorId = 5, JobId = 9, StartDate = DateTime.Today, EndDate = null, EstimatedCost = 30000, ActualCost = 15000, WhenCreated = SubContractorJob.GetById <SubContractorJob>(db, 1).WhenCreated }; SubContractorJob s2 = new SubContractorJob() { SubContractorId = 6, JobId = 9, StartDate = DateTime.Today, EndDate = DateTime.Today.AddDays(5), EstimatedCost = 12000, ActualCost = 15000, WhenCreated = SubContractorJob.GetById <SubContractorJob>(db, 2).WhenCreated }; SubContractorJob s3 = new SubContractorJob() { SubContractorId = 6, JobId = 8, StartDate = DateTime.Today, EndDate = DateTime.Today.AddDays(10), EstimatedCost = 20000, ActualCost = 18000, IsDeleted = true, WhenCreated = SubContractorJob.GetById <SubContractorJob>(db, 3).WhenCreated }; //what is the value of IsDeleted by default? TestContext.Out.WriteLine("Value of IsDeleted: " + s2.IsDeleted); SubContractorJob.Persist <SubContractorJob>(db, s1); SubContractorJob.Persist <SubContractorJob>(db, s2); SubContractorJob.Persist <SubContractorJob>(db, s3); }
/// <summary> /// Builds an instance of a SubContractorJob ('Is a' ProjectComponent) from a Sql Data Reader object /// </summary> /// <param name="reader"></param> /// <returns>Instance of a <strong>SubContractorJob</strong></returns> public static SubContractorJob BuildSubcontractorJobModel(SqlDataReader reader) { var job = new SubContractorJob() { Id = DbUtilities.GetInt(reader, "ProjectComponentId"), ProjectId = DbUtilities.GetInt(reader, "ProjectId"), ComponentName = DbUtilities.GetString(reader, "ProjectComponentName"), ComponentDescription = DbUtilities.GetString(reader, "ComponentDescription"), SubcontractorId = DbUtilities.GetNullableInt(reader, "SubcontractorId"), DateComplete = DbUtilities.GetNullableDateTime(reader, "PCDateComplete"), MaterialCost = DbUtilities.GetInt(reader, "MaterialCost"), OwnerScreenName = DbUtilities.GetString(reader, "ScreenName"), OwnerImageUrl = DbUtilities.GetString(reader, "ImageLocation"), ProjectName = DbUtilities.GetString(reader, "ProjectName"), LocationName = DbUtilities.GetString(reader, "LocationName"), LocationAddress = DbUtilities.GetString(reader, "LocationAddress"), SubcontractorFee = DbUtilities.GetInt(reader, "Fee"), }; return(job); }