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