Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        private void LoadClearification(string MCID)
        {
            clsClearficationMC     OBj     = new clsClearficationMC();
            clsClearficationMCData DataOBJ = new clsClearficationMCData();

            DataOBJ = OBj.GetClearification(MCID);

            StringBuilder sb = new StringBuilder();

            for (int i = 0; i < DataOBJ.Records.Count; i++)
            {
                sb.AppendLine("<span class='commentContainer' id='" + DataOBJ.Records[i].CommentID + "'>");
                sb.AppendLine("<span class='name'>" + DataOBJ.Records[i].UserName + "</span>");
                sb.AppendLine("<span class='comment'>" + DataOBJ.Records[i].Description + "</span>");
            }
            comments.InnerHtml = sb.ToString();
        }
Esempio n. 3
0
        public static string InsertComment(string UserId, string Comment, string MCID)
        {
            clsClearficationMCProperties propObj = new clsClearficationMCProperties();

            propObj.UserID      = UserId;
            propObj.Description = Comment;
            propObj.MCID        = MCID;
            clsClearficationMC Obj = new clsClearficationMC();

            Obj.InsertComment(propObj);
            MCPdfPreview pv    = new MCPdfPreview();
            string       s     = pv.SaveOnDocLog("Clarification", MCID);
            string       refno = "";
            string       s1    = pv.Message("Clarification", MCID, Comment, out refno);

            pv.SaveComment("Clarification", s, s1, refno);
            return(string.Empty);
        }