public IHttpActionResult GetProjectList() { RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet ds = rdsService.SelectList("USP_GetProjects"); List <Project> lstProjects = new List <Project>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { Project project = new Project(); project.ProjectName = dr["ProjectName"].ToString(); project.AssignDate = Convert.ToDateTime(dr["AssignDate"]); project.CreateBy = dr["CreatedBy"].ToString(); project.CreateDate = Convert.ToDateTime(dr["CreateDate"]); project.JobNumber = dr["JobNumber"].ToString(); project.Notes = dr["Notes"].ToString(); project.ProejctId = Convert.ToInt32(dr["ProejctId"].ToString()); project.PurchaseOrder = dr["PurchaseOrder"].ToString(); project.ProjetTypeId = Convert.ToInt32(dr["ProjectType_ProjectTypeId"].ToString()); project.ScopeOfWorkId = Convert.ToInt32(dr["ScopeOfWork_ScopeOfWorkId"].ToString()); project.StatusId = Convert.ToInt32(dr["Status_StatusId"].ToString()); project.JobSheetName = dr["JobSheetName"].ToString(); project.PurchaseOrder = dr["PurchaseOrderName"].ToString(); project.StatusName = dr["StatusName"].ToString(); lstProjects.Add(project); } } else { return(NotFound()); } return(Ok(lstProjects)); }
public IHttpActionResult UpdateProject(Project project) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProjectName", project.ProjectName); sd.Add("@Notes", project.Notes); sd.Add("@PurchaseOrder", project.PurchaseOrder); sd.Add("@AssignDate", project.AssignDate.ToString("yyyyMMddHHmmss")); sd.Add("@CreateDate", project.CreateDate.ToString("yyyyMMddHHmmss")); sd.Add("@CreatedBy", project.CreateBy); sd.Add("@JobNumber", project.JobNumber.ToString()); sd.Add("@ProjectType_ProjectTypeId", project.ProjetTypeId.ToString()); sd.Add("@ScopeOfWork_ScopeOfWorkId", project.ScopeOfWorkId.ToString()); sd.Add("@Status_StatusId", project.StatusId.ToString()); sd.Add("@ProejctId", project.ProejctId.ToString()); sd.Add("@StockLength", project.StockLength.ToString()); sd.Add("@BarCodeGrade", project.BarCodeGrade == true ? "1" : "0"); sd.Add("@StandardSplice", project.StandardSplice.ToString()); sd.Add("@MachanicSplice", project.MechanicSplice.ToString()); sd.Add("@JobSheetName", project.JobSheetName); sd.Add("@PurchaseOrderFileName", project.PurchaseOrder); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_UpdateProject", sd); return(Ok(retvalue)); }
public IHttpActionResult GetUsers() { RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet ds = rdsService.SelectList("USP_GetUsers"); List <User> lstUsers = new List <User>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { var user = new User(); user.UserId = Convert.ToInt32(dr["UserId"].ToString()); user.UserType = Convert.ToInt32(dr["userType"].ToString()); user.DateofBirth = dr["DateofBirth"].ToString() != string.Empty ? Convert.ToDateTime(dr["DateofBirth"].ToString()) : DateTime.MinValue; user.DateofJoin = dr["JoiningDate"].ToString() != string.Empty ? Convert.ToDateTime(dr["JoiningDate"].ToString()) : DateTime.MinValue; user.Expereince = dr["TotalExperience"].ToString() != string.Empty ? float.Parse(dr["TotalExperience"].ToString()) : 0; user.Role = dr["Role"].ToString() != string.Empty ? dr["Role"].ToString() : string.Empty; user.UserName = dr["UserName"].ToString(); user.Name = dr["Name"].ToString(); user.Email = dr["Email"].ToString(); user.Password = dr["Password"].ToString(); user.Address = dr["address"].ToString(); user.CompanyName = dr["CompanName"].ToString() != string.Empty ? dr["CompanName"].ToString() : string.Empty; user.PhotoName = dr["Photo"].ToString() != string.Empty ? dr["Photo"].ToString() : string.Empty; lstUsers.Add(user); } } else { return(NotFound()); } return(Ok(lstUsers)); }
public IHttpActionResult AddUser(UserModel model) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@userName", model.UserName); sd.Add("@password", model.Password); sd.Add("@name", model.Name); sd.Add("@email", model.Email); sd.Add("@address", model.Address); sd.Add("@userType", model.UserType.ToString()); sd.Add("@dateofBirth", model.DateOfBirth); sd.Add("@companyName", model.CompanyName); sd.Add("@dateofJoin", model.JoiningDate); sd.Add("@experience", model.Experience.ToString()); sd.Add("@photo", model.Photo); sd.Add("@role", model.Role); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_InsertUser", "userId", sd); var id = retvalue.Tables[0].Rows[0][0].ToString(); return(Ok(id)); }
public IHttpActionResult GetBarCode(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_GetBarCode", sd); List <BarCode> lstBarcode = new List <BarCode>(); if (ds != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { var barCode = new BarCode() { BarCodeId = Convert.ToInt32(dr[0]), StockLength = dr[1].ToString(), BarCodeGrade = dr[2].ToString().Equals("1") ? true : false, StandardSplice = dr[3].ToString(), MachanicSplice = dr[4].ToString() }; lstBarcode.Add(barCode); } } return(Ok(lstBarcode.FirstOrDefault())); }
public IHttpActionResult DeleteProject([FromBody] string Id) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", Id); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_Delete_Project", sd); return(Ok(retvalue)); }
public IHttpActionResult AddContractDWGS(ContractDWGS contractDWGS) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", contractDWGS.ProjectId); sd.Add("@fileName", contractDWGS.FileName); sd.Add("@timeStamp", contractDWGS.TImeStamp); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_InsertContractDWGS", "ContractDWGSId", sd); var ContractDWGSId = retvalue.Tables[0].Rows[0][0].ToString(); return(Ok(ContractDWGSId)); }
public IHttpActionResult AddShopDrawings(ShopDrawings shopDrawings) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", shopDrawings.ProjectId); sd.Add("@fileName", shopDrawings.FileName); sd.Add("@timeStamp", shopDrawings.TImeStamp); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_InsertShopDrawings", "ShopDrawingId", sd); var shopDrawingId = retvalue.Tables[0].Rows[0][0].ToString(); return(Ok(shopDrawingId)); }
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 AddPurchaseOrders(PurchaseOrder purchaseOrder) { SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", purchaseOrder.ProjectId); sd.Add("@fileName", purchaseOrder.FileName); sd.Add("@timeStamp", purchaseOrder.TImeStamp); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_Insertpurchaseorder", "purchaseorderId", sd); var purchaseOrderId = retvalue.Tables[0].Rows[0][0].ToString(); return(Ok(purchaseOrderId)); }
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 DeletePurchaseOrder([FromBody] int projectId) { if (projectId <= 0) { return(BadRequest()); } SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", projectId.ToString()); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_Delete_PurchaseOrder", sd); return(Ok(retvalue)); }
public IHttpActionResult DeleteShopDrawings(ShopDrawings shopDrawings) { if (shopDrawings == null) { return(BadRequest()); } SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", shopDrawings.ProjectId); sd.Add("@shopDrawingId", shopDrawings.ShopDrawingId); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_DeleteShopDrawings", sd); return(Ok(retvalue)); }
public IHttpActionResult DeletePurchaseOrders(PurchaseOrder purchaseOrder) { if (purchaseOrder == null) { return(BadRequest()); } SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", purchaseOrder.ProjectId); sd.Add("@purchaseorderid", purchaseOrder.PurchaseOrderId); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_DeletePurchaseOrders", sd); return(Ok(retvalue)); }
public IHttpActionResult DeleteRFIResponses(RFIResponse rfiResponse) { if (rfiResponse == null) { return(BadRequest()); } SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", rfiResponse.ProjectId); sd.Add("@RFiResponseId", rfiResponse.RfiResponseId); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_DeleteRFIResponses", sd); return(Ok(retvalue)); }
public IHttpActionResult DeleteContractDWGS(ContractDWGS contractDWGS) { if (contractDWGS == null) { return(BadRequest()); } SortedDictionary <string, string> sd = new SortedDictionary <string, string>() { }; sd.Add("@ProejctId", contractDWGS.ProjectId); sd.Add("@ContractId", contractDWGS.ContractDrawingId); RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet retvalue = rdsService.SelectList("USP_DeleteContractDWGS", sd); return(Ok(retvalue)); }
public IHttpActionResult GetContractDWGS(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_GetContractDWGS", sd); var contractDwgs = new List <ContractDWGS>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { var drawings = new ContractDWGS { ProjectId = dr[0].ToString(), ContractDrawingId = dr[1].ToString(), FileName = dr[2].ToString(), TImeStamp = dr[3].ToString() }; contractDwgs.Add(drawings); } } return(Ok(contractDwgs)); }
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)); }
public IHttpActionResult GetRFIResponses(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_GetRFIResponses", sd); var rfiResponses = new List <RFIResponse>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { var rfiResponse = new RFIResponse { ProjectId = dr[0].ToString(), RfiResponseId = dr[1].ToString(), FileName = dr[2].ToString(), TImeStamp = dr[3].ToString() }; rfiResponses.Add(rfiResponse); } } return(Ok(rfiResponses)); }
public IHttpActionResult GetUserTypes() { RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet ds = rdsService.SelectList("USP_GetUserTypes"); var userTypes = new List <UserType>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { userTypes.Add(new UserType { Name = dr[0].ToString(), Id = Convert.ToInt32(dr[1].ToString()) }); } // pdm.ScopeOfWork = lstSow; } else { return(NotFound()); } return(Ok(userTypes)); }
public IHttpActionResult GetScopeOfWork() { RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet ds = rdsService.SelectList("USP_GetScopeOfWork"); ProjectDetailsModel pdm = new ProjectDetailsModel(); List <ScopeOfWork> lstSow = new List <ScopeOfWork>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ScopeOfWork sow = new ScopeOfWork(); sow.ScopeOfWorkId = Convert.ToInt32(dr[0].ToString()); sow.ScopeOfWorkName = dr[1].ToString(); lstSow.Add(sow); } // pdm.ScopeOfWork = lstSow; } else { return(NotFound()); } return(Ok(lstSow)); }
public IHttpActionResult GetProjectType() { RDSService.RDSService rdsService = new RDSService.RDSService(); DataSet ds = rdsService.SelectList("USP_GetProjectType"); ProjectDetailsModel pdm = new ProjectDetailsModel(); List <ProjectType> lstProjectType = new List <ProjectType>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ProjectType pt = new ProjectType(); pt.ProjectName = dr[1].ToString(); pt.ProjectTypeId = Convert.ToInt32(dr[0].ToString()); lstProjectType.Add(pt); } // pdm.ProjectType = lstProjectType; } else { return(NotFound()); } return(Ok(lstProjectType)); }
public IHttpActionResult GetPurchaseOrders(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_GetpurchaseOrders", sd); var purchaseOrders = new List <PurchaseOrder>(); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { var purchaseOrder = new PurchaseOrder() { ProjectId = dr[0].ToString(), PurchaseOrderId = dr[1].ToString(), FileName = dr[2].ToString(), TImeStamp = dr[3].ToString() }; purchaseOrders.Add(purchaseOrder); } } return(Ok(purchaseOrders)); }