public List <ProductionQC> GetAllProductionQC(ProductionQCAdvanceSearch productionQCAdvanceSearch) { return(_productionQCRepository.GetAllProductionQC(productionQCAdvanceSearch)); }
public List <ProductionQC> GetAllProductionQC(ProductionQCAdvanceSearch productionQCAdvanceSearch) { List <ProductionQC> productionQCList = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[PSA].[GetAllProductionQC]"; if (string.IsNullOrEmpty(productionQCAdvanceSearch.SearchTerm)) { cmd.Parameters.AddWithValue("@SearchTerm", DBNull.Value); } else { cmd.Parameters.Add("@SearchTerm", SqlDbType.NVarChar, -1).Value = productionQCAdvanceSearch.SearchTerm; } cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = productionQCAdvanceSearch.DataTablePaging.Start; if (productionQCAdvanceSearch.DataTablePaging.Length == -1) { cmd.Parameters.AddWithValue("@Length", DBNull.Value); } else { cmd.Parameters.Add("@Length", SqlDbType.Int).Value = productionQCAdvanceSearch.DataTablePaging.Length; } cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = productionQCAdvanceSearch.AdvFromDate; cmd.Parameters.Add("@Todate", SqlDbType.DateTime).Value = productionQCAdvanceSearch.AdvToDate; if (productionQCAdvanceSearch.AdvCustomerID == Guid.Empty) { cmd.Parameters.AddWithValue("@CustomerID", DBNull.Value); } else { cmd.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = productionQCAdvanceSearch.AdvCustomerID; } cmd.Parameters.Add("@AreaCode", SqlDbType.Int).Value = productionQCAdvanceSearch.AdvAreaCode; cmd.Parameters.Add("@BranchCode", SqlDbType.Int).Value = productionQCAdvanceSearch.AdvBranchCode; cmd.Parameters.Add("@DocumentStatusCode", SqlDbType.Int).Value = productionQCAdvanceSearch.AdvDocumentStatusCode; if (productionQCAdvanceSearch.AdvDocumentOwnerID == Guid.Empty) { cmd.Parameters.AddWithValue("@DocumentOwnerID", DBNull.Value); } else { cmd.Parameters.Add("@DocumentOwnerID", SqlDbType.UniqueIdentifier).Value = productionQCAdvanceSearch.AdvDocumentOwnerID; } cmd.Parameters.Add("@ApprovalStatusCode", SqlDbType.Int).Value = productionQCAdvanceSearch.AdvApprovalStatusCode; cmd.Parameters.Add("@EmailSentYN", SqlDbType.NVarChar).Value = productionQCAdvanceSearch.AdvEmailSentStatus; cmd.Parameters.Add("@PlantCode", SqlDbType.Int).Value = productionQCAdvanceSearch.AdvPlantCode; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { productionQCList = new List <ProductionQC>(); while (sdr.Read()) { ProductionQC productionQC = new ProductionQC(); { productionQC.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : productionQC.ID); productionQC.ProdQCNo = (sdr["ProdQCNo"].ToString() != "" ? sdr["ProdQCNo"].ToString() : productionQC.ProdQCNo); productionQC.ProdQCDate = (sdr["ProdQCDate"].ToString() != "" ? DateTime.Parse(sdr["ProdQCDate"].ToString()) : productionQC.ProdQCDate); productionQC.ProdQCDateFormatted = (sdr["ProdQCDate"].ToString() != "" ? DateTime.Parse(sdr["ProdQCDate"].ToString()).ToString(_settings.DateFormat) : productionQC.ProdQCDateFormatted); productionQC.ProdOrderID = (sdr["ProdOrderID"].ToString() != "" ? Guid.Parse(sdr["ProdOrderID"].ToString()) : productionQC.ProdOrderID); productionQC.ProdOrderNo = (sdr["ProdOrderNo"].ToString() != "" ? sdr["ProdOrderNo"].ToString() : productionQC.ProdOrderNo); productionQC.PlantCode = (sdr["PlantCode"].ToString() != "" ? int.Parse(sdr["PlantCode"].ToString()) : productionQC.PlantCode); productionQC.Plant = new Plant(); productionQC.Plant.Code = (sdr["PlantCode"].ToString() != "" ? int.Parse(sdr["PlantCode"].ToString()) : productionQC.Plant.Code); productionQC.Plant.Description = (sdr["PlantDescription"].ToString() != "" ? (sdr["PlantDescription"].ToString()) : productionQC.Plant.Description); productionQC.CustomerID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : productionQC.CustomerID); productionQC.Customer = new Customer(); productionQC.CustomerID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : productionQC.Customer.ID); productionQC.Customer.CompanyName = (sdr["CustomerCompanyName"].ToString() != "" ? sdr["CustomerCompanyName"].ToString() : productionQC.Customer.CompanyName); productionQC.Customer.ContactPerson = (sdr["CustomerContactPerson"].ToString() != "" ? sdr["CustomerContactPerson"].ToString() : productionQC.Customer.ContactPerson); productionQC.Customer.Mobile = (sdr["CustomerMobile"].ToString() != "" ? sdr["CustomerMobile"].ToString() : productionQC.Customer.Mobile); productionQC.DocumentStatusCode = (sdr["DocumentStatusCode"].ToString() != "" ? int.Parse(sdr["DocumentStatusCode"].ToString()) : productionQC.DocumentStatusCode); productionQC.DocumentStatus = new DocumentStatus(); productionQC.DocumentStatus.Code = (sdr["DocumentStatusCode"].ToString() != "" ? int.Parse(sdr["DocumentStatusCode"].ToString()) : productionQC.DocumentStatus.Code); productionQC.DocumentStatus.Description = (sdr["DocumentStatusDescription"].ToString() != "" ? (sdr["DocumentStatusDescription"].ToString()) : productionQC.DocumentStatus.Description); productionQC.PreparedBy = (sdr["PreparedBy"].ToString() != "" ? Guid.Parse(sdr["PreparedBy"].ToString()) : productionQC.PreparedBy); productionQC.Employee = new Employee(); productionQC.Employee.ID = (sdr["PreparedBy"].ToString() != "" ? Guid.Parse(sdr["PreparedBy"].ToString()) : productionQC.Employee.ID); productionQC.Employee.Name = (sdr["EmployeeName"].ToString() != "" ? (sdr["EmployeeName"].ToString()) : productionQC.Employee.Name); productionQC.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : productionQC.GeneralNotes); productionQC.LatestApprovalStatus = (sdr["LatestApprovalStatus"].ToString() != "" ? int.Parse(sdr["LatestApprovalStatus"].ToString()) : productionQC.LatestApprovalStatus); productionQC.DocumentOwnerID = (sdr["DocumentOwnerID"].ToString() != "" ? Guid.Parse(sdr["DocumentOwnerID"].ToString()) : productionQC.DocumentOwnerID); productionQC.Branch = new Branch(); productionQC.Branch.Description = (sdr["BranchDescription"].ToString() != "" ? sdr["BranchDescription"].ToString() : productionQC.Branch.Description); productionQC.Branch.Code = (sdr["BranchCode"].ToString() != "" ? int.Parse(sdr["BranchCode"].ToString()) : productionQC.Branch.Code); productionQC.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : productionQC.FilteredCount); productionQC.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : productionQC.FilteredCount); productionQC.ApprovalStatus = new ApprovalStatus(); productionQC.ApprovalStatus.Description = (sdr["ApprovalStatus"].ToString() != "" ? sdr["ApprovalStatus"].ToString() : productionQC.ApprovalStatus.Description); productionQC.PSAUser = new PSAUser(); productionQC.PSAUser.LoginName = (sdr["DocumentOwner"].ToString() != "" ? (sdr["DocumentOwner"].ToString()) : productionQC.PSAUser.LoginName); productionQC.EmailSentYN = (sdr["EmailSentYN"].ToString() != "" ? bool.Parse(sdr["EmailSentYN"].ToString()) : productionQC.EmailSentYN); productionQC.Area = new Area(); productionQC.Area.Description = (sdr["Area"].ToString() != "" ? sdr["Area"].ToString() : productionQC.Area.Description); productionQC.ProdOrderNo = (sdr["ProdOrderNo"].ToString() != "" ? sdr["ProdOrderNo"].ToString():productionQC.ProdOrderNo); } productionQCList.Add(productionQC); } } } } } } catch (Exception ex) { throw ex; } return(productionQCList); }