示例#1
0
        public static void updatestatus(string MCID, string Description)
        {
            string str  = string.Empty;
            string _msg = string.Empty;

            str = "update tblmc set bMissionApproved='R',vRejectionDescription='" + Description + "' where iMissionClearanceId=" + MCID + "";


            SqlConnection cn  = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
            SqlCommand    cmd = new System.Data.SqlClient.SqlCommand(str, cn); cn.Close(); cn.Open();

            cmd.ExecuteNonQuery();

            MCPdfPreviewWB pv    = new MCPdfPreviewWB();
            string         s     = pv.SaveOnDocLog("Rejected", MCID);
            string         refno = "";
            string         s1    = pv.Message("Rejected", MCID, Description, out refno);

            pv.SaveComment("Rejected", s, s1, refno);

            HttpContext.Current.Session["userMsg"] = "Mission rejection notice number : " + MCID + "  has been successfully sent.";
        }
示例#2
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);


            MCPdfPreviewWB pv = new MCPdfPreviewWB();

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