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