private void Get_ProjectName() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsuser _objcls = new _clsuser(); _objcls.project_code = lblprjcode.Text; prj.Text = _objbll.Get_ProjectName(_objcls, _objdb); }
private string Get_ProjectName() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsuser _objcls = new _clsuser(); _objcls.project_code = lblprj.Text; return(_objbll.Get_ProjectName(_objcls, _objdb)); }
private void Get_SeqNo() { string Sys_Id = drpackage.SelectedItem.Value.Substring(0, drpackage.SelectedItem.Value.IndexOf("_C")); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clscassheet _objcls = new _clscassheet(); _objdb.DBName = "DB_" + (string)Session["project"]; _objcls.sys = Convert.ToInt32(Sys_Id); txtseq.Text = _objbll.Get_Seq(_objcls, _objdb).ToString(); }
private void load_doc_review_log(string Project) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + Project; _clsuser _objcls = new _clsuser(); _dtMaster = _objbll.Load_dr_pdf(_objdb); _dtresult = _dtMaster; }
private void Generate_Summary() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsproject _objcls = new _clsproject(); _objcls.prjcode = "CCAD"; _objbll.Generate_CX_Log_Rpt(_objdb); }
private void Generate_Logo() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsproject _objcls = new _clsproject(); _objcls.prjcode = "CCAD"; _objbll.Update_RPTLogo(_objcls, _objdb); }
private void load_Allproject() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; ddlproject.DataSource = _objbll.load_project(_objdb); ddlproject.DataTextField = "prj_name"; ddlproject.DataValueField = "prj_id"; ddlproject.DataBind(); }
private void GetAccess() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clsuser _objcls = new _clsuser(); _objcls.uid = lblid.Text; lblaccess.Text = _objbll.GetUserAccess(_objcls, _objdb); }
private void Load_Buildings() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsuser _objcls = new _clsuser(); _objdb.DBName = "DB_" + (string)Session["project"]; _objcls.project_code = (string)Session["project"]; my_view.DataSource = _objbll.Load_Buildings(_objcls, _objdb); my_view.DataBind(); }
private void Load_TestNames() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clscassheet _objcas = new _clscassheet(); _objcas.sch = 34; _dtnames = _objbll.Load_CasTestNames(_objcas, _objdb); }
private void GetProjectName(string _prj) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clsuser _objcls = new _clsuser(); _objcls.project_code = _prj; prj.Text = _objbll.Get_ProjectName(_objcls, _objdb) + " - DMS"; }
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() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clscassheet _objcas = new _clscassheet(); if (lblprj.Text == "11784" && (Request.QueryString["sch"] != null)) { _objcas.sch = Convert.ToInt32(Request.QueryString["sch"].ToString()); } else { _objcas.sch = 8; } _objcas.prj_code = lblprj.Text; if (lblprj.Text == "14211" || lblprj.Text == "HMIM") { _objcas.sys = Convert.ToInt32(lbldiv.Text); } _dtMaster = _objbll.Load_casMain_Edit(_objcas, _objdb); if (lblprj.Text == "11736" || lblprj.Text == "Traini") { if (lbldiv.Text == "1") { var _result = _dtMaster.Select("b_z ='PMCW' OR b_z ='PMPW' OR b_z ='PMVW'"); _dtresult = _result.Any() ? _result.CopyToDataTable() : _dtMaster.Clone(); } else if (lbldiv.Text == "2") { var _result = _dtMaster.Select("b_z LIKE 'PMMB%' OR b_z='PMMV' OR b_z='PMST' OR b_z='PPP3' OR b_z='PPP4' OR b_z='PMMU' OR b_z='PMDW' "); _dtresult = _result.Any() ? _result.CopyToDataTable() : _dtMaster.Clone(); } else if (lbldiv.Text == "3") { var _result = _dtMaster.Select("b_z ='PSEC' OR b_z='PMWT' OR b_z='PSWB' OR b_z='PSGC' OR b_z='Energy Centre' OR b_z='PSGS'"); _dtresult = _result.Any() ? _result.CopyToDataTable() : _dtMaster.Clone(); } else if (lbldiv.Text == "4") { _dtresult = null; } } else { _dtresult = _dtMaster; } _dtfilter = _dtresult; _summary = _dtresult; }
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(); }
protected void cmdcreate_Click(object sender, EventArgs e) { if (IsnullValidation() == true) { return; } BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clsuser _objcls = new _clsuser(); _objcls.uid = userid.Text.Trim(); Generate_Autopassword(); set_services(); _objcls.pwd = (string)Session["Autopassword"]; _objcls.uname = username.Text; _objcls.project_code = ""; _objcls.access = ""; _objcls.user_group = ""; _objcls.CMS = false; _objcls.DMS = false; _objcls.TMS = false; _objcls.CU = false; _objcls.CP = false; _objcls.PM = false; //_objcls.service = ""; try { string _msg = ""; if (cmdcreate.Text == "Create User") { //_objcls.edit = false; _objcls.mode = 0; Send_Password_toUser(); _msg = "User Account has been created!"; } else { //_objcls.edit = true; _objcls.mode = 1; _msg = "User Account has been Changed!"; } _objbll.Create_user(_objcls, _objdb); Set_Project(); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + _msg + "');", true); clear(); } catch (Exception ex) { msg.Text = ex.ToString(); } }
private void Get_ProjectInfo() { BLL_Dml _objbll = new BLL_Dml(); _clsproject _objcls = new _clsproject(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _objcls.prj_id = 7; DataTable _dt = _objbll.Get_ProjectInformation(_objcls, _objdb); lblprj.Text = _dt.Rows[0].ItemArray[0].ToString(); }
private void Load_MSService() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; drservices.DataSource = _objbll.Load_Prj_Service_MS(_objdb); drservices.DataTextField = "PRJ_SER_NAME"; drservices.DataValueField = "PRJ_SER_ID"; drservices.DataBind(); drservices.Items.Insert(0, "All"); }
protected void LOAD_CAS_SERVICE() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; drservices.DataSource = _objbll.Load_Prj_Service(_objdb); drservices.DataTextField = "PRJ_SER_NAME"; drservices.DataValueField = "PRJ_SER_ID"; drservices.DataBind(); drservices.Items.Insert(0, "All Services"); }
void Log_off() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clslog _objcls = new _clslog(); _objcls.uid = (string)Session["uid"]; string _logout = Request.Form["_logout"].ToString(); _objcls.logout = _logout; _objbll.LOG_OUT(_objcls, _objdb); _toDeleteCookies(); }
protected void load_services(string Project) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + Project; drpackage.DataSource = _objbll.Load_Cas_service(_objdb); drpackage.DataTextField = "PRJ_SER_NAME"; drpackage.DataValueField = "SYS_SER_ID"; drpackage.DataBind(); drpackage.Items.Insert(0, "-- Select Service --"); }
private void Update_DrIssue() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsdocreview _objcls = new _clsdocreview(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.dr_id = Convert.ToInt32(lblid.Text); _objcls.issued_to = drissuedto.SelectedItem.Text; _objcls.issued_date = DateTime.Now; _objbll.Update_DrIssueTo(_objcls, _objdb); }
private string Get_BuildingPermission() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsuser _objcls = new _clsuser(); _objcls.uid = lbluser.Text; _objcls.mode = 2; return(_objbll.Get_Buiding_Permission(_objcls, _objdb)); }
protected void load_so_dir() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsuser _objcls = new _clsuser(); _objcls.project_code = lblprj.Text; grdSOLog.DataSource = _objbll.Load_so_dir(_objcls, _objdb);; grdSOLog.DataBind(); }
protected void load_so_dir(string Project) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + Project; _clsuser _objcls = new _clsuser(); _objcls.project_code = Project; _dtMaster = _objbll.Load_so_dir(_objcls, _objdb); _dtresult = _dtMaster; }
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); }
void load_project() { BLL_Dml _objbal = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; drproject.DataSource = _objbal.load_project(_objdb); drproject.DataTextField = "prj_name"; drproject.DataValueField = "prj_code"; drproject.DataBind(); drproject.Items.Insert(0, "--Select Project--"); }
private void Load_ProjectUsers(string _project) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "dbCML"; _clsuser _objcls = new _clsuser(); _objcls.project_code = _project; mygrid.DataSource = _objbll.load_User(_objcls, _objdb); mygrid.DataBind(); }
protected void Load_Summary() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clscassheet _objcas = new _clscassheet(); _objcas.sch = Convert.ToInt32((string)Session["sch"]); //mygridsumm.DataSource = _objbll.LOAD_CAS_PKG_SUMMARY(_objcas, _objdb); //mygridsumm.DataBind(); }
private string GetDocNo_All() { BLL_Dml _objbll = new BLL_Dml(); _clstreefolder _objcls = new _clstreefolder(); _objcls.Project_code = (string)Session["project"]; _objcls.Folder_id = Convert.ToInt16(Session["folderId"]); _database _objdb = new _database(); _objdb.DBName = "dbCML"; return(_objbll.Get_DBMsDoc_No_All(_objcls, _objdb)); }