public List <ssmtbl_PurchaseOrderModel> GetAllPurchaseOrderForApproval() { List <ssmtbl_PurchaseOrderModel> objPOList = new List <ssmtbl_PurchaseOrderModel>(); try { string sqlstr = "Select po_id As po_id, Isnull(InquiryNo,0) As InquiryNo, Isnull(customerName,'') As customerName, " + " Isnull(QuotationNo,'') As QuotationNo, Isnull(CustomerPONo,'') As CustomerPONo,Isnull(POValidity,'') As POValidity, " + " CreatedBy, CreatedDate, Isnull(QuotationId,0) as QuotationId,Isnull(Filepath,'') As Filepath From ssmtbl_PurchaseOrder Where InquiryNo In (Select InquiryNo " + " From ssmtbl_Inquiry where Status=@Status) and Isnull(POStatus,'') = @Status order by createddate desc"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@Status", InquiryStatus.POPendingForApproval); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_PurchaseOrderModel objtemp = new ssmtbl_PurchaseOrderModel(); objtemp.po_id = Convert.ToInt32(sdr["po_id"].ToString()); objtemp.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString()); objtemp.QuotationId = Convert.ToInt32(sdr["QuotationId"].ToString()); objtemp.customerName = sdr["customerName"].ToString(); objtemp.QuotationNo = sdr["QuotationNo"].ToString(); objtemp.CustomerPONo = sdr["CustomerPONo"].ToString(); objtemp.POValidity = Convert.ToDateTime(sdr["POValidity"].ToString()); objtemp.createdby = sdr["CreatedBy"].ToString(); objtemp.createddate = Convert.ToDateTime(sdr["CreatedDate"].ToString()); objtemp.Filepath = sdr["Filepath"].ToString(); objPOList.Add(objtemp); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPOList); }
public List <ssmtbl_PurchaseOrderModel> GetAllPO(string wono) { List <ssmtbl_PurchaseOrderModel> objWoList = new List <ssmtbl_PurchaseOrderModel>(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "uspGetAllPO"; SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "SelectAllPO"); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_PurchaseOrderModel objtemp = new ssmtbl_PurchaseOrderModel(); objtemp.po_id = Convert.ToInt32(sdr["po_id"].ToString()); objtemp.WorkorderNo1 = wono; objtemp.customerName = (sdr["customerName"].ToString()); objtemp.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); objtemp.createddate = Convert.ToDateTime(sdr["createddate"].ToString()); objtemp.CustomerPONo = (sdr["CustomerPONo"].ToString()); objtemp.QuotationNo = (sdr["QuotationNo"].ToString()); objtemp.QtymentionedinPO = (sdr["QtymentionedinPO"]).ToString(); objtemp.DieNumber = ((sdr["DieNumber"])).ToString(); objWoList.Add(objtemp); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objWoList); }
public ssmtbl_PurchaseOrderModel GetOnePurchaseOrderFromPONo(string PONo) { ssmtbl_PurchaseOrderModel objPO = new ssmtbl_PurchaseOrderModel(); try { string sqlstr = "Select po_id, InquiryNo, Isnull(customerName,'') As customerName, Isnull(QuotationNo,'') As QuotationNo, ISNULL(CustomerPONo,'') As CustomerPONo," + " Isnull(POValidity,'') As POValidity, Isnull(QtymentionedinPO,'') As QtymentionedinPO, Isnull(DieNumber,'') As DieNumber," + " Isnull(HSNCode,'') As HSNCode, Isnull(SteelCost,0) As SteelCost,Isnull(Transportation,0) As Transportation, ISNULL(Total,0) As Total," + " Isnull(TotalRowMaterialCost,0) As TotalRowMaterialCost, Isnull(CuttingSquare1,0) As CuttingSquare1,Isnull(CuttingSquare2,0) As CuttingSquare2," + " Isnull(Forging1,0) As Forging1, Isnull(Forging2,0) As Forging2, Isnull(HeatTreatment1,0) As HeatTreatment1, Isnull(HeatTreatment2,0) As HeatTreatment2," + " Isnull(ShotBlasting1,0) As ShotBlasting1, Isnull(ShotBlasting2,0) As ShotBlasting2, Isnull(MPI1,0) As MPI1, Isnull(MPI2,0) As MPI2," + " Isnull(Grinding1,0) As Grinding1, Isnull(Grinding2,0) As Grinding2, Isnull(ColdCoining1,0) As ColdCoining1,Isnull(ColdCoining2,0) As ColdCoining2," + " Isnull(Machining1,0) As Machining1, Isnull(Machining2,0) As Machining2, Isnull(DieMaintenance1,0) As DieMaintenance1,Isnull(DieMaintenance2,0) As DieMaintenance2," + " Isnull(TotalConverstionCost,0) As TotalConverstionCost, Isnull(TotalComponentCost,0) As TotalComponentCost,Isnull(InitialDieCost,0) As InitialDieCost," + " Isnull(Filepath,'') As Filepath,Isnull(CGST,0) As CGST, Isnull(IGST,0) As IGST,Isnull(SGST,0) As SGST,Isnull(createdby,'') As createdby," + " Isnull(createddate,'') As createddate, Isnull(updatedby,'') As updatedby, Isnull(updateddate,'') As updateddate, " + " Isnull(QuotationId,0) As QuotationId, Isnull(POStatus,'') As POStatus, Isnull(Comment,'') As Comment, Isnull(ApprovalDate,'') As ApprovalDate, " + " Isnull(ApprovedBy,'') As ApprovedBy From ssmtbl_PurchaseOrder Where CustomerPONo=@CustomerPONo and Isnull(POStatus,'')=@POStatus"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@CustomerPONo", PONo); cmd.Parameters.AddWithValue("@POStatus", InquiryStatus.POApproved); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objPO.po_id = Convert.ToInt32(sdr["po_id"].ToString()); objPO.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString()); objPO.customerName = sdr["customerName"].ToString(); objPO.QuotationNo = sdr["QuotationNo"].ToString(); objPO.CustomerPONo = sdr["CustomerPONo"].ToString(); objPO.POValidity = Convert.ToDateTime(sdr["POValidity"].ToString()); objPO.QtymentionedinPO = sdr["QtymentionedinPO"].ToString(); objPO.DieNumber = sdr["DieNumber"].ToString(); objPO.HSNCode = sdr["HSNCode"].ToString(); objPO.SteelCost = Convert.ToDecimal(sdr["SteelCost"].ToString()); objPO.Transportation = Convert.ToDecimal(sdr["Transportation"].ToString()); objPO.Total = Convert.ToDecimal(sdr["Total"].ToString()); objPO.TotalRowMaterialCost = Convert.ToDecimal(sdr["TotalRowMaterialCost"].ToString()); objPO.CuttingSquare1 = Convert.ToDecimal(sdr["CuttingSquare1"].ToString()); objPO.CuttingSquare2 = Convert.ToDecimal(sdr["CuttingSquare2"].ToString()); objPO.Forging1 = Convert.ToDecimal(sdr["Forging1"].ToString()); objPO.Forging2 = Convert.ToDecimal(sdr["Forging2"].ToString()); objPO.HeatTreatment1 = Convert.ToDecimal(sdr["HeatTreatment1"].ToString()); objPO.HeatTreatment2 = Convert.ToDecimal(sdr["HeatTreatment2"].ToString()); objPO.ShotBlasting1 = Convert.ToDecimal(sdr["ShotBlasting1"].ToString()); objPO.ShotBlasting2 = Convert.ToDecimal(sdr["ShotBlasting2"].ToString()); objPO.MPI1 = Convert.ToDecimal(sdr["MPI1"].ToString()); objPO.MPI2 = Convert.ToDecimal(sdr["MPI2"].ToString()); objPO.Grinding1 = Convert.ToDecimal(sdr["Grinding1"].ToString()); objPO.Grinding2 = Convert.ToDecimal(sdr["Grinding2"].ToString()); objPO.ColdCoining1 = Convert.ToDecimal(sdr["ColdCoining1"].ToString()); objPO.ColdCoining2 = Convert.ToDecimal(sdr["ColdCoining2"].ToString()); objPO.Machining1 = Convert.ToDecimal(sdr["Machining1"].ToString()); objPO.Machining2 = Convert.ToDecimal(sdr["Machining2"].ToString()); objPO.DieMaintenance1 = Convert.ToDecimal(sdr["DieMaintenance1"].ToString()); objPO.DieMaintenance2 = Convert.ToDecimal(sdr["DieMaintenance2"].ToString()); objPO.TotalConverstionCost = Convert.ToDecimal(sdr["TotalConverstionCost"].ToString()); objPO.TotalComponentCost = Convert.ToDecimal(sdr["TotalComponentCost"].ToString()); objPO.InitialDieCost = Convert.ToDecimal(sdr["InitialDieCost"].ToString()); objPO.Filepath = sdr["Filepath"].ToString(); objPO.CGST = Convert.ToDecimal(sdr["CGST"].ToString()); objPO.IGST = Convert.ToDecimal(sdr["IGST"].ToString()); objPO.SGST = Convert.ToDecimal(sdr["SGST"].ToString()); objPO.createdby = sdr["createdby"].ToString(); objPO.createddate = Convert.ToDateTime(sdr["createddate"].ToString()); objPO.updatedby = sdr["updatedby"].ToString(); objPO.updateddate = Convert.ToDateTime(sdr["updateddate"].ToString()); objPO.QuotationId = Convert.ToInt32(sdr["QuotationId"].ToString()); objPO.Comment = sdr["Comment"].ToString(); objPO.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); objPO.ApprovedBy = sdr["ApprovedBy"].ToString(); //objPO.POStatus = sdr["POStatus"].ToString(); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPO); }