}//end method GetSelectedRow // Delete a given service public void DeleteService(ServiceVO service) { String serviceID = service.ID; int selectedrow = gridViewServices.FocusedRowHandle; try { int result = serviceBUS.DeleteService(service); if (result != -1) { LoadData(); SelectRow(selectedrow - 1); //ShowMessage("Xóa dịch vụ thành công"); } // end if } //end try catch (SqlException ex) { if (ex.Number == 547) { ShowError("Dịch vụ đã được sử dụng ở dữ liệu khác. Vui lòng dùng \"Tắt dịch vụ\""); } //end case: error 547 } //end catch SqlException catch (Exception ex) { ShowError(ex.Message); } //end catch Exception } //end method DeleteSelected
}//end method SetData public ServiceVO GetData() { Double price; try { price = Double.Parse(textBoxServicePrice.Text); }//end try catch (Exception e) { if (e is ArgumentNullException || e is FormatException) { price = data.Price; } else { throw; } }//end catch String id = data.ID; String name = textBoxServiceName.Text; bool state = GetCheckedState(); data = new ServiceVO(id, name, price, state); return(data); }//end method GetData
} // end method GetAllServices public int DeleteService(ServiceVO service) { try { return(serviceDAO.DeleteService(service)); }// end try catch (SqlException e) { throw e; } // end catch } // end method DeleteServiceByID
} // end method DeleteServiceByID public int InsertService(ServiceVO service) { try { return(this.serviceDAO.InsertService(service)); }// end try catch (SqlException e) { throw e; } // end catch } // end method InsertService
}//end constructor #endregion //end region Constructors #region Methods public void InsertService() { ServiceVO service = inputAddUI.Data; try { gridViewUI.InsertNewService(service); }//end try catch (Exception e) { MessageBox.Show(e.Message); } //end catch } //end method Insert
} // end method getAllServices public int DeleteService(ServiceVO service) { try { // build delete query String delete = "DELETE FROM DICH_VU WHERE MA_DICH_VU=@MA_DICH_VU"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@MA_DICH_VU", service.ID); int result = Connection.ExecuteNonQuery(delete, param); return(result); }// end try catch (SqlException e) { throw e; } // end catch } // end method DeleteService
}//end constructor #endregion //end region Constructor #region Methods public ServiceVO GetData() { ServiceVO service = null; try { String name = textBoxName.Text; Double price = Double.Parse(textBoxPrice.Text); service = new ServiceVO(null, name, price, true); }//end try catch (FormatException e) { throw e; } //end catch return(service); } //end method GetData
}//end method SetCheckedState public void SetData(ServiceVO service) { if (service == null) { SetMode(Mode.Empty); }//end if service is null else { SetMode(Mode.Active); textBoxServiceName.Text = service.Name; textBoxServicePrice.Text = service.Price.ToString(); SetCheckedState(service.State); }//end else // Update data data = service; }//end method SetData
} // end method DeleteService public int InsertService(ServiceVO service) { try { // build insert query String insert = "INSERT INTO DICH_VU(TEN_DICH_VU, DON_GIA) " + "VALUES(@TEN_DICH_VU, @DON_GIA)"; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@TEN_DICH_VU", service.Name); param[1] = new SqlParameter("@DON_GIA", service.Price); int result = Connection.ExecuteNonQuery(insert, param); return(result); }// end try catch (SqlException e) { throw e; } // end catch } // end method InsertService
} // end method InsertService public int UpdateService(ServiceVO service) { try { //build query String update = "UPDATE DICH_VU " + "SET TEN_DICH_VU=@TEN_DICH_VU, DON_GIA=@DON_GIA, HIEU_LUC=@HIEU_LUC " + "WHERE MA_DICH_VU=@MA_DICH_VU"; SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@MA_DICH_VU", service.ID); param[1] = new SqlParameter("@TEN_DICH_VU", service.Name); param[2] = new SqlParameter("@DON_GIA", service.Price); param[3] = new SqlParameter("@HIEU_LUC", service.State); int result = Connection.ExecuteNonQuery(update, param); return(result); }//end try catch (SqlException e) { throw e; } //end catch } //end method UpdateService
} //end method DeleteSelected // Insert a new service public void InsertNewService(ServiceVO service) { try { int result = serviceBUS.InsertService(service); if (result == -1) { ShowError("Không thể thêm dịch vụ mới"); }// end if else { LoadData(); SelectRow(gridViewServices.RowCount - 1); } }//end try catch (Exception exp) { ShowError(exp.Message); } //end catch } //end method InsertNewService
} //end method InsertNewService // Update a service public void UpdateSevice(ServiceVO service) { int selectedrow = gridViewServices.FocusedRowHandle; try { int result = serviceBUS.UpdateService(service); if (result == -1) { ShowError("Không thể cập nhật dịch vụ"); }//end if else { LoadData(); SelectRow(selectedrow); } //end else } //end try catch (Exception e) { ShowError(e.Message); } //end catch } //end method UpdateService
}//end method LoadControls // Load data from grid view to updating panel public void LoadUpdatePanel() { ServiceVO service = gridViewUI.GetSelectedService(); inputUpdateUI.SetData(service); }//end method LoadUpdatePanel
}//end method DeleteService public void UpdateService() { ServiceVO service = inputUpdateUI.GetData(); gridViewUI.UpdateSevice(service); }//end method UpdateService
} // end method InsertService public int UpdateService(ServiceVO service) { return(serviceDAO.UpdateService(service)); }//end method UpdateService