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