public static string RetDociD(string MCID)
{
clsClearficationMCProperties propObj = new clsClearficationMCProperties();
propObj.MCID = MCID;
clsClearficationMC Obj = new clsClearficationMC();
Obj.InsertComment(propObj);
string _iDocsendDetailsID = string.Empty;
SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
string sql = "select * from tblMC where iMissionClearanceId =" + MCID;
cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
string getID = string.Empty;
getID = ds1.Tables[0].Rows[0]["DocID"].ToString();
clsMC mc = new clsMC();
_iDocsendDetailsID = (mc.getDocIDforMessage(MCID)).ToString();
return(_iDocsendDetailsID);
}
public DataSet BindGrid()
{
clsMC MCOBJ = new clsMC();
return(MCOBJ.BindDraftDataMC(Convert.ToInt32((((UserDetails)Session[clsConstant.TOKEN])).AgencyID.ToString()),
(((UserDetails)Session[clsConstant.TOKEN]).EAP).ToString()));
}
public string SaveOnDocLog(string _Type, string MCID)
{
string _iDocsendDetailsID = string.Empty;
SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
string sql = "select * from tblMC where iMissionClearanceId =" + MCID;
cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
string getID = string.Empty;
getID = ds1.Tables[0].Rows[0]["DocID"].ToString();
clsMC mc = new clsMC();
_iDocsendDetailsID = (mc.getDocIDforMessage(MCID)).ToString();
return(_iDocsendDetailsID);
}
protected void BindDropDown()
{
clsMC mc = new clsMC();
objCommon = new CommonFunction();
ddlLoanNo.DataSource = objCommon.getDropDownList("sp_getMCLoan", null);
ddlLoanNo.DataValueField = "ValueFieldText";
ddlLoanNo.DataTextField = "DisplayFieldText";
ddlLoanNo.DataBind();
DataSet ds = new DataSet();
ds = mc.GetAgencyDetail();
ddlAgency.DataSource = ds;
ddlAgency.DataTextField = "Agency";
ddlAgency.DataValueField = "iAgencyId";
ddlAgency.DataBind();
ddlAgency.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", ""));
string sql = "select (vsFirstName +' ' + vsLastName) as name, iUserID from tblUserMaster where iUserID in(select distinct iToUser from tblMC)";
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new SqlDataAdapter(sql, cn);
DataTable dt = new DataTable();
ad.Fill(dt);
ddlSendNo.DataSource = dt;
ddlSendNo.DataTextField = "name";
ddlSendNo.DataValueField = "iUserID";
ddlSendNo.DataBind();
ddlSendNo.Items.Insert(0, new ListItem("Select", "0"));
}
public void BindOFFGrid()
{
clsMC MCObj = new clsMC();
StringBuilder sb = new StringBuilder();
DataSet ds = MCObj.LoadOffGrid(Convert.ToInt32(hdnedMCID.Value));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
string sql = "select vsAgencyCode +'-'+vsAgencyName as AgencyName from tblAgency where iAgencyID=" + ds.Tables[0].Rows[i][4].ToString();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new SqlDataAdapter(sql, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
sb.AppendLine("<tr >");
sb.AppendLine("<td>" + ds1.Tables[0].Rows[0][0].ToString() + "</td>"); //agency
sb.AppendLine("<td>" + ds.Tables[0].Rows[i][1] + " ");
sb.AppendLine(ds.Tables[0].Rows[i][2] + "</td>");
sb.AppendLine("<td>" + ds.Tables[0].Rows[i][3] + "</td>");
sb.AppendLine("</tr>");
}
catch
{
sb.AppendLine("<tr >");
sb.AppendLine("<td>" + ds.Tables[0].Rows[i][1] + " ");
sb.AppendLine(ds.Tables[0].Rows[i][2] + "</td>");
sb.AppendLine("<td>" + ds.Tables[0].Rows[i][3] + "</td>");
sb.AppendLine("<td></td></tr>");
}
}
pdfGridoffDiv.InnerHtml = sb.ToString();
}
public DataSet GetMCRequestFillData(string MCID)
{
DataSet ds = new DataSet();
clsMC mc = new clsMC();
ds = mc.GetMCRequestFillData(MCID);
return(ds);
}
public void FillEDProjectData(string PrjID)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(PrjID), "Project");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["vsProjectNumber"].ToString();
prj_name.Text = dt.Rows[0]["vsProjectName"].ToString();
lblLoanDetail.Text = dt.Rows[0]["vsProjectNumber"].ToString() + "-" + dt.Rows[0]["vsProjectName"].ToString();
}
public void FillEDLoanData(string LoanVal)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(LoanVal), "Loan");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["vsLoanNumber"].ToString();
prj_name.Text = dt.Rows[0]["vsLoanName"].ToString();
lblLoanDetail.Text = dt.Rows[0]["vsLoanNumber"].ToString() + "-" + dt.Rows[0]["vsLoanName"].ToString();
prjSize.Text = "USD " + dt.Rows[0]["cAmount"].ToString();
prjClosingDate.Text = Convert.ToDateTime(dt.Rows[0]["dtClosingDate"].ToString()).ToString("dd MMM yyyy");
}
public void BindMCMEmberGrid()
{
clsMC MCObj = new clsMC();
StringBuilder sb = new StringBuilder();
DataSet ds = MCObj.LoadMCGrid(Convert.ToInt32(hdnedMCID.Value));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.AppendLine("<tr>");
sb.AppendLine("<td style='width:350px;'>" + ds.Tables[0].Rows[i][1].ToString() + " " + ds.Tables[0].Rows[i][2].ToString() + "</td>");
sb.AppendLine("<td style='width:452px;'>" + ds.Tables[0].Rows[i][3].ToString() + "</td></tr>");
}
PDFMemName.InnerHtml = sb.ToString();
}
public void GetAideMeimareDataPipeline(string PipelineId)
{
clsMC mc = new clsMC();
CommonFunction comnFunctionObj = new CommonFunction();
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@status", "displaylastpipelinemc"),
new SqlParameter("@PipelineId", PipelineId)
};
DataSet ds = comnFunctionObj.getGridviewData(clsConstant.SP_ADD_DATE_ATTACHMENT_AIDEMEIMARE_WB, param);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
hdnPrevMCID.Value = dt.Rows[0]["iMissionClearanceId"].ToString();
}
}
public void FillEDTAData(string TAID)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(TAID), "TA");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["iTANumber"].ToString();
prj_name.Text = dt.Rows[0]["vsTAName"].ToString();
lblTaDetail.Text = prjno.Text + "-" + prj_name.Text;
decimal result;
decimal.TryParse(dt.Rows[0]["cTAAmount"].ToString(), out result);
prjSize.Text = "USD " + Math.Round(result, 2).ToString();
DateTime dt1;
DateTime.TryParse(dt.Rows[0]["dtEndDate"].ToString(), out dt1);
prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
objMC = new clsMC();
try
{
string strfileMain = Path.GetFileName(fileuploadMain.PostedFile.FileName.ToString());
HttpFileCollection hfc = Request.Files;
if (hfc.Count > 0 && fileuploadMain.HasFile) // Added by keshav on 10 March 2014 not to add the atachment compulsary
{
FileUpload(hfc);
}
try
{
// if (objMCWB.AddMCDatesAndAttachFilePopUp(hdnMCID.Value, txtDateFrom.Text, txtDateTo.Text, txtwrapDate.Text, txtDateAidMember.Text, strfileMain == "" ? "sampleimage.png" : strfileMain, "addpopuodata"))
if (objMC.AddMCDatesAndAttachFilePopUp(hdnMCID.Value, txtDateFrom.Text, txtDateTo.Text, txtwrapDate.Text, txtDateAidMember.Text, "addpopuodata"))
{
lblMsg.ForeColor = System.Drawing.Color.Green;
lblMsg.Text = "Inserted Successfully";
}
else
{
lblMsg.ForeColor = System.Drawing.Color.Red;
lblMsg.Text = "There is some problem, Please try later.";
}
}
catch (Exception ex)
{
logger.Error(ex);
lblMsg.Text = ex.ToString();
}
}
catch
{
Response.Write("<script>alert('No file selected')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("MCApprove") == false)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
lblDatePDF.Text = System.DateTime.Now.Date.ToString("dd MMMM yyyy");
hdnUserid.Value = (((UserDetails)Session[clsConstant.TOKEN]).UserID).ToString();
lblDesig.Text = (((UserDetails)Session[clsConstant.TOKEN]).Designation).ToString();
lblUserName.Text = (((UserDetails)Session[clsConstant.TOKEN]).FirstName).ToString() + " " + (((UserDetails)Session[clsConstant.TOKEN]).LastName).ToString();
hdnUsername.Value = (((UserDetails)Session[clsConstant.TOKEN]).FirstName).ToString() + " " + (((UserDetails)Session[clsConstant.TOKEN]).LastName).ToString();
if (!IsPostBack)
{
if (Request.QueryString["mcid"] != null)
{
PageRedirect(Request.QueryString["mcid"]);
hdnedMCID.Value = Request.QueryString["mcid"].ToString();
if ((((UserDetails)Session[clsConstant.TOKEN]).AgencyID).ToString() != "7")
{
btnaction.Items[0].Enabled = false;
btnaction.Items[1].Enabled = false;
btnaction.Items[2].Text = "Respond Clarification";
}
LoadPipelineData(hdnedMCID.Value);
DataSet ds = GetMCRequestFillData(hdnedMCID.Value);
clsMC McObj = new clsMC();
hdnToUser.Value = ds.Tables[0].Rows[0]["iToUser"].ToString();
DataSet name = McObj.GetUserDetails(ds.Tables[0].Rows[0]["iFromUser"].ToString());
string ImageName = ds.Tables[0].Rows[0]["iFromUser"].ToString();
string imageURL = Server.MapPath("~") + "writereaddata" + "\\" + ImageName + ".jpg";
if (File.Exists(imageURL))
{
}
else
{
}
lblMissionFor.Text = ds.Tables[0].Rows[0]["iMissionCleranceID"].ToString();
lblPDFUsername.Text = name.Tables[0].Rows[0][0].ToString();
lblPDFDesig.Text = name.Tables[0].Rows[0][1].ToString();
lblPdFAgency.Text = name.Tables[0].Rows[0][2].ToString();
lblFrom.Text = name.Tables[0].Rows[0][0].ToString() + "," + name.Tables[0].Rows[0][1].ToString() + "," + name.Tables[0].Rows[0][2].ToString();
name = McObj.GetUserDetails(ds.Tables[0].Rows[0]["iToUser"].ToString());
lblTo.Text = name.Tables[0].Rows[0][0].ToString() + "," + name.Tables[0].Rows[0][1].ToString() + "," + name.Tables[0].Rows[0][2].ToString();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["TypeofLoanTAProject"].ToString().ToUpper() == "Pipeline".ToUpper())
{
chk_Loan.Checked = true;
lblLoanDetail.Text = ds.Tables[0].Rows[0][2].ToString();
hdnMissionTypeID.Value = ds.Tables[0].Rows[0]["iPipelineID"].ToString();
FillEDLoanData(ds.Tables[0].Rows[0]["iPipelineID"].ToString());
GetAideMeimareDataPipeline(ds.Tables[0].Rows[0]["iPipelineID"].ToString());
AttachedMCGrid();
}
if (ds.Tables[0].Rows[0]["TypeofLoanTAProject"].ToString().ToUpper() == "Portfolio".ToUpper())
{
chk_ta.Checked = true;
BindAideMeimareDetailsForPortfolio(ds.Tables[0].Rows[0]["PortfolioID"].ToString());
FillEDProjectData(ds.Tables[0].Rows[0]["PortfolioID"].ToString());
hdnMissionTypeID.Value = ds.Tables[0].Rows[0]["PortfolioID"].ToString();
AttachedMCGrid();
}
if (ds.Tables[0].Rows[0]["TypeofLoanTAProject"].ToString().ToUpper() == "AAA".ToUpper())
{
chk_reta.Checked = true;
GetAideMeimareDataAAA(ds.Tables[0].Rows[0]["AAAID"].ToString());
hdnMissionTypeID.Value = ds.Tables[0].Rows[0]["AAAID"].ToString();
FillEDTAData(ds.Tables[0].Rows[0]["AAAID"].ToString());
AttachedMCGrid();
}
if (ds.Tables[0].Rows[0]["TypeofLoanTAProject"].ToString().ToUpper() == "SEMINAR".ToUpper())
{
chk_other.Checked = true;
lbl_SeminarDtls.Text = ds.Tables[0].Rows[0]["SeminarDescription"].ToString();
}
}
lbl_duration.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["dtMissionDurationFrom"].ToString()).ToString("dd MMM yyy") == "01 Jan 1900" ? "" : " From : " + Convert.ToDateTime(ds.Tables[0].Rows[0]["dtMissionDurationFrom"].ToString()).ToString("dd MMM yyy");
lbl_duration.Text += Convert.ToDateTime(ds.Tables[0].Rows[0]["dtMissionDurationTo"].ToString()).ToString("dd MMM yyy") == "01 Jan 1900" ? "" : " To : " + Convert.ToDateTime(ds.Tables[0].Rows[0]["dtMissionDurationTo"].ToString()).ToString("dd MMM yyy");
lbl_duration.Text += " At " + ds.Tables[0].Rows[0]["vsMissionLocation"].ToString();
lbl_Outcomes.Text = ds.Tables[0].Rows[0]["vsMissionPurpOutcome"].ToString();
lblPropsed.Text = ds.Tables[0].Rows[0]["bHasConvenience"].ToString() == "1"?"Yes":"No";
BindMCMEmberGrid();
BindOFFGrid();
DateTime result;
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtWrapupDateDEA1"].ToString()))
{
lbl_agencywrap.Text = ds.Tables[0].Rows[0]["dtWrapupDateDEA1"].ToString();
}
else
{
lbl_agencywrap.Text = string.Empty;
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtProposedWrapUpDateDEA"].ToString()))
{
DateTime.TryParse(ds.Tables[0].Rows[0]["dtProposedWrapUpDateDEA"].ToString(), out result);
lbl_propDate.Text = result.ToString("dd MMM yyyy") == "01 Jan 1900" ? "" : result.ToString("dd MMM yyyy");
lbl_propDate.Text += " " + ds.Tables[0].Rows[0]["vsProposedWrapUpTimeDEA"].ToString();
}
else
{
lbl_propDate.Text = string.Empty;
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtfmDates"].ToString()))
{
DateTime.TryParse(ds.Tables[0].Rows[0]["dtfmDates"].ToString(), out result);
string str = "From " + (result.ToString("dd MMM yyyy") == "01 Jan 1900" ? "" : result.ToString("dd MMM yyyy"));
if (str.Trim() != "From")
{
lastDate.Text = str;
}
}
else
{
lastDate.Text = string.Empty;
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtlmDates"].ToString()))
{
DateTime.TryParse(ds.Tables[0].Rows[0]["dtlmDates"].ToString(), out result);
string str = " To " + (result.ToString("dd MMM yyyy") == "01 Jan 1900" ? "" : result.ToString("dd MMM yyyy"));
if (str.Trim() != "To")
{
lastDate.Text += str;
}
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtlmWrapupDateDEA"].ToString()))
{
DateTime.TryParse(ds.Tables[0].Rows[0]["dtlmWrapupDateDEA"].ToString(), out result);
wrapDate.Text = result.ToString("dd MMM yyyy") == "01 Jan 1900" ? "" : result.ToString("dd MMM yyyy");
}
else
{
wrapDate.Text = string.Empty;
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["dtlmWrapupDateDEA"].ToString()))
{
DateTime.TryParse(ds.Tables[0].Rows[0]["dtlmDateAideMemoire"].ToString(), out result);
lblPrevAide.Text = result.ToString("dd MMM yyyy") == "01 Jan 1900" ? "" : result.ToString("dd MMM yyyy");
}
else
{
lblPrevAide.Text = string.Empty;
}
clsMC mcobj = new clsMC();
lbl_misType.Text = mcobj.GetMissionType(ds.Tables[0].Rows[0]["iMissionTypeID"].ToString());
if (Request.QueryString["PgType"] != null)
{
if (Request.QueryString["PgType"].ToString() == "EditPage")
{
}
}
LoadClearification(hdnedMCID.Value);
}
}
}
public static void AddDeaFileNo(string MCID, string FileNo)
{
clsMC MCOBJ = new clsMC();
MCOBJ.ADDFileNo(MCID, FileNo);
}
public static void delete(string MCID)
{
clsMC MCOBj = new clsMC();
MCOBj.DeleteMC(MCID);
}
protected void Page_Load(object sender, EventArgs e)
{
if (((((UserDetails)Session[clsConstant.TOKEN]).EAP).ToString() == "WB"))
{
imgADBLogo1.Src = "../Images/WB-Logo.png";
logoofgvt.Src = "../Images/LogoGovtOfIndia1.jpg";
}
else
{
imgADBLogo1.Src = "../Images/ADB-Logo.JPG";
logoofgvt.Src = "../Images/LogoGovtOfIndia1.jpg";
}
clsMC objclsmc = new clsMC();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
Visibles(false, false, false);
type = Request.QueryString["type"];
iDocSendID = Request.QueryString["id"];
UserID = Request.QueryString["UserID"];
iDocDetailsID = Request.QueryString["DocSendDetailsID"];
string sendType = Request.QueryString["sendType"];
iCommentID = Request.QueryString["cmnt"];
docId = iDocSendID;
lblDocDetailsID.Text = iDocDetailsID;
lblSenderID.Text = UserID;
ds = objclsmc.getMCID(Convert.ToInt32(docId));
if (ds.Tables.Count != 0)
{
dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
hdnMCID.Value = MCID = dt.Rows[0]["iMissionClearanceId"].ToString();
Session["MCID"] = hdnMCID.Value;
}
}
lblDates.Text = DateTime.Now.ToString("dd MMM yyyy");
if (!IsPostBack)
{
ViewState["PreviousPage"] = Request.UrlReferrer;
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("ViewDocumentsDetails") == false)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
else
{
if (type == null || iDocSendID == null)
{
Response.Redirect("DocumentReceived1.aspx", false);
}
else
{
if (type == "received")
{
imgBtnClose.Visible = false;
imgBtnReminder.Visible = false;
if (Request.QueryString["MCID"] != null)
{
btnReply.Visible = false;
}
else
{
btnReply.Visible = true;
}
this.bindGrdActhFile();
this.AttachedMCGrid();
if (sendType == "M")
{
this.reviewDoc(sendType, int.Parse(iDocDetailsID));
Session["Rmdr"] = iDocDetailsID + ";" + iCommentID + ";" + UserID;
}
else
{
this.reviewDoc();
if (sendType != "pageRecv")
{
Session["Rec"] = iDocSendID + ";" + UserID;
}
}
imgView.ToolTip = "Click here to go to Document Received List";
}
else if (type == "send")
{
imgBtnClose.Visible = true;
imgBtnReminder.Visible = true;
btnReply.Visible = false;
this.bindGrdActhFile();
AttachedMCGrid();
this.reviewDoc("R", int.Parse(iDocDetailsID));
if (iCommentID != "" && iCommentID != null)
{
Session["Rply"] = iDocDetailsID + ";" + iCommentID + ";" + UserID;
}
imgView.ToolTip = "Click here to go to Document Send List";
}
getUserDetails(iDocSendID);
getAllDetails(iDocSendID);
if (Request.QueryString["MCID"] != null)
{
BtnReplyAll_Click(null, null);
}
}
}
}
}
catch (Exception ex)
{
}
}