public void BuscarDiasFaltantesGarantia(GunaLabel _LabelDiasFaltantes, GunaLabel _DataFinal, GunaLabel _DiasRestantes, int _idServico)
{
using (SqlConnection conexao = OpenConnection())
{
SqlDataReader dr;
string query = "select gar_data_inicial, gar_data_final, datediff(DD, GETDATE(), gar_data_final) as diferenca from tb_garantias where fk_servico_id = @_fkServico";
SqlCommand cmd = new SqlCommand(query, conexao);
cmd.Parameters.AddWithValue("@_fkServico", _idServico);
cmd.ExecuteNonQuery();
dr = cmd.ExecuteReader();
dr.Read();
_LabelDiasFaltantes.Text = dr.GetDateTime(0).ToShortDateString();
_DataFinal.Text = dr.GetDateTime(1).ToShortDateString();
if (dr.GetInt32(2) < 0)
{
_DiasRestantes.Text = "Faltam: 0 Dias";
}
else
{
_DiasRestantes.Text = "Faltam: " + dr.GetInt32(2).ToString() + " Dias";
}
dr.Close();
}
}
public void setLabel(string str)
{
GunaLabel lb = new GunaLabel();
lb.AutoSize = true;
lb.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lb.ForeColor = System.Drawing.Color.Gray;
lb.Size = new System.Drawing.Size(77, 25);
lb.Text = str;
flp_LinhKien.Controls.Add(lb);
}
public int capnhatNVCV_BUS(GunaLabel txtMaNV, GunaComboBox cbCV, GunaDateTimePicker tuNgay, GunaDateTimePicker denNgay, GunaCheckBox chb)
{
if (QuanLyNhanVienChucVu_DAO.Instance.kiemTraTonTai(txtMaNV.Text, cbCV.SelectedValue.ToString(), tuNgay.Value) <= 0)
{
return(0);//kiểm tra đã tồn tại nhân viên với cv này chưa?
}
string strDenNgay = denNgay.Text;
int kiemtra = kiemTraDuLieu(txtMaNV, cbCV, tuNgay, denNgay, chb, ref strDenNgay);
if (kiemtra == 3)
{
QuanLyNhanVienChucVu_DTO nvcv = new QuanLyNhanVienChucVu_DTO(txtMaNV.Text, cbCV.SelectedValue.ToString(), tuNgay.Value, strDenNgay);
QuanLyNhanVienChucVu_DAO.Instance.capnhatNVCV_DAO(nvcv);
}
return(kiemtra);
}
public bool timKiemTrinhDoChuyenMon_BUS(GunaTextBox maNV, GunaLabel txtTenNV, GunaDataGridView gr)
{
HoSoNV_DTO nv = new HoSoNV_DTO
{
MaNV = maNV.Text
};
TrinhDoChuyenMon_DAO.createInstance.timKiemTrinhDoChuyenMon_DAO(nv);
txtTenNV.Text = nv.HoTen;
if (nv.HoTen == null)
{
return(false);
}
TrinhDoChuyenMon_DAO.createInstance.hienThi(gr, nv.MaNV);
return(true);
}
public bool layThongTinHoSo_BUS(GunaTextBox txtMaNV, GunaLabel lb1, GunaLabel lb2)
{
HoSoNV_DTO nhanvien = new HoSoNV_DTO();
nhanvien = QuanLyQuaTrinhCongTac_DAO.Instance.layThongTinHoSo_DAO(txtMaNV.Text);
if (nhanvien.MaNV != null)
{
lb1.Text = nhanvien.MaNV;
lb2.Text = nhanvien.HoTen;
return(true);
}
else
{
return(false);
}
}
public void TotalGanho(GunaLabel label, int _AnoAtual)
{
SqlDataReader dr;
using (SqlConnection con = OpenConnection())
{
string Query = "SELECT SUM(sv_lucro) as Mes FROM tb_servicos WHERE year(sv_data) = @AnoAtual";
SqlCommand cmd = new SqlCommand(Query, con);
cmd.Parameters.Add("@AnoAtual", SqlDbType.VarChar).Value = _AnoAtual;
dr = cmd.ExecuteReader();
dr.Read();
label.Text = "R$ " + Convert.ToString(dr.GetDecimal(0));
//con.Close();
}
}
public void BuscarDiasGarantia(GunaLabel _Emissao, GunaLabel _DataFinal, GunaLabel _DiasRestantes, int _idServico)
{
using (SqlConnection conexao = OpenConnection())
{
SqlDataReader dr;
string procedure = "GarantiaQuantosDias";
SqlCommand cmd = new SqlCommand(procedure, conexao);
cmd.Parameters.AddWithValue("@_fkServico", _idServico);
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader();
dr.Read();
_Emissao.Text = dr.GetDateTime(0).ToShortDateString();
_DataFinal.Text = dr.GetDateTime(1).ToShortDateString();
_DiasRestantes.Text = "Garantia: " + dr.GetInt32(2).ToString() + " Dias";
dr.Close();
}
}
public int kiemTraDuLieu(GunaLabel txtMaNV, GunaComboBox cbCV, GunaDateTimePicker tuNgay, GunaDateTimePicker denNgay, GunaCheckBox chb, ref string strDenNgay)
{
int kt = 0;
if (chb.Checked)
{
if (QuanLyNhanVienChucVu_DAO.Instance.kiemTraThoiGian(txtMaNV.Text, cbCV.SelectedValue.ToString()) > 0)
{
return(1);// kiểm tra nhân viên có đang làm công việc nào đó không?
}
else
{
strDenNgay = "Nay";
return(3);
}
}
kt = tuNgay.Value.CompareTo(denNgay.Value);
if (kt == 0 || kt >= 1)
{
return(2);// kiểm tra ngày tháng nhập vào có đúng theo quy tắc không? từ ngày < đến ngày
}
return(3);
}
private void CreateListOfProducts()
{
for (int i = 0; i < ListBIN.Count; i++)
{
string CPU, GPU, RAM, COST;
GunaLabel CPU_label = new GunaLabel();
GunaLabel GPU_label = new GunaLabel();
GunaLabel RAM_label = new GunaLabel();
GunaLabel COST_label = new GunaLabel();
BunifuImageButton IMGpb = new BunifuImageButton();
BunifuImageButton deleteProductButton = new BunifuImageButton();
tabControlPRODUCTs.TabPages.Add($"PC: {i + 1}");
tabControlPRODUCTs.TabPages[i].Name = ListBIN[i].ID.ToString();
tabControlPRODUCTs.TabPages[i].BackColor = Color.FromArgb(171717);
#region takeINFaboutID
CPU = ListBIN[i].CPU;
CPU_label.Text = "CPU: " + CPU;
CPU_label.Location = new Point(10, 50);
CPU_label.Visible = true;
CPU_label.Size = new Size(200, 15);
CPU_label.ForeColor = Color.DarkCyan;
CPU_label.Font = new Font("Unispace", 8F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)));
tabControlPRODUCTs.TabPages[i].Controls.Add(CPU_label);
GPU = ListBIN[i].GPU;
GPU_label.Text = "GPU: " + GPU;
GPU_label.Location = new Point(10, 75);
GPU_label.Visible = true;
GPU_label.Size = new Size(200, 15);
GPU_label.ForeColor = Color.DarkCyan;
GPU_label.Font = new Font("Unispace", 8F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)));
tabControlPRODUCTs.TabPages[i].Controls.Add(GPU_label);
RAM = ListBIN[i].RAM.ToString();
RAM_label.Text = "RAM: " + RAM + "GB";
RAM_label.Location = new Point(10, 100);
RAM_label.Visible = true;
RAM_label.Size = new Size(200, 15);
RAM_label.ForeColor = Color.DarkCyan;
RAM_label.Font = new Font("Unispace", 8F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)));
tabControlPRODUCTs.TabPages[i].Controls.Add(RAM_label);
COST = ListBIN[i].COST.ToString();
COST_label.Text = "PRICE: " + COST + "$";
COST_label.Location = new Point(10, 125);
COST_label.Visible = true;
COST_label.Size = new Size(200, 15);
COST_label.ForeColor = Color.OrangeRed;
COST_label.Font = new Font("Unispace", 8F, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)));
tabControlPRODUCTs.TabPages[i].Controls.Add(COST_label);
IMGpb.Image = ListBIN[i].IMG;
IMGpb.Visible = true;
IMGpb.Size = new Size(190, 173);
IMGpb.SizeMode = PictureBoxSizeMode.StretchImage;
IMGpb.Location = new Point(245, 14);
IMGpb.Zoom = 5;
tabControlPRODUCTs.TabPages[i].Controls.Add(IMGpb);
deleteProductButton.Image = Resources.trash;
deleteProductButton.Location = new Point(tabControlPRODUCTs.Location.X, 10);
deleteProductButton.SizeMode = PictureBoxSizeMode.StretchImage;
deleteProductButton.Size = new Size(30, 30);
deleteProductButton.BackColor = Color.Transparent;
tabControlPRODUCTs.TabPages[i].Controls.Add(deleteProductButton);
deleteProductButton.Click += (s, e) =>
{
if (ListBIN.Count > 0)
{
ListBIN.Remove(ListBIN[i - 1]);
i--;
}
tabControlPRODUCTs.TabPages.Remove(tabControlPRODUCTs.SelectedTab);
if (tabControlPRODUCTs.TabCount == 0)
{
imageButtonCONFIRMorder.BackColor = Color.SlateGray;
imageButtonCONFIRMorder.Enabled = false;
imageButtonCONFIRMorder.Image = Resources.X;
}
};
#endregion
}
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyNhanVienChucVu_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
public bool xoaNVCV_BUS(GunaLabel strMaNV, GunaLabel strMaCV, GunaDateTimePicker tuNgay)
{
return(QuanLyNhanVienChucVu_DAO.Instance.xoaNVCV_DAO(strMaNV.Text, strMaCV.Text, tuNgay.Value));
}
public int themTrinhDoChuyenMon(GunaLabel ma, GunaComboBox td, GunaComboBox lh, GunaTextBox truong, GunaTextBox ng)
{
TrinhDoChuyenMon_DTO tdcm = new TrinhDoChuyenMon_DTO(ma.Text, ng.Text, td.SelectedItem.ToString(), lh.SelectedItem.ToString(), truong.Text);
return(TrinhDoChuyenMon_DAO.createInstance.themTrinhDoChuyenMon(tdcm));
}
public bool xoaNVCV_BUS(GunaLabel strMaNV, GunaDateTimePicker tuNgay)
{
return(QuanLyQuaTrinhCongTac_DAO.Instance.xoaNVCV_DAO(strMaNV.Text, tuNgay.Value));
}
public bool capnhatNVCV_BUS(GunaLabel txtMNV, GunaComboBox cbCV, GunaDateTimePicker tuNgay, GunaDateTimePicker denNgay, GunaTextBox noiCongTac)
{
return(QuanLyQuaTrinhCongTac_DAO.Instance.capnhatNVCV_DAO(txtMNV.Text, tuNgay.Value, denNgay.Value, noiCongTac.Text, cbCV.SelectedValue.ToString()));
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyQuaTrinhCongTac_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
public void hienThi(GunaDataGridView gr, GunaLabel txtMaNV)
{
TrinhDoChuyenMon_DAO.createInstance.hienThi(gr, txtMaNV.Text);
}
public void Preencher(BunifuDataViz bunifuDataViz1, int lblAno, GunaLabel lblJan, GunaLabel lblFev, GunaLabel lblMar,
GunaLabel lblAbr, GunaLabel lblMai, GunaLabel lblJun, GunaLabel lblJul, GunaLabel lblAgo, GunaLabel lblSet, GunaLabel lblOut,
GunaLabel lblNov, GunaLabel lblDez, int[] corRgb)
{
SqlDataReader dr;
DataPoint graficoArea;
//graficoArea = new DataPoint(BunifuDataViz._type.Bunifu_splineArea);
//graficoLinha = new DataPoint(BunifuDataViz._type.Bunifu_spline);
graficoArea = new DataPoint(BunifuDataViz._type.Bunifu_stackedColumn);
//graficoLinha = new DataPoint(BunifuDataViz._type.Bunifu_spline);
var canvas = new Canvas();
//int qntServicosAnuais = 0;
int[] qntServicosPorMes = { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
using (SqlConnection con = OpenConnection())
{
string procedure = "ServicosUltimoAno";
SqlCommand cmd = new SqlCommand(procedure, con);
cmd.Parameters.AddWithValue("@Ano", lblAno);
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader();
while (dr.Read())
{
//MessageBox.Show(""+dr.GetInt32(0) + " --- "+ dr.GetDateTime(1), "");
switch (dr.GetString(2))
{
case "Janeiro":
qntServicosPorMes[0] += 1;
break;
case "Fevereiro":
qntServicosPorMes[1] += 1;
break;
case "Março":
qntServicosPorMes[2] += 1;
break;
case "Abril":
qntServicosPorMes[3] += 1;
break;
case "Maio":
qntServicosPorMes[4] += 1;
break;
case "Junho":
qntServicosPorMes[5] += 1;
break;
case "Julho":
qntServicosPorMes[6] += 1;
break;
case "Agosto":
qntServicosPorMes[7] += 1;
break;
case "Setembro":
qntServicosPorMes[8] += 1;
break;
case "Outubro":
qntServicosPorMes[9] += 1;
break;
case "Novembro":
qntServicosPorMes[10] += 1;
break;
case "Dezembro":
qntServicosPorMes[11] += 1;
break;
}
}
if (dr.HasRows)
{
lblJan.Visible = true;
lblFev.Visible = true;
lblMar.Visible = true;
lblAbr.Visible = true;
lblMai.Visible = true;
lblJun.Visible = true;
lblJul.Visible = true;
lblAgo.Visible = true;
lblSet.Visible = true;
lblOut.Visible = true;
lblNov.Visible = true;
lblDez.Visible = true;
lblJan.Text = qntServicosPorMes[0].ToString();
lblFev.Text = qntServicosPorMes[1].ToString();
lblMar.Text = qntServicosPorMes[2].ToString();
lblAbr.Text = qntServicosPorMes[3].ToString();
lblMai.Text = qntServicosPorMes[4].ToString();
lblJun.Text = qntServicosPorMes[5].ToString();
lblJul.Text = qntServicosPorMes[6].ToString();
lblAgo.Text = qntServicosPorMes[7].ToString();
lblSet.Text = qntServicosPorMes[8].ToString();
lblOut.Text = qntServicosPorMes[9].ToString();
lblNov.Text = qntServicosPorMes[10].ToString();
lblDez.Text = qntServicosPorMes[11].ToString();
}
else
{
lblJan.Visible = false;
lblFev.Visible = false;
lblMar.Visible = false;
lblAbr.Visible = false;
lblMai.Visible = false;
lblJun.Visible = false;
lblJul.Visible = false;
lblAgo.Visible = false;
lblSet.Visible = false;
lblOut.Visible = false;
lblNov.Visible = false;
lblDez.Visible = false;
}
//Se liga na desgraca que voce aqui pvt
//to ligado que voce ta vendo isso em dubai
//mas voce era macacao pra porra pqp.
graficoArea.addLabely("JAN".ToUpper(), qntServicosPorMes[0]);
graficoArea.addLabely("FEV".ToUpper(), qntServicosPorMes[1]);
graficoArea.addLabely("MAR".ToUpper(), qntServicosPorMes[2]);
graficoArea.addLabely("ABR".ToUpper(), qntServicosPorMes[3]);
graficoArea.addLabely("MAI".ToUpper(), qntServicosPorMes[4]);
graficoArea.addLabely("JUN".ToUpper(), qntServicosPorMes[5]);
graficoArea.addLabely("JUL".ToUpper(), qntServicosPorMes[6]);
graficoArea.addLabely("AGO".ToUpper(), qntServicosPorMes[7]);
graficoArea.addLabely("SET".ToUpper(), qntServicosPorMes[8]);
graficoArea.addLabely("OUT".ToUpper(), qntServicosPorMes[9]);
graficoArea.addLabely("NOV".ToUpper(), qntServicosPorMes[10]);
graficoArea.addLabely("DEZ".ToUpper(), qntServicosPorMes[11]);
//bunifuDataViz1.colorSet.Add(Color.FromArgb(0, 168, 235));
bunifuDataViz1.colorSet.Add(Color.FromArgb(corRgb[0], corRgb[1], corRgb[2]));
bunifuDataViz1.colorSet.Add(Color.White);
canvas.addData(graficoArea);
//graficoLinha.addLabely(vetNomeDiaSemana[0].ToUpper(), vetDiaSemana[0]);
//graficoLinha.addLabely("JAN".ToUpper(), qntServicosPorMes[0]);
//graficoLinha.addLabely("FEV".ToUpper(), qntServicosPorMes[1]);
//graficoLinha.addLabely("MAR".ToUpper(), qntServicosPorMes[2]);
//graficoLinha.addLabely("ABR".ToUpper(), qntServicosPorMes[3]);
//graficoLinha.addLabely("MAI".ToUpper(), qntServicosPorMes[4]);
//graficoLinha.addLabely("JUN".ToUpper(), qntServicosPorMes[5]);
//graficoLinha.addLabely("JUL".ToUpper(), qntServicosPorMes[6]);
//graficoLinha.addLabely("AGO".ToUpper(), qntServicosPorMes[7]);
//graficoLinha.addLabely("SET".ToUpper(), qntServicosPorMes[8]);
//graficoLinha.addLabely("OUT".ToUpper(), qntServicosPorMes[9]);
//graficoLinha.addLabely("NOV".ToUpper(), qntServicosPorMes[10]);
//graficoLinha.addLabely("DEZ".ToUpper(), qntServicosPorMes[11]);
//canvas.addData(graficoLinha);
bunifuDataViz1.Render(canvas);
//bunifuDataViz1.Update();
}
}
public int xoaTrinhDoChuyenMon(GunaLabel ma, GunaTextBox nganh)
{
return(TrinhDoChuyenMon_DAO.createInstance.xoaTrinhDoChuyenMon(nganh.Text, ma.Text));
}
public bool xoaNVCV_BUS(GunaLabel txtMNV, GunaComboBox cbCV, GunaTextBox gunaTextBox1)
{
return(QuanLyTrinhDoNgoaiNgu_DAO.Instance.xoaNVCV_DAO(txtMNV.Text, cbCV.SelectedValue.ToString(), gunaTextBox1.Text));
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyTrinhDoNgoaiNgu_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
