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