public static String userload(string timeid, string subject)
{
DataSet ds;
//WindowsPrincipal wp = new WindowsPrincipal(WindowsIdentity.GetCurrent());
//string fulluser = wp.Identity.Name;
//int idx = fulluser.IndexOf("\\");
string alias = "dnot";
if (timeid != null)
{
if (subject != null && subject.ToLower().IndexOf("x1annotation") >= 0)
{
ds = DBTalk.GetSIDataSet("co2infsrvidb803", "XONE", true, "p_annotation_load", DBTalk.FormulateSqlParameter(new string[2] {
timeid, subject
}));
}
else
{
ds = DBTalk.GetSIDataSet("CO2INFAUDTDB801", "portal", true, "p_annotation_load", DBTalk.FormulateSqlParameter(new string[2] {
timeid, subject
}));
}
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dr = ds.Tables[0].Rows[0];
//txtAnnotation.Text
var annotation = dr[0].ToString();
var subjectline = dr[2].ToString();
//txtEnter.Text
alias = dr[1].ToString();
return(annotation + ":$:" + alias + ":$:" + subjectline);
}
}
return(":$:" + alias + ":$:");
}
public static string userdelete(string timeid, string annotation, string enterby, string subject)
{
try
{
if (subject != null && subject.ToLower().IndexOf("x1annotation") >= 0)
{
DBTalk.UpdateData("co2infsrvidb803", "XONE", true, "p_annotation_delete", DBTalk.FormulateSqlParameter(new string[4] {
timeid, annotation, enterby, subject
}));
}
else
{
DBTalk.UpdateData("CO2INFAUDTDB801", "portal", true, "p_annotation_delete", DBTalk.FormulateSqlParameter(new string[4] {
timeid, annotation, enterby, subject
}));
}
}
catch
{
// do nothing
}
return("ok");
}