public void CloseOverall(int _requestid, int _environment) { Users oUser = new Users(user, dsn); Projects oProject = new Projects(user, dsn); Functions oFunction = new Functions(user, dsn, _environment); RequestItems oRequestItem = new RequestItems(user, dsn); ResourceRequest oResourceRequest = new ResourceRequest(user, dsn); string strEmail = ""; string strCC = ""; bool boolClose = true; DataSet ds = oResourceRequest.GetRequestUnApprovedAll(_requestid); foreach (DataRow dr in ds.Tables[0].Rows) { if (Int32.Parse(dr["status"].ToString()) < 3) { boolClose = false; break; } } if (boolClose == true) { int intRequestUser = GetUser(_requestid); if (intRequestUser > 0) { strEmail = oUser.GetName(intRequestUser); } int intProject = GetProjectNumber(_requestid); if (intProject > 0) { int intProjectUser = Int32.Parse(oProject.Get(intProject, "userid")); if (intProjectUser > 0) { strCC = oUser.GetName(intProjectUser); } } } }