/// <summary>
/// Creates a new instance of the Vir_ConveyorLink class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Vir_ConveyorLink MakeVir_ConveyorLink(SqlDataReader dataReader)
{
Vir_ConveyorLink vir_ConveyorLink = new Vir_ConveyorLink();
vir_ConveyorLink.ConveyorLinkID = SqlClientUtility.GetInt32(dataReader, "ConveyorLinkID", 0);
vir_ConveyorLink.BagPositionID = SqlClientUtility.GetInt32(dataReader, "BagPositionID", 0);
vir_ConveyorLink.ConveyorID = SqlClientUtility.GetInt32(dataReader, "ConveyorID", 0);
return(vir_ConveyorLink);
}
/// <summary>
/// Saves a record to the Vir_ConveyorLink table.
/// </summary>
public virtual void Insert(Vir_ConveyorLink vir_ConveyorLink)
{
ValidationUtility.ValidateArgument("vir_ConveyorLink", vir_ConveyorLink);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@BagPositionID", vir_ConveyorLink.BagPositionID),
new SqlParameter("@ConveyorID", vir_ConveyorLink.ConveyorID)
};
vir_ConveyorLink.ConveyorLinkID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_Insert", parameters);
}
/// <summary>
/// Updates a record in the Vir_ConveyorLink table.
/// </summary>
public virtual void Update(Vir_ConveyorLink vir_ConveyorLink)
{
ValidationUtility.ValidateArgument("vir_ConveyorLink", vir_ConveyorLink);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ConveyorLinkID", vir_ConveyorLink.ConveyorLinkID),
new SqlParameter("@BagPositionID", vir_ConveyorLink.BagPositionID),
new SqlParameter("@ConveyorID", vir_ConveyorLink.ConveyorID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_Update", parameters);
}
private void buttonAgregar_Click(object sender, EventArgs e)
{
//vir_BagPosition_SelectAllBindingNavigatorSaveItem.PerformClick();
bagPositionNameTextBox.Text = bagPositionNameTextBox.Text.Trim();
if (!Funciones.ValidateText(bagPositionNameTextBox, ref errorProvider1))
{
bagPositionNameTextBox.Focus();
return;
}
string t = targetQuantityTextBox.Text;
this.Validate();
this.vir_BagPosition_SelectAllBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.dataSetBagPosition);
DataRowView conveyor = (DataRowView)listBoxUnassignedConveyors.SelectedItem;
if (conveyor == null)
{
MessageBox.Show("PLease select a conveyor to add!");
listBoxUnassignedConveyors.Focus();
return;
}
int bagPositionID = 0;
int.TryParse(bagPositionIDTextBox.Text, out bagPositionID);
if (vir_ConveyorLink_Sp == null)
{
vir_ConveyorLink_Sp = new Vir_ConveyorLink_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
//vir_ConveyorLink_Sp._DeleteByBagPositionIDConveyorID(bagPositionID, c.ConveyorID);
vir_ConveyorLink = new Vir_ConveyorLink();
vir_ConveyorLink.BagPositionID = bagPositionID;
int conveyorid = 0;
int.TryParse(conveyor["conveyorid"].ToString(), out conveyorid);
vir_ConveyorLink.ConveyorID = conveyorid;
vir_ConveyorLink_Sp.Insert(vir_ConveyorLink);
bindListBoxConveyors();
}
/// <summary>
/// Selects all records from the Vir_ConveyorLink table.
/// </summary>
public virtual List <Vir_ConveyorLink> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_SelectAll"))
{
List <Vir_ConveyorLink> vir_ConveyorLinkList = new List <Vir_ConveyorLink>();
while (dataReader.Read())
{
Vir_ConveyorLink vir_ConveyorLink = MakeVir_ConveyorLink(dataReader);
vir_ConveyorLinkList.Add(vir_ConveyorLink);
}
return(vir_ConveyorLinkList);
}
}
/// <summary>
/// Selects all records from the Vir_ConveyorLink table by a foreign key.
/// </summary>
public virtual List <Vir_ConveyorLink> _SelectAllByConveyorID(int conveyorID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ConveyorID", conveyorID)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_SelectAllByConveyorID", parameters))
{
List <Vir_ConveyorLink> vir_ConveyorLinkList = new List <Vir_ConveyorLink>();
while (dataReader.Read())
{
Vir_ConveyorLink vir_ConveyorLink = MakeVir_ConveyorLink(dataReader);
vir_ConveyorLinkList.Add(vir_ConveyorLink);
}
return(vir_ConveyorLinkList);
}
}
private void bindListBoxConveyors()
{
//DataSet dsAssigned, dsUnAssigned;
//DataTable dtAssigned, dtUnAssigned;
//DataRow drAssigned, drUnAssigned;
dsAssigned = new DataSet();
dtAssigned = new DataTable("MyTable");
dtAssigned.Columns.Add(new DataColumn("id", typeof(int)));
dtAssigned.Columns.Add(new DataColumn("name", typeof(string)));
dtAssigned.Columns.Add(new DataColumn("conveyorId", typeof(string)));
dsUnassigned = new DataSet();
dtUnassigned = new DataTable("MyTable");
dtUnassigned.Columns.Add(new DataColumn("id", typeof(int)));
dtUnassigned.Columns.Add(new DataColumn("name", typeof(string)));
dtUnassigned.Columns.Add(new DataColumn("conveyorId", typeof(string)));
listBoxUnassignedConveyors.DataSource = null;
listBoxAssignedConveyors.DataSource = null;
int bagPositionID = 0;
int.TryParse(bagPositionIDTextBox.Text, out bagPositionID);
if (vir_ConveyorLink_Sp == null)
{
vir_ConveyorLink_Sp = new Vir_ConveyorLink_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
if (vir_Conveyor_Sp == null)
{
vir_Conveyor_Sp = new Vir_Conveyor_Sp(Properties.Settings.Default.WsirDbConnectionString);
}
List <Vir_Conveyor> vir_ConveyorList = vir_Conveyor_Sp.SelectAll();
foreach (Vir_Conveyor c in vir_ConveyorList)
{
vir_ConveyorLink = vir_ConveyorLink_Sp._SelectByBagPositionIDConveyorID(bagPositionID, c.ConveyorID);
if (vir_ConveyorLink == null)
{
drUnassigned = dtUnassigned.NewRow();
drUnassigned["id"] = 0; // vir_ConveyorLink.ConveyorLinkID;
drUnassigned["name"] = c.ConveyorDescription;
drUnassigned["conveyorid"] = c.ConveyorID;
dtUnassigned.Rows.Add(drUnassigned);
}
else
{
drAssigned = dtAssigned.NewRow();
drAssigned["id"] = vir_ConveyorLink.ConveyorLinkID;
drAssigned["name"] = c.ConveyorDescription;
drAssigned["conveyorid"] = c.ConveyorID;
dtAssigned.Rows.Add(drAssigned);
}
}
//Unassigned
dsUnassigned.Tables.Add(dtUnassigned);
listBoxUnassignedConveyors.ValueMember = "id";
listBoxUnassignedConveyors.DisplayMember = "name";
listBoxUnassignedConveyors.DataSource = dtUnassigned;
//listBoxUnassignedConveyors.Items.Add(c.ConveyorDescription);
//Assigned
dsAssigned.Tables.Add(dtAssigned);
//listBoxAssignedConveyors.Items.Add(c.ConveyorDescription);
listBoxAssignedConveyors.ValueMember = "id";
listBoxAssignedConveyors.DisplayMember = "name";
listBoxAssignedConveyors.DataSource = dtAssigned;
//listBoxAssignedConveyors.r
}