/// <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)); } } }