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);
}
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();
MCPdfPreview pv = new MCPdfPreview();
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.";
}