public static List <ChartDetails> GetChartData(string prj)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database
{
DBName = "DB_" + prj
};
_clscassheet _objcls = new _clscassheet
{
date = DateTime.Today,
b_zone = "All",
f_level = "All"
};
DataSet ds = _objbll.GetDashBoardSummary(_objcls, _objdb);
List <ChartDetails> dataList = new List <ChartDetails>();
int count = ds.Tables.Count;
HttpContext.Current.Session["GetChartData"] = ds.Tables[count - 1];
foreach (DataRow dr in ds.Tables[count - 1].Rows)
{
ChartDetails details = new ChartDetails
{
Label = dr[0].ToString(),
GraphActualData = Convert.ToDecimal(dr[1]),
GraphPlannedData = Convert.ToDecimal(dr[2])
};
dataList.Add(details);
}
return(dataList);
}
private void BuildingPermission()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clscassheet _objcls = new _clscassheet();
_objdb.DBName = "DB_" + lblprj.Text;
_objcls.sch = Convert.ToInt32(lblsch.Text);
DataTable _dtpermission = _objbll.Get_CAS_BuildingPermission(_objcls, _objdb);
foreach (DataRow dRow in _dtpermission.Rows)
{
//rdbuilding.Items[0].Enabled = Convert.ToBoolean(dRow["CUC"].ToString());
//rdbuilding.Items[1].Enabled = Convert.ToBoolean(dRow["PIAZZA"].ToString());
//rdbuilding.Items[2].Enabled = Convert.ToBoolean(dRow["SERVICE"].ToString());
//rdbuilding.Items[3].Enabled = Convert.ToBoolean(dRow["HARAM"].ToString());
if (!Convert.ToBoolean(dRow["CUC"].ToString()))
{
rdbuilding.Items[0].Enabled = false; rdbuilding.Items[0].Attributes.Add("style", "color:#cccccc");
}
if (!Convert.ToBoolean(dRow["PIAZZA"].ToString()))
{
rdbuilding.Items[1].Enabled = false; rdbuilding.Items[1].Attributes.Add("style", "color:#cccccc");
}
if (!Convert.ToBoolean(dRow["SERVICE"].ToString()))
{
rdbuilding.Items[2].Enabled = false; rdbuilding.Items[2].Attributes.Add("style", "color:#cccccc");
}
if (!Convert.ToBoolean(dRow["HARAM"].ToString()))
{
rdbuilding.Items[3].Enabled = false; rdbuilding.Items[3].Attributes.Add("style", "color:#cccccc");
}
}
}
private void Insert_Summary()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_clsproject _objcls1 = new _clsproject();
_objcls1.prjcode = lblprj.Text;
_objbll.Update_RPTLogo(_objcls1, _objdb);
_objbll.Clear_PkgGroup_Summ(_objdb);
var _result = from _data in _dtsummary.AsEnumerable()
select _data;
//int count = 0;
foreach (var row in _result)
{
_objcls.sys = Convert.ToInt32(row["SYS_ID"].ToString());
_objdb.DBName = "DB_" + lblprj.Text;
_objcls.sys_mon = _objbll.get_main_cat(_objcls, _objdb);
_objcls.sys_name = _objbll.get_main_sys(_objcls, _objdb);
_objcls.sch_name = row["SYS_NAME"].ToString();
_objcls.quantity = Convert.ToInt32(row["QTY"].ToString());
_objcls.per_com1 = Convert.ToDecimal(row["PRE_COMM_QTY"].ToString());
_objcls.per_com2 = Convert.ToDecimal(row["COMM_QTY"].ToString());
_objcls.per_com3 = Convert.ToDecimal(row["PFT_TOTAL"].ToString());
_objcls.per_com4 = Convert.ToDecimal(row["PWRON_TOTAL"].ToString());
_objcls.per_com5 = Convert.ToDecimal(row["FPT_TOTAL"].ToString());
_objcls.per_com6 = Convert.ToDecimal(row["ARM_TOTAL"].ToString());
_objdb.DBName = "DBCML";
_objbll.Generate_CASSummary_PKGGRP_CCAD_MEC(_objcls, _objdb);
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + count.ToString() + "');", true);
}
private void Edit_Inidata(int _id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 25;
_objcas.prj_code = lblprj.Text;
_objcas.uid = lbluid.Text;
_objcas.sys = 1134;
_objcas.reff = upreff.Text;
_objcas.b_zone = upzone.Text;
_objcas.cate = "PC";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = upohms.Text;
_objcas.loca = upwir.Text;
_objcas.p_power_to = update.Text;
_objcas.fed_from = upstatus.Text;
_objcas.sub_st = upaccepted.Text;
_objcas.s_c_m = upcomment.Text;
_objcas.dev1 = "0";
_objcas.dev2 = "0";
_objcas.dev3 = "0";
_objcas.mode = 0;
_objcas.cas_id = _id;
_objcas.Position = Convert.ToInt32(Get_Position());
_objbll.Cassheet_Master(_objcas, _objdb);
}
private void Load_Master()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.sch = 11;
_objcas.prj_code = lblprj.Text;
if (lblprj.Text == "AFV")
{
_objcas.sys = Convert.ToInt32(Request.QueryString["div"].ToString());
}
else
{
_objcas.sys = 0;
}
_dtMaster = _objbll.Load_casMain_Edit(_objcas, _objdb);
_dtresult = _dtMaster;
_summary = _dtresult;
_dtfilter = _dtresult;
}
private void Generate_Summary_Graph()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_clsproject _objcls1 = new _clsproject();
_objcls1.prjcode = lblprj.Text;
_objbll.Update_RPTLogo(_objcls1, _objdb);
_objbll.Clear_CassummaryRpt(_objdb);
var _result = from _data in _dtsummary.AsEnumerable()
select _data;
//int count = 0;
foreach (var row in _result)
{
_objcls.sys_mon = row["SYS_NAME"].ToString();
_objcls.qty = row["QTY"].ToString();
_objcls.per_com1 = Convert.ToDecimal(row["PER_COMPLETED"].ToString());
_objcls.per_com2 = Convert.ToDecimal(row["PER_COMPLETED1"].ToString());
_objcls.per_com3 = Convert.ToDecimal(row["PER_COMPLETED2"].ToString());
_objcls.total = Convert.ToDecimal(row["TOTAL"].ToString());
_objcls.cate = row["CODE"].ToString();
_objcls.quantity = Convert.ToInt32(row["QTY"].ToString());
_objbll.Generate_CASSummary_PKG_RPT(_objcls, _objdb);
//count += 1;
}
}
private void Add_MultiEdit_temp()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcls = new _clscassheet();
for (int i = 0; i <= mymaster.Rows.Count - 1; i++)
{
GridView _details = (GridView)mymaster.Rows[i].FindControl("mydetails");
for (int j = 0; j <= _details.Rows.Count - 1; j++)
{
CheckBox checkbox = (CheckBox)_details.Rows[j].FindControl("chkrow");
if (checkbox.Checked == true)
{
_objcls.sch = Convert.ToInt32(_details.Rows[j].Cells[4].Text);
_objcls.sys = Convert.ToInt32(_details.Rows[j].Cells[5].Text);
_objcls.uid = lbluid.Text;
_objcls.action = 1;
_objbll.Add_Cas_MultiEdit_Temp(_objcls, _objdb);
}
}
}
}
private void Add_CX_Issue_Log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lbl_prj.Text;
_clscassheet _objcls = new _clscassheet();
_objcls.c_s_id = 0;
_objcls.doc = drsdoc.SelectedItem.Text;
_objcls.reff = txt_sdocref.Text;
_objcls.cx_issue = txt_cx_issue.Text;
_objcls.srv = 0;
_objcls.sch_name = txt_system.Text;
_objcls.type = drtype.SelectedItem.Text;
_objcls.loca = drloc.SelectedItem.Text;
_objcls.desc = txt_desc.Text;
_objcls.responsible = txt_resp.Text;
_objcls.dt_rep = txt_dtrep.Text;
_objcls.dt_tc = txt_dttclosure.Text;
_objcls.last_update = txt_dtlu.Text;
_objcls.dt_closed = txt_dtclsd.Text;
_objcls.dt_closure = "";
_objcls.resol_status = "";
_objcls.disci = drservice.SelectedItem.Text;
_objcls.action = 1;
int _id = _objbll.dml_cx_issues_log(_objcls, _objdb);
lblid.Text = _id.ToString();
if (_id > 0)
{
TabContainer1.Tabs[1].Enabled = true;
TabContainer1.Tabs[2].Enabled = true;
}
}
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());
if (Request.QueryString["sch"].ToString() == "27")
{
lblhead.Text = lblhead.Text + " - Marketing Suite";
}
}
else
{
_objcas.sch = 4;
}
_objcas.prj_code = lblprj.Text;
if (lblprj.Text == "HMIM" || lblprj.Text == "14211")
{
_objcas.sys = Convert.ToInt32(lbldiv.Text);
}
else
{
_objcas.sys = 0;
}
_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;
}
_summary = _dtresult;
_dtfilter = _dtresult;
}
private void Load_Master()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.sch = 12;
_objcas.prj_code = lblprj.Text;
if (lblprj.Text == "HMIM" || lblprj.Text == "14211")
{
_objcas.sys = Convert.ToInt32(lbldiv.Text);
}
else
{
_objcas.sys = 0;
}
_dtMaster = _objbll.Load_casMain_Edit(_objcas, _objdb);
_dtresult = _dtMaster;
_dtfilter = _dtresult;
_summary = _dtresult;
}
private void Inser_DmsTc()
{
Delete_DmsTc();
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_objcls.prj_code = lblprj.Text;
_objcls.srv = Convert.ToInt32(lblfolder.Text);
bool _chkd = false;
foreach (GridViewRow _drow in mygrid.Rows)
{
CheckBox _chk = (CheckBox)_drow.FindControl("chkbox");
if (_chk.Checked == true)
{
_objcls.sys = Convert.ToInt32(_drow.Cells[3].Text);
_objbll.Insert_DMS_TCDOC(_objcls, _objdb);
_chkd = true;
}
}
if (_chkd == true)
{
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Packages Updated');", true);
}
}
private void Load_cassheet_details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.sch = Convert.ToInt32(lblsch.Text);
_objcas.prj_code = lblprj.Text;
DataTable _dt = _objbll.Load_casMain_Edit(_objcas, _objdb);
var result = from o in _dt.AsEnumerable()
where o.Field <int>(0) == Convert.ToInt32((string)Session["casid"])
select o;
foreach (var row in result)
{
if (lblsch.Text == "23")
{
_1ntest.Text = row["test1"].ToString();
_1ft.Text = row["test2"].ToString();
_1bd.Text = row["test3"].ToString();
_1accept1.Text = row["accept1"].ToString();
_1filed1.Text = row["filed1"].ToString();
_1actby.Text = row["Act_by"].ToString();
_1commts.Text = row["Comm"].ToString();
_1actdt.Text = row["Act_Date"].ToString();
}
}
}
protected void Filtering()
{
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"]);
_objcas.prj_code = (string)Session["project"];
_objcas.filter = Convert.ToInt32(drfilterby.SelectedItem.Value);
_objcas.element = drfilter.SelectedItem.Text;
//info.AddMergedColumns(new int[] { 2, 3, 4, 5 }, "Asset Code");
mygrid.DataSource = _objbll.Filtering(_objcas, _objdb);
mygrid.DataBind();
//for (int i = 0; i <= mygrid.Rows.Count - 1; i++)
//{
// mygrid.Rows[i].Cells[0].Text = (i + 1).ToString();
//}
GridViewHelper _help = new GridViewHelper(mygrid);
_help.RegisterGroup("Sys_name", true, true);
_help.GroupHeader += new GroupEvent(helper_GroupHeader);
_help.ApplyGroupSort();
}
private void Load_cassheet_details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.sch = Convert.ToInt32(lblsch.Text);
_objcas.prj_code = lblprj.Text;
DataTable _dt = _objbll.Load_casMain_Edit(_objcas, _objdb);
var result = from o in _dt.AsEnumerable()
where o.Field <int>(0) == Convert.ToInt32((string)Session["casid"])
select o;
foreach (var row in result)
{
if (lblsch.Text == "23")
{
_rsubmit.Text = row["test1"].ToString();
_wReference.Text = row["test2"].ToString();
_Status.Text = row["test3"].ToString();
_acctby.Text = row["Act_by"].ToString();
_commts.Text = row["Comm"].ToString();
SetCheckedBoxChecked(_rsubmit, chk_rsubmit);
SetCheckedBoxChecked(_wReference, chk_wReference);
SetCheckedBoxChecked(_Status, chk_Status);
SetCheckedBoxChecked(_acctby, chk_acctby);
}
}
}
protected void add_initial_data()
{
string _sys = drpackage.SelectedItem.Value.Substring(0, drpackage.SelectedItem.Value.IndexOf("_C"));
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = Convert.ToInt32(lblsch.Text);
_objcas.prj_code = lblprj.Text;
_objcas.uid = lbluid.Text;
_objcas.sys = Convert.ToInt32(_sys);
_objcas.reff = txtengref.Text;
_objcas.b_zone = "";
_objcas.cate = "";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = txt_title.Text;
_objcas.loca = "";
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.s_c_m = "";
_objcas.dev1 = "";
_objcas.dev2 = "";
_objcas.dev3 = "";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objcas.Position = Convert.ToInt32(txtitmno.Text);
_objbll.Cassheet_Master(_objcas, _objdb);
}
bool DashboardAcces(string Project)
{
bool dashboard = false;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsuser _objcls = new _clsuser();
_clscassheet _objcls1 = new _clscassheet();
_objdb.DBName = "dbCML";
_objcls.uid = (string)Session["uid"];
_objcls.project_code = Project;
string _permission = _objbll.Get_User_Permission(_objcls, _objdb);
_objdb.DBName = "DB_" + Project;
DataTable _dtmodule = _objbll.Load_Prj_Module(_objdb);
var _module = from o in _dtmodule.AsEnumerable()
where (o.Field <int>(2) == 0 && o.Field <string>(1) == "Dashboard")
select o;
int _idx = 0;
foreach (var mod in _module)
{
if (_permission.Substring(_idx, 1) == "1")
{
return(true);
}
}
return(dashboard);
}
protected void load_cas_sys()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcls = new _clscassheet();
_objcls.sch = Convert.ToInt32((string)Session["sch"]);
DataTable _dt0 = _objbll.Load_cas_sys(_objcls, _objdb);
DataTable _dt1 = new DataTable();
_dt1.Columns.Add("_id");
_dt1.Columns.Add("_name");
var _List = from o in _dt0.AsEnumerable()
where o.Field <string>(3) == lblprj.Text
select o;
foreach (var row in _List)
{
DataRow _myrow = _dt1.NewRow();
_myrow[0] = row[0].ToString() + "_C" + row[2].ToString();
_myrow[1] = row[1].ToString();
_dt1.Rows.Add(_myrow);
}
drpackage.DataSource = _dt1;
drpackage.DataTextField = "_name";
drpackage.DataValueField = "_id";
drpackage.DataBind();
drpackage.Items.Insert(0, "--Package--");
}
private void Update_CX_Issue_Log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lbl_prj.Text;
_clscassheet _objcls = new _clscassheet();
_objcls.c_s_id = Convert.ToInt32(lblid.Text);
_objcls.doc = drsdoc.SelectedItem.Text;
_objcls.reff = txt_sdocref.Text;
_objcls.cx_issue = txt_cx_issue.Text;
_objcls.srv = 0;
_objcls.sch_name = txt_system.Text;
_objcls.type = drtype.SelectedItem.Text;
_objcls.loca = drloc.SelectedItem.Text;
_objcls.desc = txt_desc.Text;
_objcls.responsible = txt_resp.Text;
_objcls.dt_rep = txt_dtrep.Text;
_objcls.dt_tc = txt_dttclosure.Text;
_objcls.last_update = txt_dtlu.Text;
_objcls.dt_closed = txt_dtclsd.Text;
_objcls.dt_closure = "";
_objcls.resol_status = "";
_objcls.disci = drservice.SelectedItem.Text;
_objcls.action = 2;
int _id = _objbll.dml_cx_issues_log(_objcls, _objdb);
}
private void Edit_Inidata()
{
//uplb2.Text = updescr.Text;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 0;
_objcas.prj_code = lblprj.Text;
_objcas.uid = lbluid.Text;
_objcas.sys = Convert.ToInt32((string)Session["Sys"]);
_objcas.reff = upreff.Text;
_objcas.b_zone = "";
_objcas.cate = "";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = uptitle.Text;
_objcas.loca = "";;
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.s_c_m = "";
_objcas.dev1 = "";
_objcas.dev2 = "";
_objcas.dev3 = "0";
_objcas.mode = 0;
_objcas.cas_id = Convert.ToInt32((string)Session["casid"]);
_objbll.Cassheet_Master(_objcas, _objdb);
}
private void Load_Master(int sch)
{
if (lblprj.Text == "CCAD" || lblprj.Text == "ASAO" || lblprj.Text == "Trial")
{
var _dv = (DataView)Class1._OBJ_DATA_CAS.Select();
DataTable _dtemp = _dv.ToTable();
IEnumerable <DataRow> _result = from _data in _dtemp.AsEnumerable()
where _data.Field <int>("Cas_Schedule") == sch
select _data;
if (_result.Any())
{
_dtdetails = _result.CopyToDataTable <DataRow>();
_dtresult = _dtdetails;
}
else
{
_dtdetails = null;
_dtresult = null;
}
}
else
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.sch = sch;
_objcas.prj_code = (string)Session["project"];
_dtdetails = _objbll.Load_casMain_Edit(_objcas, _objdb);
_dtresult = _dtdetails;
}
//_dtresult = _dtdetails;
//_dtfilter = _dtresult;
//Filtering(drbzone.SelectedItem.Text, drflevel.SelectedItem.Text);
}
private void Generate_Project_Summary_Overall_Pcd()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcls = new _clscassheet();
_clsManageTree _objcls1 = new _clsManageTree();
_objcls.mode = Convert.ToInt32(ddltype.SelectedValue);
var todaysDate = DateTime.Today;
if (!string.IsNullOrEmpty(hdnpcdfrom.Value))
{
todaysDate = DateTime.ParseExact(hdnpcdfrom.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
var todaysDate1 = DateTime.Today;
if (!string.IsNullOrEmpty(hdnpcdto.Value))
{
todaysDate1 = DateTime.ParseExact(hdnpcdto.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
_objcls.dtastart = todaysDate;
_objcls.dtpstart = todaysDate1;
_objcls.cate = ddlService.SelectedValue;
//_objbll.Get_Executive_Summary_pcd(_objcls, _objdb);
_objbll.Get_Total_Executive_Summary(_objcls, _objdb);
}
private void Insert_Summary()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_objbll.Clear_CassummaryRpt(_objdb);
var _result = from _data in _summary.AsEnumerable()
select _data;
//int count = 0;
foreach (var row in _result)
{
_objcls.sys_mon = row["SYS_NAME"].ToString();
_objcls.qty = row["QTY"].ToString();
_objcls.per_com1 = Convert.ToDecimal(row["PER_COMPLETED"].ToString());
_objcls.total = Convert.ToDecimal(row["TOTAL"].ToString());
_objcls.cate = row["CODE"].ToString();
_objcls.quantity = Convert.ToInt32(row["QTY"].ToString());
_objcls.compl1 = Convert.ToInt32(row["QTY_PLANNED"].ToString());
_objbll.Generate_CASSummary_PKG_RPT_ASAO(_objcls, _objdb);
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + count.ToString() + "');", true);
}
public static List <CasSheetDetails> GetModalDetails(int casid, string prj)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database {
DBName = "DB_" + prj
};
Load_Cassheet(_objdb.DBName);
List <CasSheetDetails> datalist1 = new List <CasSheetDetails>();
bool i = _dtCassheet.AsEnumerable().Where(x => x.Field <int>("PRJ_CAS_ID") == casid).Any();
if (i)
{
_clscassheet _objcls = new _clscassheet();
_objcls.sch = casid;
_objcls.b_zone = "ALL";
_objcls.cate = "ALL";
_objcls.f_level = "ALL";
_objcls.fed_from = "ALL";
_objcls.loca = "ALL";
_objcls.build_id = 0;
_objcls.mode = 1;
DataTable _dt1 = _objbll.Generate_CAS_Graph_Summary1(_objcls, _objdb);
foreach (DataRow dr in _dt1.Rows)
{
CasSheetDetails casdetails = new CasSheetDetails
{
Label = dr[6].ToString(),
Progress = Convert.ToDecimal(dr[5]),
};
datalist1.Add(casdetails);
}
}
return(datalist1);
}
private void Delete_Inidata(int _id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 0;
_objcas.prj_code = lblprj.Text;
_objcas.uid = lbluid.Text;
_objcas.sys = Convert.ToInt32((string)Session["Sys"]);
_objcas.reff = "";
_objcas.b_zone = "";
_objcas.cate = "";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = "";
_objcas.loca = "";
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.s_c_m = "";
_objcas.dev1 = "";
_objcas.dev2 = "0";
_objcas.dev3 = "0";
_objcas.mode = 2;
_objcas.cas_id = _id;
_objbll.Cassheet_Master(_objcas, _objdb);
}
private void Insert_Summary()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clscassheet _objcls = new _clscassheet();
_objbll.Clear_CassummaryRpt1(_objdb);
var _result = from _data in _summary.AsEnumerable()
select _data;
//int count = 0;
foreach (var row in _result)
{
_objcls.sys_name = row["SYS_NAME"].ToString();
_objcls.quaty = Convert.ToDecimal(row["QTY"]);
_objcls.testd1 = (row["PER_COMPLETED3"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PER_COMPLETED3"]);
_objcls.testd2 = (row["PLANNED_PER_PCOM"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PLANNED_PER_PCOM"]);
_objcls.testd3 = (row["PER_COMPLETED"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PER_COMPLETED"]);
_objcls.testd4 = (row["ACTUAL_PER_PCOM"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["ACTUAL_PER_PCOM"]);
_objcls.qty1 = (row["PER_COMPLETED4"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PER_COMPLETED4"]);
_objcls.qty2 = (row["PLANNED_PER_COM"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PLANNED_PER_COM"]);
_objcls.testd = (row["PER_COMPLETED1"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["PER_COMPLETED1"]);
_objcls.qty3 = (row["ACTUAL_PER_COM"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["ACTUAL_PER_COM"]);
_objcls.qty4 = (row["TOTAL1"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["TOTAL1"]);
_objcls.total = (row["TOTAL"].ToString() == "N/A") ? -1 : Convert.ToDecimal(row["TOTAL"]);
_objbll.Generate_CASSummary_PKG_RPT_CCAD_FAS(_objcls, _objdb);
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + count.ToString() + "');", true);
}
protected void my_view_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
TextBox _txtbuilding = (TextBox)e.Item.FindControl("txtbuilding");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clscassheet _objcls = new _clscassheet();
_objdb.DBName = "DB_" + (string)Session["project"];
_objcls.build_id = 0;
_objcls.build_name = _txtbuilding.Text;
_objcls.mode = 0;
_objcls.prj_code = (string)Session["project"];
_objbll.Create_Building(_objcls, _objdb);
}
else if (e.CommandName == "Update")
{
TextBox _txtbuilding = (TextBox)e.Item.FindControl("txtbuilding");
Label _id = (Label)e.Item.FindControl("lbid");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clscassheet _objcls = new _clscassheet();
_objdb.DBName = "DB_" + (string)Session["project"];
_objcls.build_id = 0;
_objcls.build_name = _txtbuilding.Text;
_objcls.mode = 0;
_objcls.prj_code = (string)Session["project"];
_objbll.Create_Building(_objcls, _objdb);
}
}
//public static List<List<ChartDetails>> GetCasDetails(string prj)
public static async Task <List <List <ChartDetails> > > GetCasDetails(string prj)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database {
DBName = "DB_" + prj
};
Load_Cassheet(_objdb.DBName);
List <int> list = _dtCassheet.AsEnumerable().Where(x => (x.Field <int>("PRJ_CAS_ID") == 10 || x.Field <int>("PRJ_CAS_ID") == 20)).Select(dr => dr.Field <int>("PRJ_CAS_ID")).ToList();
List <List <ChartDetails> > nestedlist = new List <List <ChartDetails> >();
foreach (int i in list)
{
_clscassheet _objcls = new _clscassheet();
_objcls.sch = i;
_objcls.b_zone = "ALL";
_objcls.cate = "ALL";
_objcls.f_level = "ALL";
_objcls.fed_from = "ALL";
_objcls.loca = "ALL";
_objcls.build_id = 0;
_objcls.mode = 1;
_objcls.date = DateTime.Today;
DataSet _dt1 = _objbll.Generate_ProgressComparison_Graph(_objcls, _objdb);
List <ChartDetails> datalist1 = new List <ChartDetails>();
List <ChartDetails> datalist2 = new List <ChartDetails>();
foreach (DataRow dr in _dt1.Tables[0].Rows)
{
ChartDetails casdetails = new ChartDetails
{
Label = dr["PKG_NAME"].ToString(),
//GraphPlannedData = Convert.ToDecimal(dr["PCOMPROGRESS"]),
GraphActualData = Convert.ToDecimal(dr["Overall"]),
};
if (i == 10)
{
datalist1.Add(casdetails);
}
else if (i == 20)
{
datalist2.Add(casdetails);
}
}
if (i == 10)
{
nestedlist.Add(datalist1);
HttpContext.Current.Session["GetCasDetails_1"] = _dt1.Tables[0];
}
else if (i == 20)
{
nestedlist.Add(datalist2);
HttpContext.Current.Session["GetCasDetails_2"] = _dt1.Tables[0];
}
}
await Task.Yield();
return(nestedlist);
}
private string Get_Position()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clscassheet _objcls = new _clscassheet();
_objdb.DBName = "DB_" + lblprj.Text;
_objcls.sys = 1134;
return(_objbll.Get_Position(_objcls, _objdb).ToString());
}
private string GetDocNo_All()
{
BLL_Dml _objbll = new BLL_Dml();
_clscassheet _objcls = new _clscassheet();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_objcls.srv = 0;
_objcls.build_id = Convert.ToInt32(rd_Building.SelectedItem.Value);
return(_objbll.Get_Get_MsDoc_No_ALL_Div(_objcls, _objdb).ToString());
}
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 = 25;
_dtnames = _objbll.Load_CasTestNames(_objcas, _objdb);
}
