private void button1_Click(object sender, EventArgs e)
{
string username = textBox1.Text;
string password = textBox2.Text;
string query = "Select * from Users " + " where codeuser = '******' AND password ='******'";
BaseDatos.DataBase BD = new BaseDatos.DataBase();
DataSet dades = BD.PortarPerConsulta(query);
int registres = dades.Tables[0].Rows.Count;
if (registres > 0)
{
attempt = 0;
this.WindowState = FormWindowState.Normal;
String user = textBox1.Text;
Modelos.User.setUserName(user);
LoginCarga lg = new LoginCarga(user);
lg.Show();
this.Hide();
}
else if (attempt++ == 2)
{
textBox2.Clear();
Amenaza amenaza = new Amenaza();
amenaza.Show();
this.Hide();
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet dtss = dades.PortarPerConsulta("select * from users");
uixCombobox1.DataSource = dtss.Tables[0];
uixCombobox1.ValueMember = uixCombobox1.CampID;
uixCombobox1.DisplayMember = uixCombobox1.CampMostrar;
}
private void CrystalReportForm_Load(object sender, EventArgs e)
{
Comanda comanda = new Comanda();
String query = "SELECT Agencies.CodeAgency, Planets.DescPlanet, OperationalAreas.CodeOperationalArea, Factories.codeFactory, Factories.DescFactory, Orders.codeOrder, Orders.dateOrder, Priority.DescPriority, OrdersDetail.Quantity, OrdersDetail.DeliveryDate, \"References\".codeReference, \"References\".descReference FROM ((((SecureCore.dbo.OrdersDetail OrdersDetail INNER JOIN (((SecureCore.dbo.OrderInfo OrderInfo INNER JOIN SecureCore.dbo.Agencies Agencies ON OrderInfo.idAgency=Agencies.idAgency) INNER JOIN SecureCore.dbo.OperationalAreas OperationalAreas ON OrderInfo.idOperationalArea=OperationalAreas.idOperationalArea) INNER JOIN SecureCore.dbo.Orders Orders ON OrderInfo.idOrder=Orders.idOrder) ON OrdersDetail.idOrder=Orders.idOrder) INNER JOIN SecureCore.dbo.Planets Planets ON OrdersDetail.idPlanet=Planets.idPlanet) INNER JOIN SecureCore.dbo.\"References\" \"References\" ON OrdersDetail.idReference=\"References\".idReference) INNER JOIN SecureCore.dbo.Factories Factories ON Orders.IdFactory=Factories.idFactory) INNER JOIN SecureCore.dbo.Priority Priority ON Orders.IdPriority=Priority.idPriority";
query += " WHERE Orders.idOrder = " + OrderModel.OrderCode + "";
ParameterFields parameterFields = new ParameterFields();
ParameterField OrderCodeParameter = new ParameterField();
OrderCodeParameter.Name = "codeOrder";
ParameterDiscreteValue val = new ParameterDiscreteValue();
val.Value = OrderModel.OrderCode;
OrderCodeParameter.CurrentValues.Add(val);
parameterFields.Add(OrderCodeParameter);
crvComanda.ParameterFieldInfo = parameterFields;
//
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = "DESKTOP-8FAQTCN\\SQLEXPRESS";
crConnectionInfo.DatabaseName = "SecureCore";
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
CrTables = comanda.Database.Tables;
foreach (Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
dts = bd.PortarPerConsulta(query);
comanda.SetDataSource(dts.Tables[0]);
crvComanda.ReportSource = comanda;
crvComanda.Refresh();
}
