void SendRem(string _period, string _days, string project, string package, string rem, int _srv)
{
string Body = "Ref. " + project + " - " + package + "\n\n" + "This is an automatically generated email to remind you that the O & M noted above has been available for the last " + _period + " days. There is now only " + _days + " days left within the review period." + "\n\n" + "Could you please find time to review the manual and make any comments using the comment screen within the next " + _days + " days." + "\n\n" + "If you have reviewed and have no comments on the manual, please confirm with 'No comments' on exit from the website." + "\n\n" + "Thank you in anticipation of co-operation." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmldubai.com";
string _sub = "Ref. " + project + " - " + package + " " + rem;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = (string)Session["project"];
publicCls.publicCls _obj = new publicCls.publicCls();
DataTable _user = _objbll.load_User(_objcls, _objdb);
var list = from o in _user.AsEnumerable()
where o.Field <string>(2) == "Review/Comment" || o.Field <string>(2) == "Review/Comment/Status"
select o;
foreach (var row in list)
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + row[0].ToString() + "');", true);
_objcls.uid = row[0].ToString();
DataTable _usersrv = _objbll.load_usersrv(_objcls, _objdb);
var serv = from o in _usersrv.AsEnumerable()
where o.Field <int>(0) == _srv
select o;
foreach (var row1 in serv)
{
_obj.Send_Email(row[0].ToString(), _sub, Body);
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + row[0].ToString() + "');", true);
}
//_obj.Send_Email("*****@*****.**", _sub, Body);
}
_obj.Send_Email("*****@*****.**", _sub, Body);
}
void Send_Mail()
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
Body = "Ref. " + (string)Session["projectname"] + "/" + drservice.SelectedItem.Text + "/" + txt_drno.Text + "/" + txt_subject.Text + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to you." + "\n\n" + "Could you please find time to review the documents and make comments within the next 15 days" + "\n\n" + "If you review and have no comments on the document, please confirm with 'No comments' in the Response Column." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmltechniques.com";
string _sub = "Document Review - Ref. " + (string)Session["projectname"] + "/" + drservice.SelectedItem.Text + "/" + txt_drno.Text + "/" + txt_subject.Text;
if (IsValidEmailAddress(txt_issuedto.Text))
{
_objcls.Send_Email(txt_issuedto.Text, _sub, Body);
}
Body = "Ref. " + (string)Session["projectname"] + "/" + drservice.SelectedItem.Text + "/" + txt_drno.Text + "/" + "/" + txt_subject.Text + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to " + txt_review.Text + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmltechniques.com";
foreach (ListItem _lst in chkprjusers.Items)
{
if (_lst.Selected == true)
{
string _email = _lst.Text;
_objcls.Send_Email(_email, _sub, Body);
}
}
}
void Send_Mail()
{
if (lblprjcode.Text == "OPH" || lblprjcode.Text == "PCD")
{
return;
}
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clsuser _objcls1 = new _clsuser();
_objcls1.project_code = lblprjcode.Text;
string _prj = _objbll.Get_ProjectName(_objcls1, _objdb);
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
Body = "Ref. " + _prj + "/" + lbpkg.Text + "/" + lbldrno.Text + "\n\n" + "This is an automatically generated email to inform you that " + lbissued.Text + " responded the above document" + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Document Review Response - Ref. " + _prj + "/" + lbpkg.Text + "/" + lbldrno.Text;
_objcls.Send_Email(lbluid.Text, _sub, Body);
//_objcls.Send_Email("*****@*****.**", _sub, Body);
}
private void Send_Notification()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objusr = new _clsuser();
_objusr.project_code = (string)Session["project"];
string project = _objbll.Get_ProjectName(_objusr, _objdb);
publicCls.publicCls _obj = new publicCls.publicCls();
_clsdocument _objcls1 = new _clsdocument();
_objcls1.project_code = (string)Session["project"];
_objcls1.schid = Convert.ToInt32(lblsrv.Text);
DataTable _dt = _objbll.load_dms_user_email(_objcls1, _objdb);
string Body = "To: CML Techniques Project Managers," + "\n\n" + "Ref. " + project + "/" + drpackage.SelectedItem.Text + "/" + fname.Text + "\n\n" + "This is a notification to inform you that " + (string)Session["uid"] + " has responded to comments previously made on the above O and M Manual." + "\n" + "\n\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Ref. " + project + " / " + drpackage.SelectedItem.Text + "/" + fname.Text;
var list = from o in _dt.AsEnumerable()
where o.Field <string>(1) == "Review/Comment" || o.Field <string>(1) == "Review/Comment/Status"
select o;
foreach (var row in list)
{
_obj.Send_Email(row[0].ToString(), _sub, Body);
}
}
void Send_Admin(string project)
{
//publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "To: CML Techniques Project Managers," + "\n\n" + "Ref. " + (string)Session["projectname"] + " - " + ((string)Session["cfile"]).Substring(0, ((string)Session["cfile"]).Length - 3) + "\n\n" + "A comment(s) has been made on the above manual by " + (string)Session["uid"] + "\n" + "Please consider the comment(s) and revise the O & M appropriate." + "\n\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Ref. " + project + " - " + ((string)Session["cfile"]).Substring(0, ((string)Session["cfile"]).Length - 3);
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objusr = new _clsuser();
_objusr.project_code = (string)Session["project"];
publicCls.publicCls _obj = new publicCls.publicCls();
_clsdocument _objcls1 = new _clsdocument();
_objcls1.project_code = (string)Session["project"];
_objcls1.schid = Convert.ToInt32(lblsrv.Text);
DataTable _dt = _objbll.load_dms_user_email(_objcls1, _objdb);
var list = from o in _dt.AsEnumerable()
where o.Field <string>(1) == "Review/Comment" || o.Field <string>(1) == "Review/Comment/Status"
select o;
foreach (var row in list)
{
_obj.Send_Email(row[0].ToString(), _sub, Body);
}
// _obj.Send_Email("*****@*****.**", _sub, Body);
}
protected void Send_Password_toUser()
{
//string _Message="Dear Sir," + "\n" + "Your user account for CML Interactive has been created." +"\n\n" + "LOGIN INFORMATION:" + "\n" + "User Name :" + userid.Text + "\n" + "Password :"******"Autopassword"];
string _Message = "";
//if (chkmodule1.Items[0].Selected == true && chkmodule1.Items[1].Selected == false)
//{
// _Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "https://cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
//}
//else if (chkmodule1.Items[0].Selected == false && chkmodule1.Items[1].Selected == true)
//{
_Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "https://dms.cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
//}
//else
//{
// _Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "CMS Access : https://dms.cmltechniques.com, DMS Access : https://dms.cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
//}
if ((chkmodule.Items[0].Selected == true) && (chkmodule.Items[1].Selected == true))
{
_Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "CMS Access : https://cmltechniques.com, DMS Access : https://dms.cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
}
else if (chkmodule.Items[1].Selected == true)
{
_Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "https://dms.cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
}
else
{
_Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + txtuid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "https://cmltechniques.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
}
publicCls.publicCls _objcls = new publicCls.publicCls();
_objcls.Send_Email(txtuid.Text, "CML Techniques User Access..", _Message);
}
protected void Send_Email()
{
BLL_Dml _oblbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = lblprj.Text;
string ProjectName = _oblbll.Get_ProjectName(_objcls, _objdb);
DataTable _dtable;
string Body = "";
string _Link = "";
string _lnk = "";
publicCls.publicCls _obj = new publicCls.publicCls();
string _sub = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + txtdoc_name.Text;
Body = "Ref. " + ProjectName + " > " + (string)Session["F_na_cms"] + " > " + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
_objcls.mode = 3;
_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
var _result = from o in _dtable.AsEnumerable()
select o;
foreach (var _uid in _result)
{
_obj.Send_Email(_uid[0].ToString(), _sub, Body);
}
}
void Send_ReMail()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsuser _objcls = new _clsuser();
_objdb.DBName = "DBCML";
_objcls.project_code = lblprjcode.Text;
string ProjectName = _objbll.Get_ProjectName(_objcls, _objdb);
_objdb.DBName = "DB_" + lblprjcode.Text;
_clscmsdocument _objcls1 = new _clscmsdocument();
_objcls1.doc_name = "Document Review";
int _period = _objbll.Get_ReviewPeriod(_objcls1, _objdb);
publicCls.publicCls _obj = new publicCls.publicCls();
string _Link = "https://cmltechniques.com/Default.aspx?Id=1P_" + lblprjcode.Text + "M_DR";
string Body = "";
Body = "Ref. " + ProjectName + "/" + lbpkg.Text + "/" + lbldrno.Text + "/" + lbdoc.Text + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to you." + "\n\n" + "Could you please find time to review the documents and make comments within the next " + _period + " days" + "\n\n" + "If you review and have no comments on the document, please confirm with 'No comments' in the Response Column." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Document Review Page,upon login to CML Techniques." + "\n\n" + "Document Link :" + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmldubai.com";
string _sub = "Document Review - Ref. " + ProjectName + "/" + lbpkg.Text + "/" + lbldrno.Text + "/" + lbdoc.Text;
_obj.Send_Email(drissuedto.SelectedItem.Text, _sub, Body);
//_objcls.Send_Email("*****@*****.**", _sub, Body);
}
void Send_Acknow(string project)
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "This is an automatically generated email to confirm CML Techniques are in receipt of your comments made for the above manual." + "\n\n" + "The comments will receive attention and the manual will be revised as required." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Ref. " + project + " - " + ((string)Session["cfile"]).Substring(0, ((string)Session["cfile"]).Length - 3);
_objcls.Send_Email((string)Session["uid"], _sub, Body);
}
void Send_Mail(string _pwd)
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "Your Password is :" + _pwd + "\n\n\n" + "http://www.cmlinternational.net/aspnet/default.aspx";
string _sub = "Password Recovery";
_objcls.Send_Email(_uid.Text, _sub, Body);
}
void Send_Mail(string _pwd)
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "CML Techniques Access :" + "\n\n\n" + "Your User Id is : " + _uid.Text + "\n" + "Your Password is : " + _pwd + "\n\n\n" + "https://cmltechniques.com";
string _sub = "CML Techniques Access";
_objcls.Send_Email(_uid.Text, _sub, Body);
}
void Send_Password_toUser()
{
//string _Message="Dear Sir," + "\n" + "Your user account for CML Interactive has been created." +"\n\n" + "LOGIN INFORMATION:" + "\n" + "User Name :" + userid.Text + "\n" + "Password :"******"Autopassword"];
string _Message = "This email has been sent to you from CML Techniques" + "\n\n" + "It is an automatic message that is generated directly from our CML interactive online documentation system." + "\n\n" + "You now have access to the " + "" + " online documents." + "\n\n\n" + "User Name : " + userid.Text + "\n" + "Password : "******"Autopassword"] + "\n\n\n" + "Please follow the link below to login : "******"\n" + "http://www.cmldubai.com" + "\n\n\n" + "if you encounter any problems then email our system administrator at [email protected]" + "\n\n" + "Kind regards," + "\n" + "CML Techniques";
publicCls.publicCls _objcls = new publicCls.publicCls();
_objcls.Send_Email(userid.Text, "CML Techniques User Access..", _Message);
}
protected void Send_Email()
{
BLL_Dml _oblbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = lblprjid.Text;
DataTable _dtable;
//string Body = "Ref. " + (string)Session["projectname"] + "/" + lbstatus.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " noted above has been uploaded to CML web site and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the comment screen." + "\n\n" + "If you review and have no comments on the manual, please confirm with 'No comments' on exit from the website." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmldubai.com";
string Body = "Ref. " + (string)Session["projectname"] + " - " + lblhead.Text + "/" + lbstatus.Text + "\n\n" + "A comment(s) has been made on the above " + lblhead.Text + " by " + (string)Session["uid"] + "\n\n" + "Please consider the comment(s) and revise the " + lblhead.Text + " appropriate." + "\n\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Ref. " + (string)Session["projectname"] + "/" + lblhead.Text + "/" + lbstatus.Text;
publicCls.publicCls _obj = new publicCls.publicCls();
if (lblvmode.Text == "MS")
{
//_dtable = _oblbll.Load_CMSUsers(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
//_clsproject _objprj = new _clsproject();
//for (int i = 0; i <= chk_company.Items.Count - 1; i++)
//{
// if (chk_company.Items[i].Selected == true)
// {
// _objprj.com_id = Convert.ToInt32(chk_company.Items[i].Value);
// DataTable _dt = _oblbll.Load_UsersCompany(_objprj, _objdb);
// var _result = from o in _dt.AsEnumerable()
// select o;
// foreach (var _uid in _result)
// {
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
// }
// }
//}
}
else if (lblvmode.Text == "CP")
{
_objcls.mode = 2;
_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
var _result = from o in _dtable.AsEnumerable()
select o;
foreach (var _uid in _result)
{
//_sub = _uid[0].ToString();
//_obj.Send_Email("*****@*****.**", _sub, Body);
_obj.Send_Email(_uid[0].ToString(), _sub, Body);
}
}
//_obj.Send_Email("*****@*****.**", _sub, Body);
}
void Send_Mail()
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
Body = "Ref. " + (string)Session["projectname"] + "/" + drpackage.SelectedItem.Text + "/" + (string)Session["sono"] + "/" + txtdoc.Text + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to you." + "\n\n" + "Could you please find time to review the documents and make comments within the next 15 days" + "\n\n" + "If you review and have no comments on the document, please confirm with 'No comments' in the Response Column." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Site Observation - Ref. " + (string)Session["projectname"] + "/" + drpackage.SelectedItem.Text + "/" + (string)Session["sono"] + "/" + txtdoc.Text;
_objcls.Send_Email(drissued.SelectedItem.Text, _sub, Body);
//_objcls.Send_Email("*****@*****.**", _sub, Body);
Body = "Ref. " + (string)Session["projectname"] + "/" + drpackage.SelectedItem.Text + "/" + (string)Session["sono"] + "/" + txtdoc.Text + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to " + drissued.SelectedItem.Text + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
for (int i = 0; i <= chkuser.Items.Count - 1; i++)
{
if (chkuser.Items[i].Selected == true)
{
_objcls.Send_Email(chkuser.Items[i].Text, _sub, Body);
}
}
// _objcls.Send_Email("*****@*****.**", _sub, Body);
}
void Send_Mail()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscmsdocument _objcls1 = new _clscmsdocument();
_objcls1.doc_name = "Site Observation";
int _period = _objbll.Get_ReviewPeriod(_objcls1, _objdb);
publicCls.publicCls _objcls = new publicCls.publicCls();
string _Link = "https://cmltechniques.com/Default.aspx?Id=1P_" + lblprj.Text + "M_SO";
string Body = "";
Body = "Ref. " + (string)Session["projectname"] + "/" + (string)Session["service"] + "/" + (string)Session["sono"] + "/" + (string)Session["doc"] + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to you." + "\n\n" + "Could you please find time to review the documents and make comments within the next " + _period + " days" + "\n\n" + "If you review and have no comments on the document, please confirm with 'No comments' in the Response Column." + "\n\n\n" + "Document Link :" + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Site Observation - Ref. " + (string)Session["projectname"] + "/" + (string)Session["service"] + "/" + (string)Session["sono"] + "/" + (string)Session["doc"];
_clsuser _clsusr = new _clsuser();
_objdb.DBName = "DBCML";
_clsusr.uid = (string)Session["issued"];
_clsusr.project_code = lblprj.Text;
if (_objbll.GetEmailNotify(_clsusr, _objdb) == true)
{
_objcls.Send_Email((string)Session["issued"], _sub, Body);
}
// _objcls.Send_Email("*****@*****.**", _sub, Body);
Body = "Ref. " + (string)Session["projectname"] + "/" + (string)Session["service"] + "/" + (string)Session["sono"] + "/" + (string)Session["doc"] + "\n\n" + "This is an automatically generated email to advise you that the above document has been issued to " + (string)Session["issued"] + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "Document Link :" + _Link + "\n\n\n" + "https://cmltechniques.com";
for (int i = 0; i <= chkuser.Items.Count - 1; i++)
{
if (chkuser.Items[i].Selected == true)
{
_objcls.Send_Email(chkuser.Items[i].Text, _sub, Body);
}
}
// _objcls.Send_Email("*****@*****.**", _sub, Body);
}
void SendCon(string _days, string project, string package, int _id, int _srv)
{
string Body = "Ref. " + project + " - " + package + "\n\n" + "This is an automatically generated email to confirm that the review period for the above O & M has now lapsed." + "\n\n" + "The O & M remains available to view but the comments window is not available." + "\n\n" + "If you have not reviewed and left any comments, CML will contact you to discuss options that may be available for an extension period to complete the review process." + "\n\n" + "Thank you for your attention and understanding." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmldubai.com";
string _sub = "Ref. " + project + " - " + package;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = (string)Session["project"];
publicCls.publicCls _obj = new publicCls.publicCls();
DataTable _user = _objbll.load_User(_objcls, _objdb);
var list = from o in _user.AsEnumerable()
where o.Field <string>(2) == "Review/Comment" || o.Field <string>(2) == "Review/Comment/Status"
select o;
foreach (var row in list)
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + row[0].ToString() + "');", true);
_objcls.uid = row[0].ToString();
DataTable _usersrv = _objbll.load_usersrv(_objcls, _objdb);
var serv = from o in _usersrv.AsEnumerable()
where o.Field <int>(0) == _srv
select o;
foreach (var row1 in serv)
{
_obj.Send_Email(row[0].ToString(), _sub, Body);
}
//_obj.Send_Email("*****@*****.**", _sub, Body);
}
_clsdocument _objdoc = new _clsdocument();
_objdoc.doc_id = _id;
_objdoc.status = "REVISED";
_objbll.SetDocStatus(_objdoc, _objdb);
_obj.Send_Email("*****@*****.**", _sub, Body);
}
void Send_Mail_Revised(string user_id, string access, string project)
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
if (access == "Review/Comment")
{
Body = "Ref. " + project + " - " + (string)Session["parent"] + "\n\n" + "This is an automatically generated email to advise you that the O & M noted above has been revised and is now available for further review." + "\n\n" + "Could you please find time to review changes made and make further comment(s) if required." + "\n\n" + "If no further comment(s) are required, please confirm with 'No comments' on exit from the website." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
}
else if (access == "Review/Comment/Status")
{
Body = "Ref. " + project + " - " + (string)Session["parent"] + "\n\n" + "This is an automatically generated email to advise you that the O & M noted above has been uploaded to CML web site and is available for review." + "\n\n" + "Could you please find time to review changes and if acceptable change the status of the manual on exit from the website." + "\n\n" + "Thank you in anticipation of co-operation." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
}
string _sub = "Ref. " + project + " - " + (string)Session["parent"];
_objcls.Send_Email(user_id, _sub, Body);
}
void Send_Mail(string user_id, string access, string project)
{
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
if (access == "Review/Comment")
{
Body = "Ref. " + project + " - " + (string)Session["parent"] + "\n\n" + "This is an automatically generated email to advise you that the O & M noted above has been uploaded to CML web site and is available for review." + "\n\n" + "Could you please find time to review the manual and make any comments using the comment screen within the next " + time.Text + " days." + "\n\n" + "If you review and have no comments on the manual, please confirm with 'No comments' on exit from the website." + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
}
else if (access == "Review/Comment/Status")
{
Body = "Ref. " + project + " - " + (string)Session["parent"] + "\n\n" + "This is an automatically generated email to advise you that the O & M noted above has been uploaded to CML web site and is available for review." + "\n\n" + "Could you please find time to review the manual and make any comments using the comment screen within the next " + time.Text + " days." + "\n\n" + "If you review and have no comments on the manual, please confirm with 'No comments' on exit from the website." + "\n\n" + "Thank you in anticipation of co-operation." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
}
string _sub = "Ref. " + project + " - " + (string)Session["parent"];
_objcls.Send_Email(user_id, _sub, Body);
}
protected void Send_Email()
{
BLL_Dml _oblbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = lblpr.Text;
string ProjectName = _oblbll.Get_ProjectName(_objcls, _objdb);
DataTable _dtable;
string Body = "";
string _Link = "";
string _lnk = "";
publicCls.publicCls _obj = new publicCls.publicCls();
string _sub = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text;
if ((string)Session["mod_name"] == "Minutes")
{
_lnk = lblpr.Text + "M_" + (string)Session["mod_name"] + "F_" + (string)Session["F_na_cms"] + "FI_" + (string)Session["Fold_cms"];
_lnk = _lnk.Replace(" ", "%");
_Link = "https://cmltechniques.com/UserLogin.aspx?Id=1P_" + _lnk;
Body = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Minutes Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 4;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
}
else if ((string)Session["mod_name"] == "Training")
{
_lnk = lblpr.Text + "M_" + (string)Session["mod_name"] + "F_" + (string)Session["F_na_cms"] + "FI_" + (string)Session["Fold_cms"];
_lnk = _lnk.Replace(" ", "%");
_Link = "https://cmltechniques.com/UserLogin.aspx?Id=1P_" + _lnk;
Body = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Training Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 8;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
}
else if ((string)Session["mod_name"] == "Commissioning Plan")
{
_Link = "https://cmltechniques.com/UserLogin.aspx?Id=1P_" + lblpr.Text + "M_CP";
Body = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Commissiong Plan Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 2;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
}
else if ((string)Session["mod_name"] == "Commissioning Reports")
{
_Link = "https://cmltechniques.com/UserLogin.aspx?Id=1P_" + lblpr.Text + "M_CR";
Body = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Commissiong Plan Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 2;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
}
else if ((string)Session["mod_name"] == "Method Statement")
{
//_lnk = lblmspath.Text;
//_lnk = _lnk.Replace(" ", "%");
//_lnk = _lnk.Replace(">", "_A");
//_Link = "http://www.cmltechniques.com/UserLogin.aspx?Id=1P_" + _lnk + "M_1";
//Body = "Ref. " + ProjectName + " > " + (string)Session["F_na_cms"] + " > " + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Method Statements Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "http://www.cmltechniques.com";
Body = "Ref. " + ProjectName + " > " + (string)Session["F_na_cms"] + " > " + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 3;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
// _obj.Send_Email("*****@*****.**", _sub, Body);
//_clsproject _objprj = new _clsproject();
//for (int i = 0; i <= chk_company.Items.Count - 1; i++)
//{
// if (chk_company.Items[i].Selected == true)
// {
// _objprj.com_id = Convert.ToInt32(chk_company.Items[i].Value);
// DataTable _dt = _oblbll.Load_UsersCompany(_objprj, _objdb);
// var _result = from o in _dt.AsEnumerable()
// select o;
// foreach (var _uid in _result)
// {
// //_sub = _uid[0].ToString();
// //_obj.Send_Email("*****@*****.**", _sub, Body);
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
// }
// }
//}
}
else if ((string)Session["mod_name"] == "Programmes")
{
_lnk = lblpr.Text + "M_" + (string)Session["mod_name"] + "F_" + (string)Session["F_na_cms"] + "FI_" + (string)Session["Fold_cms"];
_lnk = _lnk.Replace(" ", "%");
_Link = "https://cmltechniques.com/UserLogin.aspx?Id=1P_" + _lnk;
Body = "Ref. " + ProjectName + "/" + (string)Session["mod_name"] + "/" + (string)Session["F_na_cms"] + "/" + txtdoc_name.Text + "\n\n" + "This is an automatically generated email to advise you that the " + (string)Session["mod_name"] + " document noted above has been uploaded to CML Techniques " + ProjectName + " and is available for review." + "\n\n" + "Could you please find time to review the document and make any comments using the document review page of the " + (string)Session["mod_name"] + "." + "\n\n\n" + "Using the link below will direct to the " + ProjectName + " Programmes Page,upon login to CML Techniques." + "\n\n" + "Document Path : " + _Link + "\n\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
//_objcls.mode = 5;
//_dtable = _oblbll.Load_CMS_Users(_objcls, _objdb);
//var _result = from o in _dtable.AsEnumerable()
// select o;
//foreach (var _uid in _result)
//{
// _obj.Send_Email(_uid[0].ToString(), _sub, Body);
//}
}
foreach (ListItem _lst in chkprjusers.Items)
{
if (_lst.Selected == true)
{
string _email = _lst.Text;
_obj.Send_Email(_email, _sub, Body);
}
}
}