public List <PurchaseChargesEntity> GetPriceWiseReport(int MakeId, int ModelId, int ProcessorId) { List <PurchaseChargesEntity> productDetailList = new List <PurchaseChargesEntity>(); PurchaseChargesEntity productDetail; using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spPriceWiseReport", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter Make = cmd.Parameters.AddWithValue("@MakeId", MakeId); SqlParameter Model = cmd.Parameters.AddWithValue("@ModelId", ModelId); SqlParameter Processor = cmd.Parameters.AddWithValue("@ProcessorId", ProcessorId); bool isnull = true; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { isnull = false; productDetail = new PurchaseChargesEntity(); productDetail.MakeName = dr["MakeName"].ToString(); productDetail.ModelName = dr["ModelName"].ToString(); productDetail.ProcessorName = dr["ProcessorType"].ToString(); productDetail.ReceivedQty = Convert.ToInt32(dr["ReceivedQty"]); productDetail.SoldQty = Convert.ToInt32(dr["SoldQty"]); productDetail.RevisedPurchasePrice = Convert.ToDecimal(dr["RevisedPrice"]); productDetail.TotalCost = Convert.ToDecimal(dr["TotalCost"]); //productDetail.OrderNo = Convert.ToInt32(dr["OrderNo"]); productDetail.OrderQty = Convert.ToInt32(dr["OrderQty"]); productDetailList.Add(productDetail); } if (isnull) { return(null); } else { return(productDetailList); } } } } }
public List <PurchaseChargesEntity> GetTotalStockReportRefurb() { // int i = 0; PurchaseChargesEntity serialentity; List <PurchaseChargesEntity> serialentityList = new List <PurchaseChargesEntity>(); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spGetTotalStockReportRefurb", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); bool isnull = true; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { isnull = false; serialentity = new PurchaseChargesEntity(); serialentity.GulfNo = Convert.ToInt32(dr["GulfNo"]); serialentity.MakeName = dr["MakeName"].ToString(); serialentity.ModelName = dr["ModelName"].ToString(); serialentity.ProcessorName = dr["ProcessorType"].ToString(); serialentity.InhouseSerialNo = dr["InhouseSerialNo"].ToString(); serialentity.OriginalSerialNo = dr["OriginalSerialNo"].ToString(); serialentity.Status = dr["Status"].ToString(); serialentity.TypeName = dr["Type"].ToString(); serialentity.RevisedPurchasePrice = Convert.ToDecimal(dr["RevisedPurchasePrice"]); serialentity.Passback = Convert.ToDecimal(dr["Passback"]); serialentity.CustomDuty = Convert.ToDecimal(dr["CustomDuty"]); serialentity.FreightCharges = Convert.ToDecimal(dr["Freight"]); serialentity.Standardization = Convert.ToDecimal(dr["Standardization"]); serialentity.Miscellaneous = Convert.ToDecimal(dr["Miscellaneous"]); serialentity.PartsPrice = Convert.ToDecimal(dr["PartsPrice"]); serialentity.ExportFees = Convert.ToDecimal(dr["ExportFees"]); serialentity.LCD = Convert.ToDecimal(dr["LCD"]); serialentity.BatteryPrice = Convert.ToDecimal(dr["BatteryPrice"]); serialentity.ACAdaptorPrice = Convert.ToDecimal(dr["ACAdaptorPrice"]); serialentity.HardDiskPrice = Convert.ToDecimal(dr["HardDiskPrice"]); serialentity.RAMPrice = Convert.ToDecimal(dr["RAMPrice"]); serialentity.KeyboardPrice = Convert.ToDecimal(dr["KeyboardPrice"]); serialentity.COAPrice = Convert.ToDecimal(dr["COAPrice"]); serialentity.BodyPartsPrice = Convert.ToDecimal(dr["BodyPartsPrice"]); serialentity.InsurancePrice = Convert.ToDecimal(dr["InsurancePrice"]); serialentity.PackingPrice = Convert.ToDecimal(dr["PackingPrice"]); serialentity.TotalCost = Convert.ToDecimal(dr["TotalCost"]); serialentity.SoldCost = Convert.ToDecimal(dr["SoldCost"]); serialentityList.Add(serialentity); } if (isnull) { return(null); } else { return(serialentityList); } } } } }
public List <PurchaseChargesEntity> GetAvailableStockreport(int MakeId, int ModelId, int ProcessorId) { PurchaseChargesEntity productDetail; InventoryReportEntity InvReport; List <PurchaseChargesEntity> productDetailList = new List <PurchaseChargesEntity>(); //List<InventoryReportEntity> InvReportList = new List<InventoryReportEntity>(); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spGetAvailableStockReport", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter Make = cmd.Parameters.AddWithValue("@MakeId", MakeId); SqlParameter Model = cmd.Parameters.AddWithValue("@ModelId", ModelId); SqlParameter Processor = cmd.Parameters.AddWithValue("@ProcessorId", ProcessorId); bool isnull = true; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { isnull = false; productDetail = new PurchaseChargesEntity(); InvReport = new InventoryReportEntity(); productDetail.MakeName = dr["MakeName"].ToString(); productDetail.ModelName = dr["ModelName"].ToString(); productDetail.ProcessorName = dr["ProcessorType"].ToString(); productDetail.ReceivedQty = Convert.ToInt32(dr["ReceivedQty"]); productDetail.SoldQty = Convert.ToInt32(dr["SoldQty"]); productDetail.RevisedPurchasePrice = Convert.ToDecimal(dr["RevisedPrice"]); productDetail.TotalCost = Convert.ToDecimal(dr["TotalCost"]); //productDetail.OrderNo = Convert.ToInt32(dr["OrderNo"]); productDetail.OrderQty = Convert.ToInt32(dr["OrderQty"]); productDetail.IntransitQty = Convert.ToInt32(dr["IntransitQty"]); InvReport.AvailableQty = Convert.ToInt32(dr["AvailableQty"]); InvReport.ReceivedStatus = Convert.ToInt32(dr["ReceivedStatus"]); InvReport.InitialTestingStatus = Convert.ToInt32(dr["IntitialTestingStatus"]); InvReport.Unassembling = Convert.ToInt32(dr["Unassemble"]); InvReport.Motherboard = Convert.ToInt32(dr["Motherboard"]); InvReport.Batchmaking = Convert.ToInt32(dr["Batchmaking"]); InvReport.InQC = Convert.ToInt32(dr["InQC"]); InvReport.Assembling = Convert.ToInt32(dr["Assembling"]); InvReport.WorkShop = Convert.ToInt32(dr["WorkShop"]); InvReport.Testing = Convert.ToInt32(dr["Testing"]); InvReport.PendingStatus = Convert.ToInt32(dr["Pending"]); InvReport.OkStock = Convert.ToInt32(dr["OkStock"]); InvReport.WaitingForTagging = Convert.ToInt32(dr["WaitingForTagging"]); InvReport.Packaging = Convert.ToInt32(dr["Packaging"]); productDetail.inventoryReportEntityobj = InvReport; productDetailList.Add(productDetail); } if (isnull) { return(null); } else { return(productDetailList); } } } } }