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