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