public IHttpActionResult AddEngineeringReview(EngineerReviewedDrawings engineerReviewDrawings)
{
SortedDictionary <string, string> sd = new SortedDictionary <string, string>()
{
};
sd.Add("@ProejctId", engineerReviewDrawings.ProjectId);
sd.Add("@fileName", engineerReviewDrawings.FileName);
sd.Add("@timeStamp", engineerReviewDrawings.TImeStamp);
RDSService.RDSService rdsService = new RDSService.RDSService();
DataSet retvalue = rdsService.SelectList("USP_InsertEngineeringReviewed", "EngineeringReviewId", sd);
var ContractDWGSId = retvalue.Tables[0].Rows[0][0].ToString();
return(Ok(ContractDWGSId));
}
public IHttpActionResult DeleteEngineeringDrawings(EngineerReviewedDrawings engDrawings)
{
if (engDrawings == null)
{
return(BadRequest());
}
SortedDictionary <string, string> sd = new SortedDictionary <string, string>()
{
};
sd.Add("@ProejctId", engDrawings.ProjectId);
sd.Add("@EngReviewdDrawingId", engDrawings.EngineeringDrawingId);
RDSService.RDSService rdsService = new RDSService.RDSService();
DataSet retvalue = rdsService.SelectList("USP_DeleteEngineeringReviewedDrawings", sd);
return(Ok(retvalue));
}
public IHttpActionResult GetEngineeringReviewedDrawings(string projectId)
{
SortedDictionary <string, string> sd = new SortedDictionary <string, string>()
{
};
sd.Add("@ProejctId", projectId.ToString());
RDSService.RDSService rdsService = new RDSService.RDSService();
DataSet ds = rdsService.SelectList("USP_GetEngineeringReviewedDrawings", sd);
var engineerReviewedDrawings = new List <EngineerReviewedDrawings>();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
var engReviewedDrawing = new EngineerReviewedDrawings {
ProjectId = dr[0].ToString(), EngineeringDrawingId = dr[1].ToString(), FileName = dr[2].ToString(), TImeStamp = dr[3].ToString()
};
engineerReviewedDrawings.Add(engReviewedDrawing);
}
}
return(Ok(engineerReviewedDrawings));
}