private void uploadFile()
{
HttpFileCollection hfc = Request.Files;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
FileInfo _info = new FileInfo(Server.MapPath("Schedule") + "\\" + System.IO.Path.GetFileName(hpf.FileName));
if (_info.Exists == true)
{
_info.Delete();
}
hpf.SaveAs(Server.MapPath("Schedule") + "\\" + System.IO.Path.GetFileName(hpf.FileName));
Session["xls"] = System.IO.Path.GetFileName(hpf.FileName);
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Documents Uploaded!');", true);
}
}
private void Get_DocInfo(string _id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32(_id);
DataTable _dtable = _objbll.Load_CMS_DocInfo(_objcls, _objdb);
var _info = from _data in _dtable.AsEnumerable()
select _data;
foreach (var row in _info)
{
lb_module.Text = row[0].ToString();
lb_docname.Text = row[1].ToString();
lb_update.Text = Convert.ToDateTime(row[3].ToString()).ToString("dd/MM/yyyy");
lb_upby.Text = row[4].ToString();
lb_ltversion.Text = row[6].ToString();
lb_status.Text = row[5].ToString();
}
if (lb_ltversion.Text.Length == 1)
{
lb_ltversion.Text = "0" + lb_ltversion.Text;
}
}
protected void btnsavechnages_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
for (int ins = 0; ins <= mygrid.Rows.Count - 1; ins += 1)
{
DropDownList checkbox = (DropDownList)mygrid.Rows[ins].FindControl("drclose");
if (checkbox == null)
{
continue;
}
_objcls.doc_id = Convert.ToInt32(mygrid.Rows[ins].Cells[8].Text);
if (checkbox.SelectedValue == "1")
{
_objcls.enabled = false;
}
else
{
_objcls.enabled = true;
}
_objbll.Update_CML_DocCmtStatus(_objcls, _objdb);
}
ScriptManager.RegisterStartupScript(this, typeof(string), "alert", "alert('Document successfully Updated');", true);
//ScriptManager.RegisterStartupScript(this, typeof(string), "alert", "window.close();", true);
}
void load_documents()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.folder_id = Convert.ToInt32((string)Session["fid"]);
int _folder_type = _objbll.Get_FolderType(_objcls, _objdb);
if (_folder_type == 10)
{
lbltype.Text = _folder_type.ToString();
int _type = _objbll.Get_FolderType_Type(_objcls, _objdb);
_objcls.folder_id = _type;
_objcls.project_code = (string)Session["project"];
mygrid.DataSource = _objbll.load_dms_doc_upload(_objcls, _objdb);
mygrid.DataBind();
}
else
{
_objcls.enabled = true;
mygrid.DataSource = _objbll.load_document(_objcls, _objdb);
mygrid.DataBind();
}
}
protected void drclose_SelectedIndexChanged(object sender, EventArgs e)
{
if (lblprj.Text == "12761")
{
return;
}
DropDownList checkbox = (DropDownList)sender;
GridViewRow row = (GridViewRow)checkbox.NamingContainer;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32(row.Cells[8].Text);
if (checkbox.SelectedValue == "1")
{
_objcls.enabled = false;
}
else
{
_objcls.enabled = true;
}
_objbll.Update_CML_DocCmtStatus(_objcls, _objdb);
}
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);
}
}
public void load_manualDetails()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsmanufacture _objcls = new _clsmanufacture();
_objcls.project_code = (string)Session["project"];
DataTable _Doctype = _objbll.load_doctype(_objdb);
DataTable _dtable1 = new DataTable();
_dtable1.Columns.Add("id");
_dtable1.Columns.Add("type");
var _List = from o in _Doctype.AsEnumerable()
where o.Field <int>(5) == Convert.ToInt32(drpackage.SelectedItem.Value)
select o;
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + (string)Session["project"] + "');", true);
foreach (var row in _List)
{
if (row[7].ToString() == "1")
{
Session["om"] = row[0].ToString();
}
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + (string)Session["docid"] + "');", true);
_clsdocument _objcls1 = new _clsdocument();
_objcls1.folder_id = Convert.ToInt32((string)Session["om"]);
//int _docid = _objbll.Get_ManualID(_objcls1);
Session["docid"] = _objbll.Get_ManualID(_objcls1, _objdb).ToString();
load_comments();
}
void Ms_summaryAll()
{
Session["srv"] = "ALL";
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocument _objcls = new _clsdocument();
_objdb.DBName = "DBCML";
_clsproject _objcls1 = new _clsproject();
_objcls1.prjcode = lblprj.Text;
_objbll.Update_RPTLogo(_objcls1, _objdb);
_objbll.Clear_MSSummary(_objdb);
_objdb.DBName = "DB_" + lblprj.Text;
DataTable _dtable = _objbll.Load_MSStatus(_objdb);
var _status = from _data in _dtable.AsEnumerable()
select _data;
foreach (var row in _status)
{
_objcls.status = row[0].ToString();
//_objcls.schid = Convert.ToInt32(rd_Building.SelectedItem.Value);
_objcls.schid = Convert.ToInt32(Request.QueryString["Div"].ToString());
_objbll.Generate_MS_Summary_ALL_Div(_objcls, _objdb);
}
_objcls.status = "1";
//_objcls.schid = Convert.ToInt32(rd_Building.SelectedItem.Value);
_objcls.schid = Convert.ToInt32(Request.QueryString["Div"].ToString());
_objbll.Generate_MS_Summary_ALL_Div(_objcls, _objdb);
}
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);
}
void summary()
{
Session["srv"] = "ALL";
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocument _objcls = new _clsdocument();
_objdb.DBName = "DBCML";
_clsproject _objcls1 = new _clsproject();
_objcls1.prjcode = lblprj.Text;
_objbll.Update_RPTLogo(_objcls1, _objdb);
_objbll.Clear_MSSummary(_objdb);
_objdb.DBName = "DB_" + lblprj.Text;
DataTable _dtable = _objbll.Load_MSStatus(_objdb);
var _status = from _data in _dtable.AsEnumerable()
select _data;
foreach (var row in _status)
{
_objcls.status = row[0].ToString();
_objcls.schid = Convert.ToInt32(rd_Building.SelectedItem.Value);
_objbll.Generate_MS_Summary_ALL_Div(_objcls, _objdb);
}
_objcls.status = "1";
_objcls.schid = Convert.ToInt32(rd_Building.SelectedItem.Value);
_objbll.Generate_MS_Summary_ALL_Div(_objcls, _objdb);
string _parm = "id=ms_" + GetDocNo_All() + "&idx=" + lblid.Text + "&Div=" + rd_Building.SelectedItem.Value.ToString();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "parent.callcms('" + _parm + "','19');", true);
}
private void Insert_to_DB()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.project_code = (string)Session["project"];
DataSet _dset = Read_File();
_objcls.service_code = Convert.ToInt32((string)Session["serv"]);
_objcls.doctype_code = Convert.ToInt32((string)Session["dtype"]);
_objcls.folder_id = Convert.ToInt32((string)Session["fid"]);
_objcls.package_code = Convert.ToInt32((string)Session["dtype"]);
_objcls.uploaded_date = DateTime.Now;
_objcls.uid = (string)Session["uid"];
int _idx = _objbll.get_schedule_possition(_objcls, _objdb) + 1;
foreach (DataRow row in _dset.Tables[0].Rows)
{
_objcls.doc_title = row[0].ToString();
_objcls.doc_name = row[1].ToString();
_objcls.possition = _idx;
_objbll.Create_Schedule(_objcls, _objdb);
_idx += 1;
}
ScriptManager.RegisterStartupScript(this, typeof(string), "", "alert('Schedule Uploaded!');", true);
}
void load_docdetails()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32((string)Session["docid"]);
DataTable _dtable = _objbll.Load_DocDatails(_objcls, _objdb);
var _result = from o in _dtable.AsEnumerable()
select o;
foreach (var row in _result)
{
contr.Text = row[5].ToString();
module.Text = row[7].ToString();
package.Text = row[8].ToString();
Label1.Text = package.Text;
fname.Text = row[0].ToString();
version.Text = row[3].ToString();
DateTime _date = Convert.ToDateTime(row[6].ToString());
date.Text = string.Format("{0:dd/MM/yyyy}", _date);
uploadby.Text = row[10].ToString();
status.Text = row[4].ToString();
}
}
private void Insert_ReportData()
{
//int folderId;
//folderId = Convert.ToInt16(ddlFolderlist.SelectedValue);
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocument _objcls = new _clsdocument();
_objdb.DBName = "DBCML";
_clsproject _objcls1 = new _clsproject();
_objcls1.prjcode = lblprj.Text;
_objbll.Update_RPTLogo(_objcls1, _objdb);
_objbll.Clear_DBMSSummary(_objdb);
DataTable _dtable = _objbll.Load_DBMSStatus(_objdb);
var _status = from _data in _dtable.AsEnumerable()
select _data;
foreach (var row in _status)
{
_objcls.folder_id = Convert.ToInt16(Session["folderId"]);
_objcls.project_code = lblprj.Text;
_objcls.status = row[0].ToString();
_objbll.Generate_DBMS_Summary_ALL(_objcls, _objdb);
}
_objcls.folder_id = Convert.ToInt16(Session["folderId"]);
_objcls.status = "1";
_objcls.project_code = lblprj.Text;
_objbll.Generate_DBMS_Summary_ALL(_objcls, _objdb);
// parm = "ms_" + GetDocNo_All();
}
void load_users()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = (string)Session["project"];
string project = _objbll.Get_ProjectName(_objcls, _objdb);
_clsdocument _objcls1 = new _clsdocument();
_objcls1.project_code = (string)Session["project"];
_objcls1.schid = Convert.ToInt32(lblfolder.Text);
DataTable _dt = _objbll.load_dms_user_email(_objcls1, _objdb);
var list = from o in _dt.AsEnumerable()
select o;
foreach (var row in list)
{
Send_Mail(row[0].ToString(), project);
}
//Send_Mail("*****@*****.**", project);
//Send_Mail("*****@*****.**", project);
}
private void Delete_Schedule()
{
BLL_Dml _objbll = new BLL_Dml();
_clsdocument _objcls = new _clsdocument();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_objcls.schid = Convert.ToInt32((string)Session["id"]);
_objbll.Delete_Schedule(_objcls, _objdb);
}
private void Change_DocStatus()
{
BLL_Dml _objbll = new BLL_Dml();
_clsdocument _objcls = new _clsdocument();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjid.Text;
_objcls.doc_id = Convert.ToInt32(lblid.Text);
_objcls.status = drstatus.SelectedItem.Text;
_objbll.Update_CMSDoc_Status(_objcls, _objdb);
}
private string Get_Status()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "db_" + lblprjid.Text;
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32(lblid.Text);
return(_objbll.Get_DocStatus(_objcls, _objdb));
}
private void Load_Master(string type)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.folder_id = Convert.ToInt32(type);
_objcls.project_code = lblprj.Text;
_dtmaster = _objbll.load_dms_doc_upload(_objcls, _objdb);
}
private void Load_User_AllModule()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocument _objcls = new _clsdocument();
_objcls.uid = ddlusers.SelectedItem.Value;
mygrid.DataSource = _objbll.Load_User_AllModule(_objcls, _objdb);
mygrid.DataBind();
}
private void Load_ScheduleList(int folder_id, string project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clsdocument _objcls = new _clsdocument();
_objcls.project_code = project;
_objcls.folder_id = folder_id;
mygriddr.DataSource = _objbll.Load_ScheduleList(_objcls, _objdb);
mygriddr.DataBind();
}
protected void Delete_doc(string Project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + Project;
_clsdocument _objcls = new _clsdocument();
//_clscmsdocument _objcls = new _clscmsdocument();
//_objcls.doc_id = Convert.ToInt32(lblitmid.Text);
//_objbll.Delete_CMS_Doc(_objcls, _objdb);
//Load_doc(lblprj.Text);
//lblitmid.Text = "0";
}
void load_documents()
{
if (mytree.SelectedNode.Depth < 2)
{
return;
}
BLL_Dml _objbll = new BLL_Dml();
_clsdocument _objcls = new _clsdocument();
_objcls.folder_id = Convert.ToInt32((string)Session["folder_id"]);
_objcls.enabled = true;
//mygrid.DataSource = _objbll.load_document(_objcls);
//mygrid.DataBind();
}
protected void Update_doc_status()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32((string)Session["docid"]);
_objcls.status = drstatus.SelectedItem.Text;
_objbll.Update_CMSDoc_Status(_objcls, _objdb);
Load_doc();
Load_doc_pre();
}
private void Gen_PrintReport()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
_objcls.doc_name = (string)Session["_mod"];
_objcls.doc_id = Convert.ToInt32((string)Session["_id"]);
_objcls.folder_id = Convert.ToInt32((string)Session["_type"]);
_objbll.GEN_CMSDOCCOMM_RPT(_objcls, _objdb);
_objbll.GEN_CMSDOCINFO_RPT(_objcls, _objdb);
}
protected void Delete_doc(string Project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + Project;
//_objdb.DBName = "db_123";
_clsdocument _objcls = new _clsdocument();
//_clscmsdocument _objcls = new _clscmsdocument();
//_objcls.doc_id = 111;
_objcls.doc_id = Convert.ToInt32((string)Session["docid"]);
_objbll.Delete_CMS_Doc(_objcls, _objdb);
Load_Documents();
}
void ChangeStatus()
{
if (drstatus.SelectedItem.Text == "-- Status --")
{
return;
}
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32((string)Session["id"]);
_objcls.status = drstatus.SelectedItem.Text;
_objbll.SetDocStatus(_objcls, _objdb);
}
void load_comments()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32((string)Session["docid"]);
mygrid.DataSource = _objbll.load_comments(_objcls, _objdb);
mygrid.DataBind();
//Label1.Text = (string)Session["pkg"];
load_docdetails();
//Label2.Text = (string)Session["Dname"];
//Label3.Text = (string)Session["ver"];
}
private void Multi_Upload(string _fname)
{
string _Doc_type = (string)Session["folder"];
var _List = from o in _dtable.AsEnumerable()
where o.Field <int>(5) == Convert.ToInt32(_Doc_type)
select o;
try
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
foreach (var row in _List)
{
if (_fname == row[3].ToString())
{
FileInfo _finfo = new FileInfo(Server.MapPath("Documents" + "\\" + _fname));
if (_finfo.Exists == true)
{
_objcls.doc_name = row[3].ToString();
_objcls.doc_title = row[2].ToString();
_objcls.doctype_code = 0;
_objcls.package_code = 0;
_objcls.uploaded_date = DateTime.Now;
_objcls.service_code = 0;
_objcls.uploaded = true;
_objcls.schid = Convert.ToInt32(row[0].ToString());
_objcls.folder_id = Convert.ToInt32(row[5].ToString());
string _size = _finfo.Length.ToString();
_objcls.file_size = decimal.Round((Convert.ToDecimal(_size) / 1024), 2).ToString() + "KB";
// _objcls.file_size = decimal.Round((Convert.ToDecimal(_size) / 1024), 2).ToString() + "KB";
_objcls.uid = (string)Session["uid"];
_objcls.type = "";
_objbll.file_upload(_objcls, _objdb);
load_schedule();
Get_Schedule();
return;
}
}
}
}
catch (Exception ex)
{
//Label1.Text = ex.ToString();
}
}
void Move_Document(string _move)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = Convert.ToInt32((string)Session["doc_id"]);
_objcls.folder_id = Convert.ToInt32((string)Session["folder_id"]);
_objcls.possition = Convert.ToInt32((string)Session["possition"]);
_objcls.move = _move;
_objbll.Move_document(_objcls, _objdb);
load_documents();
//set_select(_move);
//_objbll.load_document(_objcls);
}
private void Load_Details(int id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
_objcls.doc_id = id;
DataTable _dt = _objbll.Load_Comment_Details(_objcls, _objdb);
txtresp.Text = _dt.Rows[0][0].ToString();
if (_dt.Rows[0][1].ToString() == "True")
{
chkclose.Checked = true;
}
}
