Esempio n. 1
0
        public string PostComponent(clsAllComponents prComponent)
        {   // add
            try
            {
                int lcRecCount = clsDbConnection.Execute("INSERT INTO tblProduct" +
                                                         " (Type, Name, tblCategoryName, Price, Quantity, Brand, Condition, Warranty, Modified)" +
                                                         "VALUES (@Type, @Name, @CategoryName, @Price, @Quantity, @Brand, @Condition, @Warranty, @Modified)",
                                                         prepareComponentParameters(prComponent));
                if (lcRecCount == 1)
                {
                    return("Component succesfully added");
                }
                else
                {
                    return("Component Could not be added ");
                }
            }

            catch (SqlException ex)
            {
                if (ex.Number == 2627)
                {
                    return("There is already item with this name, select Another name for  the item and try again");
                }
                else
                {
                    return(ex.GetBaseException().Message);
                }
            }
        }
Esempio n. 2
0
        private Dictionary <string, object> prepareComponentParameters(clsAllComponents prComponent)
        {
            Dictionary <string, object> par = new Dictionary <string, object>(10);

            par.Add("Name", prComponent.Name);
            par.Add("CategoryName", prComponent.tblCategoryName);
            par.Add("Price", prComponent.Price);
            par.Add("Quantity", prComponent.Quantity);
            par.Add("Brand", prComponent.Brand);
            par.Add("Type", prComponent.Type);
            par.Add("Condition", prComponent.Condition);
            par.Add("Warranty", prComponent.Warranty);
            par.Add("Modified", prComponent.Modified);

            return(par);
        }
Esempio n. 3
0
        public clsAllComponents GetComponentDetails(string ID)
        {
            Dictionary <string, object> par = new Dictionary <string, object>(1);

            par.Add("Id", ID);
            DataTable        lcResult     = clsDbConnection.GetDataTable("SELECT * FROM tblProduct WHERE Name = @Id", par);
            clsAllComponents lcComponents = new clsAllComponents();

            return(new clsAllComponents()
            {
                Name = (string)lcResult.Rows[0]["Name"],
                tblCategoryName = (string)lcResult.Rows[0]["tblCategoryName"],
                Brand = (string)lcResult.Rows[0]["Brand"],
                Type = (string)lcResult.Rows[0]["Type"],
                Condition = (string)lcResult.Rows[0]["Condition"],
                Warranty = lcResult.Rows[0]["Warranty"] is DBNull ? (float?)null : Convert.ToSingle(lcResult.Rows[0]["Warranty"])
            });
        }
Esempio n. 4
0
 public string PutComponent(clsAllComponents prComponent)
 {   // insert
     try
     {
         int lcRecCount = clsDbConnection.Execute("UPDATE tblProduct SET" +
                                                  " Type = @Type, Name = @Name, tblCategoryName = @CategoryName, Price = @Price, Quantity = @Quantity, Brand = @Brand, Condition = @Condition, Warranty = @Warranty, Modified = @Modified" +
                                                  " WHERE Name = @Name",
                                                  prepareComponentParameters(prComponent));
         if (lcRecCount == 1)
         {
             return("Component succesfully Updated");
         }
         else
         {
             return("Item No longer exists ");
         }
     }
     catch (SqlException)
     {
         return("Item no longer exists");
     }
 }