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