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