void TrichXuatBaoCaoHocKy() { DatabaseBLL databasebll = new DatabaseBLL(); string con = null; con = databasebll.GetconnectionString(); string strConnect = "select bc.MaLop,l.SiSo, bc.SoLuongDat,bc.Tile" + " from BAOCAOTONGKETHOCKY bc, LOP l" + " where bc.MaLop = l.MaLop and MaHocKy= '" + cbHocKy_BCHK.Text + "' and MaNamHoc= '" + cbNamHoc_BCHK.Text + "'"; // MessageBox.Show(strConnect); SqlDataAdapter adapter = new SqlDataAdapter(strConnect, con); DataSet datasetHocky = new DataSet(); adapter.Fill(datasetHocky, "HocKy"); this.rpBaoCaoHocKy.LocalReport.ReportEmbeddedResource = "GUI.BaoCaoTongKet.ReportHocKy.rdlc"; ReportDataSource rpdsHocKy = new ReportDataSource(); rpdsHocKy.Name = "BaoCaoHocKy"; rpdsHocKy.Value = datasetHocky.Tables[0]; rpBaoCaoHocKy.LocalReport.DataSources.Add(rpdsHocKy); this.rpBaoCaoHocKy.RefreshReport(); }
void TrichXuatBaoCaoMonHoc() { DatabaseBLL databasebll = new DatabaseBLL(); string con = null; con = databasebll.GetconnectionString(); string strConnect = "select l.MaLop,l.SiSo,ct.SoLuongDatMon ,ct.TiLeDatMon " + " from BAOCAOTONGKETMON bc, LOP l, CT_BCAOTONGKETMON ct " + " where bc.MaBCTKM = ct.MaBCTKM and ct.MaLop = l.MaLop " + " and MaHocKy = '" + cbHocKy_BCMH.Text + "' and MaNamHoc = '" + cbNamHoc_BCMH.Text + "' and bc.MaMonHoc = '" + cbMonHoc_BCMH.Text + "'"; // MessageBox.Show(strConnect); SqlDataAdapter adapter = new SqlDataAdapter(strConnect, con); DataSet datasetMonHoc = new DataSet(); adapter.Fill(datasetMonHoc, "MonHoc"); this.rpBaoCaoMon.LocalReport.ReportEmbeddedResource = "GUI.BaoCaoTongKet.ReportMonHoc.rdlc"; ReportDataSource rpdsMonHoc = new ReportDataSource(); rpdsMonHoc.Name = "BaoCaoMonHoc"; rpdsMonHoc.Value = datasetMonHoc.Tables[0]; rpBaoCaoMon.LocalReport.DataSources.Add(rpdsMonHoc); this.rpBaoCaoMon.RefreshReport(); }
static void Main(string[] args) { DatabaseBLL _bll = new DatabaseBLL(); _bll.SomeWork(); Console.WriteLine("Good!"); Console.ReadLine(); }
void TrichXuatBaoCaoMonHoc() { // this.rpBaoCaoMon.RefreshReport(); DatabaseBLL databasebll = new DatabaseBLL(); string con = null; con = databasebll.GetconnectionString(); try { //cho he thong triger hoat dong cap nhat SqlConnection conn = new SqlConnection(con); conn.Open(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = " update CT_BCAOTONGKETMON set MaLop='L001' where MaLop='L001'"; com.Connection = conn; com.ExecuteNonQuery(); conn.Close(); } catch { } string strConnect = "select l.TenLop,l.SiSo,ct.SoLuongDatMon ,ct.TiLeDatMon " + " from BAOCAOTONGKETMON bc, LOP l, CT_BCAOTONGKETMON ct " + " where bc.MaBCTKM = ct.MaBCTKM and ct.MaLop = l.MaLop " + " and MaHocKy = '" + cbHocKy_BCMH.Text + "' and MaNamHoc = '" + cbNamHoc_BCMH.Text + "' and bc.MaMonHoc = '" + cbMonHoc_BCMH.Text + "'"; // MessageBox.Show(strConnect); SqlDataAdapter adapter = new SqlDataAdapter(strConnect, con); DataSet datasetMonHoc = new DataSet(); adapter.Fill(datasetMonHoc, "MonHoc"); // dataGridView1.DataSource = datasetMonHoc.Tables[0]; this.rpBaoCaoMon.LocalReport.ReportEmbeddedResource = "GUI.BaoCaoTongKet.ReportBaoCaoMonHoc.rdlc"; ReportParameter ReportParameterBaoCaoMonHoc = new ReportParameter ("ReportParameterBaoCaoMonHoc", cbHocKy_BCMH.Text + " " + cbNamHoc_BCMH.Text + " môn " + cbMonHoc_BCMH.Text); this.rpBaoCaoMon.LocalReport.SetParameters(ReportParameterBaoCaoMonHoc); ReportDataSource rpdsMonHoc = new ReportDataSource(); rpdsMonHoc.Name = "DataSetBaoCaoMonHoc"; rpdsMonHoc.Value = datasetMonHoc.Tables["MonHoc"]; rpBaoCaoMon.LocalReport.DataSources.Clear(); rpBaoCaoMon.LocalReport.DataSources.Add(rpdsMonHoc); this.rpBaoCaoMon.RefreshReport(); }
public JsonResult TestDatabase(string dataSource, string dbName, string userID, string password, short dbType) { Database db = new Database() { DataSource = dataSource, DbName = dbName, UserID = userID, Password = password, DbType = dbType }; ResultModel <object> rst = new ResultModel <object>(); rst.ResultStatus = DatabaseBLL.TestDatabase(db, out rst.ResultMessage); return(Json(rst)); }
void TrichXuatBaoCaoHocKy() { //this.rpBaoCaoHocKy.Refresh(); DatabaseBLL databasebll = new DatabaseBLL(); string con = null; con = databasebll.GetconnectionString(); try { //cho he thong triger hoat dong cap nhat SqlConnection conn = new SqlConnection(con); conn.Open(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = " update BAOCAOTONGKETHOCKY set MaNamHoc = 'NH16-17' where MaNamHoc = 'NH16-17'"; com.Connection = conn; com.ExecuteNonQuery(); conn.Close(); } catch { } string strConnect = "select l.TenLop,l.SiSo, bc.SoLuongDat,bc.Tile" + " from BAOCAOTONGKETHOCKY bc, LOP l" + " where bc.MaLop = l.MaLop and MaHocKy= '" + cbHocKy_BCHK.Text + "' and MaNamHoc= '" + cbNamHoc_BCHK.Text + "'"; // MessageBox.Show(strConnect); SqlDataAdapter adapter = new SqlDataAdapter(strConnect, con); DataSet datasetHocky = new DataSet(); adapter.Fill(datasetHocky, "HocKy"); this.rpBaoCaoHocKy.LocalReport.ReportEmbeddedResource = "GUI.BaoCaoTongKet.ReportHocKy.rdlc"; ReportParameter ReportParameterTime = new ReportParameter("ReportParameterTime", cbHocKy_BCHK.Text + " " + cbNamHoc_BCHK.Text); this.rpBaoCaoHocKy.LocalReport.SetParameters(ReportParameterTime); ReportDataSource rpdsHocKy = new ReportDataSource(); rpdsHocKy.Name = "BaoCaoHocKy"; rpdsHocKy.Value = datasetHocky.Tables["HocKy"]; rpBaoCaoHocKy.LocalReport.DataSources.Clear(); rpBaoCaoHocKy.LocalReport.DataSources.Add(rpdsHocKy); this.rpBaoCaoHocKy.RefreshReport(); }
// DELETE api/database/5 public void Delete(decimal id) { User user = HttpContext.Current.Session["SigninedUser"] as User; if (user == null || !user.IsAdmin) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden)); } string ResultMessage; int ResultStatus = DatabaseBLL.DeleteDatabase(id, out ResultMessage); if (ResultStatus == 0) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } else if (ResultStatus == -1) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.BadRequest)); } }
// POST api/database public Database Post(Database value) { User user = HttpContext.Current.Session["SigninedUser"] as User; if (user == null || !user.IsAdmin) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden)); } string ResultMessage; int ResultStatus = DatabaseBLL.InsertDatabase(ref value, out ResultMessage); if (ResultStatus == 0) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } else if (ResultStatus == -1) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.BadRequest)); } return(value); }
public async void btnIngresarClicked(object sender, EventArgs e) { btnLogin.IsEnabled = false; IsBusy = true; SeguridadBLL bll = new SeguridadBLL(); //Se borran las credeciales almacenadas bll.EliminarCredencialesUsuario(); if (await ParametrosSistema.isOnline) { TokenSeguridad token = null; try { lblEstado.Text = "Autenticando usuario."; token = await bll.Autenticar(txtUsuario.Text, txtPassword.Text); if (token != null) { lblEstado.Text = "Autenticación correcta."; Com.OneSignal.OneSignal.IdsAvailable idsPrinterDelegate = async delegate(string playerID, string pushToken) { try { NotificacionBLL notificacionBLL = new NotificacionBLL(); CodigoNotificacionAplicacionMovil not = new CodigoNotificacionAplicacionMovil(); not.OneSignalId = playerID; not.PushToken = string.Empty; not.Plataforma = "android"; not.Usuario = Common.ParametrosSistema.UsuarioActual; await notificacionBLL.RegistrarDispositivo(not); lblEstado.Text = "Dispositivo registrado correctamente."; } catch (Exception ex) { lblEstado.Text = "Error registrando dispositivo para notificaciones."; } }; lblEstado.Text = "Registrando dispositivo para notificaciones."; Com.OneSignal.OneSignal.GetIdsAvailable(idsPrinterDelegate); //Se crea la base de datos local lblEstado.Text = "Creando base de datos local."; DatabaseBLL dbBLL = new DatabaseBLL(); RespuestaProceso respuesta = await dbBLL.CrearBaseDeDatos(); lblEstado.Text = "Base de datos creada correctamente."; if (respuesta.ProcesadoCorrectamente == true) { btnLogin.IsEnabled = true; IsBusy = false; await Navigation.PopAsync(); await Navigation.PushAsync(new HomeView()); } else { btnLogin.IsEnabled = true; IsBusy = false; await Navigation.PushAsync(new ErrorView(respuesta.Respuesta)); } } else { btnLogin.IsEnabled = true; IsBusy = false; DisplayAlert("Error al Ingresar", "Ocurrió un error inesperado en la autenticación.", "Aceptar"); } } catch (Exception ex) { btnLogin.IsEnabled = true; IsBusy = false; if (ex.Message.Contains("Bad Request")) { DisplayAlert("Error al Ingresar", "Nombre de usuario y/o contraseña no válidos.", "Aceptar"); } else { DisplayAlert("Error al Ingresar", "Ocurrió un error inesperado en la autenticación.", "Aceptar"); } } } else { DisplayAlert("ERROR", "No tiene conexión a Internet", "Aceptar"); IsBusy = false; btnLogin.IsEnabled = true; } }
public CSDL() { InitializeComponent(); db = new DatabaseBLL(); }
// GET api/database public IEnumerable <Database> Get() { return(DatabaseBLL.ListDatabase()); }
public Database Get(decimal ID) { return(DatabaseBLL.GetDatabase(ID)); }