public List<Technology> DeviceCategoryBETWEENQuerySearch(string query,double FromPrice, double ToPrice)
{
List<Technology> TechnologyList = null;
SqlParameter[] Params = {
new SqlParameter("@Search", query),
new SqlParameter("@FromPrice", FromPrice),
new SqlParameter("@ToPrice", ToPrice)
};
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_DeviceCategoryBETWEENQuerySearch", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
TechnologyList = new List<Technology>();
foreach (DataRow row in table.Rows)
{
Technology Techno = new Technology();
Techno.TechID = (int)row["TechID"];
Techno.ProductID = (int)row["ProductID"];
Techno.ModelName = row["ModelName"].ToString();
Techno.ModelNumber = row["ModelNumber"].ToString();
Techno.ManufacturerID = (int)row["ManufacturerID"];
Techno.TechCategoryID = (int)row["TechCategoryID"];
Techno.SellingPrice = Convert.ToDouble(row["SellingPrice"]);
Techno.ImageFront = row["ImageFront"].ToString();
TechnologyList.Add(Techno);
}
}
}
return TechnologyList;
}
public Technology AddExperimentTech(Technology tech)
{
TechnologyHandler myHandler = new TechnologyHandler();
Technology t = new Technology();
t = myHandler.experimentalTech(tech);
return t;
}
//public bool InsertTechnologyProduct(Technology TechnoProduct)
//{
// SqlParameter[] Params = new SqlParameter[]
// {
// new SqlParameter("@CostPrice", TechnoProduct.CostPrice),
// new SqlParameter("@SellingPrice", TechnoProduct.SellingPrice),
// new SqlParameter("@DateAdded", TechnoProduct.DateAdded),
// new SqlParameter("@IsBook", TechnoProduct.IsBook = false)
// };
// return DataProvider.ExecuteNonQuery("sp_InsertProduct", CommandType.StoredProcedure,
// Params);
//}
public bool DeleteTechnology(Technology tech)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@ProductID", tech.ProductID),
new SqlParameter("@Status", tech.Status = true)
};
return DataProvider.ExecuteNonQuery("sp_DeleteTechnology", CommandType.StoredProcedure, //procedure
Params);
}
public List<Technology> CheckDuplicateDevice(string modelNumber)
{
List<Technology> deviceList = null;
SqlParameter[] Params = { new SqlParameter("@modelNumber", modelNumber) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_CheckDuplicateDevice", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
deviceList = new List<Technology>();
foreach (DataRow row in table.Rows)
{
Technology tech = new Technology(); ;
tech.ModelNumber = row["ModelNumber"].ToString();
deviceList.Add(tech);
}
}
}
return deviceList;
}
public bool UpdateTechProduct(Technology gadget)
{
TechnologyHandler myHandler = new TechnologyHandler(); return myHandler.UpdateTechnologyProduct(gadget);
}
public bool RestoreDevice(Technology tech)
{
TechnologyHandler myHandler = new TechnologyHandler();
return myHandler.RestoreDevice(tech);
}
public bool DeleteTechnology(Technology tech)
{
TechnologyHandler myHandler = new TechnologyHandler();
return myHandler.DeleteTechnology(tech);
}
public bool AddTechnology(Technology gadget)
{
TechnologyHandler myHandler = new TechnologyHandler();
return myHandler.InsertTechnology(gadget);
}
public bool UpdateTechnologyProduct(Technology TechnoProduct)
{
SqlParameter[] Params = {
new SqlParameter("@ProductID",TechnoProduct.ProductID),
new SqlParameter("@CostPrice", TechnoProduct.CostPrice),
new SqlParameter("@SellingPrice", TechnoProduct.SellingPrice),
new SqlParameter("@Status", TechnoProduct.Status),
new SqlParameter("@IsBook", false)
};
return DataProvider.ExecuteNonQuery("sp_NewManhattanProject", CommandType.StoredProcedure,
Params);
}
public bool UpdateTechnology(Technology TechnoProduct)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@ProductID", TechnoProduct.ProductID),
new SqlParameter("@ModelName", TechnoProduct.ModelName),
new SqlParameter("@ModelNumber", TechnoProduct.ModelNumber),
new SqlParameter("@Specs", TechnoProduct.Specs),
new SqlParameter("@TechID", TechnoProduct.TechID),
new SqlParameter("@ManufacturerID", TechnoProduct.ManufacturerID),
new SqlParameter("@TechCategoryID", TechnoProduct.TechCategoryID),
new SqlParameter("@SupplierID", TechnoProduct.SupplierID),
new SqlParameter("@ImageFront", TechnoProduct.ImageFront),
new SqlParameter("@ImageTop", TechnoProduct.ImageTop),
new SqlParameter("@ImageSide", TechnoProduct.ImageSide)
};
return DataProvider.ExecuteNonQuery("sp_UpdateTechnology", CommandType.StoredProcedure,
Params);
}
public Technology UGetTechnologyDetails(int ProductID)
{
Technology Techno = null;
SqlParameter[] Params = { new SqlParameter("@ProductID", ProductID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewSpecificTechUser",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
Techno = new Technology();
Techno.TechID = Convert.ToInt32(row["TechID"]);
Techno.ProductID = Convert.ToInt32(row["ProductID"]);
Techno.Specs = row["Specs"].ToString();
Techno.SellingPrice = Convert.ToDouble(row["SellingPrice"]);
Techno.ImageFront = row["ImageFront"].ToString();
Techno.ImageTop = row["ImageTop"].ToString();
Techno.ImageSide = row["ImageSide"].ToString();
Techno.ManufacturerID = (int)row["ManufacturerID"];
Techno.ModelNumber = row["ModelNumber"].ToString();
}
}
return Techno;
}
public List<Technology> TechnologyByManufacturer(int ManufacturerID)
{
List<Technology> TechnologyList = null;
SqlParameter[] Params = { new SqlParameter("@ManufacurerID", ManufacturerID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("ViewDevicesByManufacturer", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
TechnologyList = new List<Technology>();
foreach (DataRow row in table.Rows)
{
Technology Techno = new Technology();
Techno.TechID = (int)row["TechID"];
Techno.ProductID = (int)row["ProductID"];
Techno.ModelName = row["ModelName"].ToString();
Techno.Specs = row["Specs"].ToString();
Techno.ModelNumber = row["ModelNumber"].ToString();
Techno.ManufacturerID = (int)row["ManufacturerID"];
Techno.TechCategoryID = (int)row["TechCategoryID"];
Techno.SellingPrice = Convert.ToDouble(row["SellingPrice"]);
Techno.ImageFront = row["ImageFront"].ToString();
TechnologyList.Add(Techno);
}
}
}
return TechnologyList;
}
public bool RestoreDevice(Technology Tech)
{
SqlParameter[] Params = {
new SqlParameter("@ProductID", Tech.ProductID),
new SqlParameter("@Status", Tech.Status = false)
};
return DataProvider.ExecuteNonQuery("sp_RestoreTech", CommandType.StoredProcedure, Params);
}
public List<Technology> GetTechnologyList()
{
List<Technology> TechnologyList = null;
using (DataTable table = DataProvider.ExecuteSelectCommand("sp_ViewAllTechnologyUser",
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
TechnologyList = new List<Technology>();
foreach (DataRow row in table.Rows)
{
Technology Techno = new Technology();
Techno.TechID = (int)row["TechID"];
Techno.ProductID = (int)row["ProductID"];
Techno.ModelName = row["ModelName"].ToString();
Techno.Specs = row["Specs"].ToString();
Techno.ModelNumber = row["ModelNumber"].ToString();
Techno.SupplierID = Convert.ToInt32(row["SupplierID"].ToString());
Techno.ManufacturerID = (int)row["ManufacturerID"];
Techno.TechCategoryID = (int)row["TechCategoryID"];
Techno.SellingPrice = Convert.ToDouble(row["SellingPrice"]);
Techno.ImageFront = row["ImageFront"].ToString();
Techno.ImageTop = row["ImageTop"].ToString();
Techno.ImageSide = row["ImageSide"].ToString();
Techno.ModelName = Techno.ModelName.Substring(0, Math.Min(11, Techno.ModelName.Length));
Techno.ModelName += "...";
TechnologyList.Add(Techno);
}
}
}
return TechnologyList;
}
public Technology experimentalTech(Technology tech)
{
Technology tc;
SqlParameter[] Params = {
new SqlParameter("@CostPrice", tech.CostPrice),
new SqlParameter("@SellingPrice", tech.SellingPrice),
new SqlParameter("@DateAdded", tech.DateAdded),
new SqlParameter("@IsBook", tech.IsBook = false)
};
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ManhattanProject", CommandType.StoredProcedure, Params))
{
tc = new Technology();
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
tc.ProductID = Convert.ToInt32(row["ProductID"]);
}
}
return tc;
}
