private void btnConfirm_Click(object sender, EventArgs e)
{
SqlStatements sql = new SqlStatements();
if (rdoStaff1.Checked == true)
{
this.ReturnStaffId = sql.GetStaffIDFromName(lblStaff1.Text.ToString());
}
else if (rdoStaff2.Checked == true)
{
this.ReturnStaffId = sql.GetStaffIDFromName(lblStaff2.Text.ToString());
}
else
{
this.ReturnStaffId = sql.GetStaffIDFromName(lblStaff3.Text.ToString());
}
this.DialogResult = DialogResult.OK;
this.Close();
}
public Tuple <int, int, int> GetAllInDept(string op)
{
DataSet ds = new DataSet();
ds.ReadXml(@"\\designsvr1\apps\Design and Supply CSharp\ShopFloorApps\PaintShop\xml.xml");
DataTable xmlDt = ds.Tables["Table1"];
string expression;
string Staff1;
string Staff2;
string Staff3;
int staffId1;
int staffId2;
int staffId3;
expression = "Column4='" + op + "'";
DataRow[] results = xmlDt.Select(expression);
Staff1 = Convert.ToString(results[0]["Column1"]);
Staff2 = Convert.ToString(results[0]["Column2"]);
Staff3 = Convert.ToString(results[0]["Column3"]);
SqlStatements sql = new SqlStatements();
try
{
staffId1 = sql.GetStaffIDFromName(Staff1);
}
catch
{
staffId1 = 0;
}
try
{
staffId2 = sql.GetStaffIDFromName(Staff2);
}
catch
{
staffId2 = 0;
}
try
{
staffId3 = sql.GetStaffIDFromName(Staff3);
}
catch
{
staffId3 = 0;
}
var tuple = new Tuple <int, int, int>(staffId1, staffId2, staffId3);
return(tuple);
}
