public bool DeleteSparepart(Sparepart_ML ml)
        {
            try
            {
                var DataDic = new Dictionary<string, object>
                {
                    {"@Id", ml.sparepartId},

                };

                return new DBAccessController().UpdateRecord(StoredProcedures.sp_RemoveSparepart, DataDic);
            }
            catch (Exception)
            {
                
                throw;
            } 
        }
 public DataTable GetSpareparts(Sparepart_ML ml)
 {
     try
     {
         var DataDic = new Dictionary<string, object> 
         { 
             {"@sparepartName", ml.sparepartModel},
             {"@sparepartCategory", ml.sparepartCategoryName},
             {"@sparepartManufacturer", ml.spareManufacturerName},
             {"@spareparManufacYear", ml.spareManufacYear}
         };
         return new DBAccessController().RetriveRecordsWithPara(StoredProcedures.sp_GetSparepart, DataDic);
     }
     catch (Exception)
     {
         
         throw;
     }
 }
 private void GetSpareparts()
 {
     try
     {
         var ml = new Sparepart_ML();
         {
             ml.sparepartModel = string.IsNullOrEmpty(txtSparepartName.Text) ? "" : txtSparepartName.Text;
             ml.sparepartCategoryName = "";
             ml.spareManufacturerName = string.IsNullOrEmpty(txtManuName.Text) ? "" : txtManuName.Text;
             ml.spareManufacYear = "";
         };
         gridSpareparts.DataSource = new Sparepart_BL().GetSpareparts(ml);
         gridSpareparts.DataBind();
     }
     catch (Exception)
     {
         
         throw;
     }
 }
        public bool AddSparepart(Sparepart_ML ml)
        {
            try
            {
                var DataDic = new Dictionary<string, object>
                {
                    {"@sparepartName", ml.sparepartModel},
                    {"@sparepartCategory", ml.sparepartCategory},
                    {"@sparepartManufacturer", ml.spareManufacturer},
                    {"@spareparManufacYear", ml.spareManufacYear},
                    {"@sparepartUnitCost", ml.spareUnitCost}
                };

            return new DBAccessController().InsertRecord(StoredProcedures.sp_AddSparepart, DataDic);
            }
            catch (Exception)
            {
                
                throw;
            }
        }
        protected void btnUpdate_ServerClick(object sender, EventArgs e)
        {
            try
            {
                var ml = new Sparepart_ML()
                {
                    sparepartId = Convert.ToInt32(gridSpareparts.GetSelectedFieldValues("sparepartId")[0].ToString()),
                    sparepartModel = txtName.Text,
                    sparepartCategory = Convert.ToInt32(ddlCatogaries.SelectedValue),
                    spareManufacturer = Convert.ToInt32(ddlManufacturers.SelectedValue),
                    spareManufacYear = txtYear.Text,
                    spareUnitCost = Convert.ToSingle(txtUnitCost.Text)
                };

                var result = new Sparepart_BL().UpdateSparepart(ml);
                if (result)
                {
                    GetSpareparts();
                }
            }
            catch (Exception)
            {
                
                throw;
            }
        }
 protected void btnDelete_ServerClick(object sender, EventArgs e)
 {
     try
     {
         var ml = new Sparepart_ML()
         {
             sparepartId=Convert.ToInt32(gridSpareparts.GetSelectedFieldValues("sparepartId")[0].ToString())
         };
         new Sparepart_BL().DeleteSparepart(ml);
         GetSpareparts();
     }
     catch (Exception)
     {
         
         throw;
     }
 }