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));
}
