/// <summary>
/// WorkItem No : 2404 , R3_AGA_1.5.5.1
/// Returns the User whether assigned Jobs IsFirst or IsLastInstance
/// </summary>
/// <param name="UserId"></param>
public void SetJobInstance(string UserId,out bool IsJobFirstInstance,out bool IsJobLastInstance)
{
IsJobFirstInstance = IsJobLastInstance = false;
SqlDataReader drData = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "selJobFirstandLastInstance";
colParameters.Add(new SqlParameter("@WMSourceID", mintID.ToString()));
colParameters.Add(new SqlParameter("@UserID", UserId));
drData = objADO.GetDataReader(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
objADO = null;
if (drData != null)
{
if (drData.Read())
{
IsJobFirstInstance = Convert.ToBoolean(drData.GetValue(0));
IsJobLastInstance = Convert.ToBoolean(drData.GetValue(1));
}
}
}
