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