private void Cargar_Empresaid()
{
var BE = new tb_empresa();
var BL = new empresasBL();
var dt = new DataTable();
dt = BL.GetAll(BE).Tables[0];
cbo_empresaid.DataSource = dt;
cbo_empresaid.ValueMember = "empresaid";
cbo_empresaid.DisplayMember = "empresaname";
}
private void Empresa()
{
try
{
txtUsuar.Text = "";
txtClave.Text = "";
txtUsuar.Focus();
empresasBL BL = new empresasBL();
tb_empresa BE = new tb_empresa();
DataTable dt2 = new DataTable();
BE.empresaid = cboEmpresa.SelectedValue.ToString();
dt2 = BL.GetAll(BE).Tables[0];
VariablesPublicas.EmpresaID = dt2.Rows[0]["empresaid"].ToString();
VariablesPublicas.EmpresaName = dt2.Rows[0]["empresaname"].ToString();
VariablesPublicas.EmpresaRuc = dt2.Rows[0]["empresaruc"].ToString();
if (dt2.Rows[0]["foto"].ToString().Trim().Length != 0)
{
VariablesPublicas.EmpresaLogo = dt2.Rows[0]["foto"].ToString();
}
else
{
VariablesPublicas.EmpresaLogo = "nologoempresa.png";
}
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private BindingSource NewMethod()
{
empresasBL BL = new empresasBL();
tb_empresa BE = new tb_empresa();
DataTable table = BL.GetAll(BE).Tables[0];
DataRowCollection rows = table.Rows;
object[] cell;
Dictionary<string, string> dic = new Dictionary<string, string>();
BindingSource binding = new BindingSource();
foreach (DataRow item in rows)
{
cell = item.ItemArray;
dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString());
cell = null;
}
binding.DataSource = dic;
return binding;
}
private void cboEmpresa_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
txtUsuar.Text = string.Empty;
txtClave.Text = string.Empty;
txtUsuar.Focus();
empresasBL BL = new empresasBL();
tb_empresa BE = new tb_empresa();
DataTable dt2 = new DataTable();
BE.empresaid = cboEmpresa.Text.Substring(0, 2).Trim().PadLeft(2, '0');
dt2 = BL.GetAll(BE).Tables[0];
if (dt2.Rows.Count > 0)
{
VariablesPublicas.EmpresaID = dt2.Rows[0]["empresaid"].ToString();
VariablesPublicas.EmpresaName = dt2.Rows[0]["empresaname"].ToString().Trim();
VariablesPublicas.EmpresaRuc = dt2.Rows[0]["empresaruc"].ToString();
VariablesPublicas.EmpresaDirecc = dt2.Rows[0]["empresadirec"].ToString();
VariablesPublicas.EmpresaTelef = dt2.Rows[0]["empresatelef"].ToString();
VariablesPublicas.EmpresaSigla = dt2.Rows[0]["empresasigla"].ToString().Trim();
if (dt2.Rows[0]["foto"].ToString().Trim().Length != 0)
{
VariablesPublicas.EmpresaLogo = dt2.Rows[0]["foto"].ToString();
}
else
{
VariablesPublicas.EmpresaLogo = "nologoempresa.png";
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CrearBaseDatos_sdf()
{
var BL = new empresasBL();
var cod = cboEmpresa.SelectedValue.ToString();
if (BL.CrearBase_sdf(cod))
{
}
}