void insert_MS_Schedule_Report() { BLL_Dml _objbll = new BLL_Dml(); _clsMaster _objcls = new _clsMaster(); _database _objdb = new _database(); _objdb.DBName = "DB_12761"; _objcls.ser_name = drservices.SelectedItem.Text; _objcls.sys_name = drpackages.SelectedItem.Text; _objcls.sys_type = drstatus.SelectedItem.Text; _objbll.insert_MS_Schedule_Report(_objcls, _objdb); }
//protected void Config_Ms_Schedule(int ser_id,bool enabled) //{ // BLL_Dml _objbll = new BLL_Dml(); // _database _objdb = new _database(); // _clsMaster _objcls = new _clsMaster(); // _objdb.DBName = "dbCML"; // _objcls.ser_id = ser_id; // _objcls.sys_id = 0; // _objcls.enabled = enabled; //} protected void add_ms_type(string _type) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsMaster _objcls = new _clsMaster(); _objdb.DBName = "DB_" + (string)Session["project"]; _objcls.ser_id = Convert.ToInt32(drmsservice.SelectedItem.Value); for (int i = 0; i <= chkmssystem.Items.Count - 1; i++) { if (chkmssystem.Items[i].Selected == true) { _objcls.enabled = true; } else { _objcls.enabled = false; } _objcls.sys_id = Convert.ToInt32(chkmssystem.Items[i].Value); _objbll.Config_Ms_Schedule(_objcls, _objdb); } }
protected void Load_MS_Systems() { chkmssystem.Items.Clear(); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsMaster _objcls = new _clsMaster(); _objdb.DBName = "dbCML"; _objcls.ser_id = Convert.ToInt32(drmsservice.SelectedItem.Value); chkmssystem.DataSource = _objbll.Load_Ms_Systems(_objcls, _objdb); DataTable _dtable = _objbll.Load_Ms_Systems(_objcls, _objdb); var _result = from o in _dtable.AsEnumerable() select o; foreach (var row in _result) { ListItem _lst = new ListItem(); _lst.Text = row[2].ToString(); _lst.Value = row[0].ToString() + "_R" + row[1].ToString(); chkmssystem.Items.Add(_lst); } }