public entEventWB setEntValues2(int iStudyID) //, int iUserId, string itype { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } entEventWB objEntDoc = new entEventWB(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iStudyID", iStudyID) }; //, new SqlParameter("@iUserID", iUserId) , new SqlParameter("@iType", itype) SqlDataReader dr1 = objConnection.ExecuteReaderQuery("sp_selectStudySendWB", CommandType.StoredProcedure, param); if (dr1.Read()) { objEntDoc.EventName1 = dr1.GetValue(0).ToString(); objEntDoc.EventName2 = dr1.GetValue(1).ToString(); objEntDoc.EventName3 = dr1.GetValue(2).ToString(); objEntDoc.EventName4 = dr1.GetValue(3).ToString(); objEntDoc.EventType = dr1.GetValue(4).ToString(); objEntDoc.Place = dr1.GetValue(5).ToString(); objEntDoc.Date = Convert.ToDateTime(dr1.GetValue(6).ToString()).ToString(clsConstant.DATE_FORMAT); objEntDoc.Justification1 = dr1.GetValue(7).ToString(); objEntDoc.Justification2 = dr1.GetValue(8).ToString(); objEntDoc.Expenditure = dr1.GetValue(9).ToString(); objEntDoc.LastYear = dr1.GetValue(10).ToString(); objEntDoc.LastPlace = dr1.GetValue(11).ToString(); objEntDoc.Participents = dr1.GetValue(12).ToString(); objEntDoc.Purpose = dr1.GetValue(13).ToString(); objEntDoc.LastExpenditure = dr1.GetValue(14).ToString(); objEntDoc.FileName = dr1.GetValue(15).ToString(); objEntDoc.SenderName = dr1.GetValue(16).ToString(); objEntDoc.SendBy = dr1.GetValue(17).ToString(); objEntDoc.SendByWB = dr1.GetValue(18).ToString(); objEntDoc.Status = dr1.GetValue(19).ToString(); objEntDoc.SendUserId = dr1.GetValue(20).ToString(); objEntDoc.CStatus = dr1.GetValue(21).ToString(); objEntDoc.wbuserid = dr1.GetValue(22).ToString(); objEntDoc.DEAComment = dr1.GetValue(23).ToString(); objEntDoc.WBComment = dr1.GetValue(24).ToString(); objEntDoc.WBCommentFile = dr1.GetValue(25).ToString(); objEntDoc.FromTTL = dr1.GetValue(26).ToString(); objEntDoc.vsSecondFile = dr1.GetValue(27).ToString(); objEntDoc.NominationType = dr1.GetValue(28).ToString(); objEntDoc.SubmissionDate = dr1.GetValue(29).ToString(); objEntDoc.TodateS = dr1.GetValue(30).ToString(); } dr1.Close(); return(objEntDoc); }
public entEventWB setEntValues(int iEventID) //, int iUserId, string itype { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } entEventWB objEntDoc = new entEventWB(); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iEventID", iEventID) }; //, new SqlParameter("@iUserID", iUserId) , new SqlParameter("@iType", itype) SqlDataReader dr1 = objConnection.ExecuteReaderQuery("sp_selectEventSendWB", CommandType.StoredProcedure, param); if (dr1.Read()) { objEntDoc.NominationClose = dr1.GetValue(17).ToString(); objEntDoc.EventName = dr1.GetValue(0).ToString(); objEntDoc.EventType = dr1.GetValue(1).ToString(); objEntDoc.FromDate = Convert.ToDateTime(dr1.GetValue(2).ToString()).ToString(clsConstant.DATE_FORMAT); objEntDoc.ToDate = Convert.ToDateTime(dr1.GetValue(3).ToString()).ToString(clsConstant.DATE_FORMAT); objEntDoc.Venue = dr1.GetValue(4).ToString(); objEntDoc.Sponsored = dr1.GetValue(5).ToString(); objEntDoc.Nomination = dr1.GetValue(6).ToString(); objEntDoc.Invite = dr1.GetValue(7).ToString(); objEntDoc.InternationalNational = dr1.GetValue(8).ToString(); objEntDoc.Sector = dr1.GetValue(9).ToString(); objEntDoc.FileName = dr1.GetValue(10).ToString(); objEntDoc.SecondFileName = dr1.GetValue(11).ToString(); //objEntDoc.LastDate = "Not Available" ; objEntDoc.LastDate = Convert.ToDateTime(dr1.GetValue(12).ToString()).ToString(clsConstant.DATE_FORMAT); objEntDoc.SenderName = dr1.GetValue(13).ToString(); objEntDoc.Status = dr1.GetValue(14).ToString(); objEntDoc.SendUserId = dr1.GetValue(15).ToString(); objEntDoc.DEAPermisionStatus = dr1.GetValue(16).ToString(); objEntDoc.FromUser = dr1.GetValue(18).ToString(); } dr1.Close(); return(objEntDoc); }
public void getAllDetails(string iNominationID) { entEventWB objEnt; SendRecEventWB objDoc = new SendRecEventWB(); int userid = ((UserDetails)Session[clsConstant.TOKEN]).UserID; string iType = ""; if (type == "received") { iType = "S"; } objEnt = objDoc.setEntValues3(int.Parse(iNominationID)); //, userid lblEventName.Text = objEnt.EventName; lblEventType.Text = objEnt.EventType; lblFromDate.Text = objEnt.FromDate; lblToDate.Text = objEnt.ToDate; lblVenue.Text = objEnt.Venue; lblSponsored.Text = objEnt.Sponsored; lblNomination.Text = objEnt.Nomination; lblInvite.Text = objEnt.Invite; lblNationalInternational.Text = objEnt.InternationalNational; lblSector.Text = objEnt.Sector; lblFile.Text = objEnt.FileName; lblFile2.Text = objEnt.SecondFileName; lblDueDate.Text = objEnt.LastDate; lblSendBy.Text = objEnt.SenderName; lblStatus.Text = objEnt.Status; lblType.Text = objEnt.VisitType.ToString() == "1"?"Incoming":"Outgoing"; lblWorkshopId.Text = ViewState["EventId"].ToString(); ViewState["vsTopic"] = objEnt.EventName; lblFromUser.Text = objEnt.FromUser; StringBuilder s = new StringBuilder(); CommonFunction objCommon = new CommonFunction(); DataSet dset = new DataSet(); int iUserID = ((UserDetails)Session[clsConstant.TOKEN]).UserID; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@SouthExchangeID", Request.QueryString["id"].ToString()) }; dset = objCommon.getEventData("Sp_SelectSouthExchangeVisitsDetails", param); #region ToList if (dset.Tables[2].Rows.Count > 0) { s.Append("<tr class='TrClass' style='background-color: #337ab7;color:black;'>"); s.Append("<th class='TdClass' style='font-size:18px'>Details </th>"); s.Append("</tr>"); for (int i = 0; i < dset.Tables[2].Rows.Count; i++) { s.Append("<tr class='TrClass'>"); s.Append("<td class='TdClass'>" + dset.Tables[2].Rows[i]["ToName"].ToString() + "</td>"); s.Append("</tr>"); } lblsendto.Text = s.ToString(); s = s.Clear(); } else { lblsendto.Text = "Currently To users are not available!"; lblsendto.ForeColor = System.Drawing.Color.Red; } #endregion #region ToCCList if (dset.Tables[3].Rows.Count > 0) { s.Append("<tr class='TrClass' style='background-color: #337ab7;color:black;'>"); s.Append("<th class='TdClass' style='font-size:18px'>Details </th>"); s.Append("</tr>"); for (int i = 0; i < dset.Tables[3].Rows.Count; i++) { s.Append("<tr class='TrClass'>"); s.Append("<td class='TdClass'>" + dset.Tables[3].Rows[i]["ToNameCC"].ToString() + "</td>"); s.Append("</tr>"); } lblccTo.Text = s.ToString(); s = s.Clear(); } else { lblccTo.Text = "Currently CC users are not available!"; lblccTo.ForeColor = System.Drawing.Color.Red; } #endregion if (lblStatus.Text == "Rejected" || lblStatus.Text == "Approved") { btnApprove.Visible = false; btnReject.Visible = false; btnReply.Visible = false; } else { btnApprove.Visible = true; btnReject.Visible = true; } ViewState["EventId"] = iNominationID; if (((UserDetails)Session[clsConstant.TOKEN]).UserID.ToString() == objEnt.SendUserId) { btnApprove.Visible = false; btnReject.Visible = false; btnReply.Visible = false; } if (Convert.ToDateTime(objEnt.LastDate) < DateTime.Now) { btnApprove.Visible = true; btnReject.Visible = true; } else { btnApprove.Visible = false; btnReject.Visible = false; } if (getUserDetailsChecks(iNominationID, "W") != userid.ToString()) { btnApprove.Visible = false; btnReject.Visible = false; } else if (objEnt.Status == "Approved" || objEnt.Status == "Rejected") { btnApprove.Visible = false; btnReject.Visible = false; } }