protected void add_initial_data()
{
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 = txt_pno.Text;
_objcas.b_zone = txt_zone.Text;
_objcas.cate = "PC";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = txt_ohms.Text;
_objcas.loca = txt_wir.Text;
_objcas.p_power_to = txt_date.Text;
_objcas.fed_from = txt_status.Text;
_objcas.sub_st = txt_accepted.Text;
_objcas.s_c_m = txt_comments.Text;
_objcas.dev1 = "0";
_objcas.dev2 = "0";
_objcas.dev3 = "0";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objcas.Position = Convert.ToInt32(Get_Position());
_objbll.Cassheet_Master(_objcas, _objdb);
}
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 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);
}
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);
}
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);
}
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 = (string)Session["uid"];
if (lblsch.Text == "33")
{
_objcas.sys = 115;
}
else if (lblsch.Text == "34")
{
_objcas.sys = 116;
}
else if (lblsch.Text == "35")
{
_objcas.sys = 117;
}
_objcas.reff = txtengref.Text;
_objcas.b_zone = txt1.Text;
_objcas.cate = txt2.Text;
_objcas.f_level = "";
_objcas.seq_no = 1;
_objcas.desc = "";
_objcas.loca = "";
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.s_c_m = "";
_objcas.dev1 = txt_no.Text;
_objcas.dev2 = "";
_objcas.dev3 = "";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objcas.Position = mydetails.Rows.Count + 1;
_objbll.Cassheet_Master(_objcas, _objdb);
}
private void Edit_Inidata()
{
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 = (string)Session["uid"];
if (lblsch.Text == "33")
{
_objcas.sys = 115;
}
else if (lblsch.Text == "34")
{
_objcas.sys = 116;
}
else if (lblsch.Text == "35")
{
_objcas.sys = 117;
}
_objcas.reff = up_reff.Text;
_objcas.b_zone = uplb2.Text;
_objcas.cate = uplb3.Text;
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = txt_icomp.Text;
_objcas.loca = txt_isoff.Text;
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.s_c_m = "";
_objcas.dev1 = uplb4.Text;
_objcas.dev2 = "";
_objcas.dev3 = "0";
_objcas.mode = 0;
_objcas.cas_id = Convert.ToInt32((string)Session["casid"]);
_objbll.Cassheet_Master(_objcas, _objdb);
Update();
}
protected void add_initial_data(string _reff, string _zone, string _cate, string _flvl, int _seqno, string _loc, string _ffrom, string _ppto, string _sub, int pos)
{
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_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 2;
_objcas.prj_code = "123";
_objcas.uid = "*****@*****.**";
_objcas.sys = Convert.ToInt32(_sys);
_objcas.reff = _reff;
_objcas.b_zone = _zone;
_objcas.cate = _cate;
_objcas.f_level = _flvl;
_objcas.seq_no = _seqno;
_objcas.desc = _sub;
_objcas.loca = _loc;
_objcas.p_power_to = _ppto;
_objcas.fed_from = _ffrom;
_objcas.sub_st = _sub;
_objcas.s_c_m = _sub;
_objcas.dev1 = "0";
//if ((string)Session["sch"] == "10" || (string)Session["sch"] == "16" || (string)Session["sch"] == "20")
// _objcas.dev2 = txtdesc.Text;
//else
// _objcas.dev2 = "0";
//if ((string)Session["sch"] == "20")
// _objcas.dev3 = txtpprovideto.Text;
//else
// _objcas.dev3 = "0";
_objcas.dev2 = _sub;
_objcas.dev3 = _ppto;
_objcas.mode = 1;
_objcas.cas_id = 0;
_objcas.Position = pos;
_objbll.Cassheet_Master(_objcas, _objdb);
//Get_Position();
//Get_SeqNo();
}
protected void add_initial_data()
{
//if (IsNullvalidation() == true) return;
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_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = Convert.ToInt32((string)Session["sch"]);
_objcas.prj_code = (string)Session["project"];
_objcas.uid = (string)Session["uid"];
_objcas.sys = Convert.ToInt32(_sys);
_objcas.reff = txtengref.Text;
_objcas.b_zone = txtzone.Text;
_objcas.cate = txtcate.Text;
_objcas.f_level = txtlevel.Text;
_objcas.seq_no = Convert.ToInt32(txtseq.Text);
_objcas.desc = txtdesc.Text;
_objcas.loca = txtloca.Text;
_objcas.p_power_to = txtpprovideto.Text;
_objcas.fed_from = txtfedfr.Text;
_objcas.sub_st = txtdesc.Text;
_objcas.s_c_m = txtdesc.Text;
_objcas.dev1 = txtnoof.Text;
if ((string)Session["sch"] == "10" || (string)Session["sch"] == "16" || (string)Session["sch"] == "20")
{
_objcas.dev2 = txtdesc.Text;
}
else
{
_objcas.dev2 = "0";
}
_objcas.dev3 = "0";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objbll.Cassheet_Master(_objcas, _objdb);
}
protected void btndelete_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 0;
_objcas.prj_code = (string)Session["project"];
_objcas.uid = (string)Session["uid"];
_objcas.sys = 0;
_objcas.reff = upreff.Text;
_objcas.b_zone = upzone.Text;
_objcas.cate = upcate.Text;
_objcas.f_level = upfloor.Text;
_objcas.seq_no = Convert.ToInt32(upseq.Text);
_objcas.desc = txtdesc.Text;
_objcas.loca = uploc.Text;
_objcas.p_power_to = txtpprovideto.Text;
_objcas.fed_from = txtfedfr.Text;
_objcas.sub_st = txtdesc.Text;
_objcas.s_c_m = txtdesc.Text;
_objcas.dev1 = lb4.Text;
if ((string)Session["srv"] == "13")
{
_objcas.dev2 = txtdesc.Text;
}
else
{
_objcas.dev2 = "0";
}
_objcas.dev3 = "0";
_objcas.mode = 2;
_objcas.cas_id = Convert.ToInt32((string)Session["casid"]);
_objbll.Cassheet_Master(_objcas, _objdb);
btnDummy_ModalPopupExtender.Hide();
}
private void Edit_Inidata(int _mode)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = 0;
_objcas.prj_code = (string)Session["project"];
_objcas.uid = (string)Session["uid"];
_objcas.sys = Convert.ToInt32((string)Session["Sys"]);
_objcas.reff = upreff.Text;
_objcas.b_zone = upzone.Text;
_objcas.cate = upcate.Text;
_objcas.f_level = upfloor.Text;
_objcas.seq_no = Convert.ToInt32(upseq.Text);
_objcas.desc = txtdesc.Text;
_objcas.loca = uploc.Text;
_objcas.p_power_to = uplb1.Text;
_objcas.fed_from = uplb3.Text;
_objcas.sub_st = uplb2.Text;
_objcas.s_c_m = txtdesc.Text;
_objcas.dev1 = uplb4.Text;
if ((string)Session["srv"] == "13")
{
_objcas.dev2 = txtdesc.Text;
}
else
{
_objcas.dev2 = "0";
}
_objcas.dev3 = "0";
_objcas.mode = _mode;
_objcas.cas_id = Convert.ToInt32((string)Session["casid"]);
_objbll.Cassheet_Master(_objcas, _objdb);
}
private void Insert_to_DB()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lbprj.Text;
_clscassheet _objcas = new _clscassheet();
DataSet _dset = Read_File();
//UploadError _obj = new UploadError();
//_obj.clear();
int _Idx = 0;
int _Insert = 0;
foreach (DataRow row in _dset.Tables[0].Rows)
{
if (row[0].ToString().Trim().Length != 0)
{
_Idx += 1;
string _sch = lbsch.Text;
_objcas.c_s_id = Convert.ToInt32(_sch);
_objcas.prj_code = lbprj.Text;
_objcas.uid = "*****@*****.**";
_objcas.reff = row[0].ToString();
_objcas.b_zone = row[1].ToString();
_objcas.sch = Convert.ToInt32(_sch);
if (lbsch.Text == "25" && lbprj.Text == "12761")
{
_objcas.sys = 1134;
_objcas.cate = "PC";
_objcas.f_level = "";
_objcas.seq_no = 0;
_objcas.desc = row[2].ToString();
_objcas.loca = row[3].ToString();
if (DateValidation(row[4].ToString()) == true)
{
_objcas.p_power_to = row[4].ToString().Substring(0, 10);
}
else
{
_objcas.p_power_to = row[4].ToString();
}
_objcas.fed_from = row[5].ToString();
if (DateValidation(row[6].ToString()) == true)
{
_objcas.sub_st = row[6].ToString().Substring(0, 10);
}
else
{
_objcas.sub_st = row[6].ToString();
}
_objcas.s_c_m = row[7].ToString();
_objcas.dev1 = "0";
_objcas.dev2 = "0";
_objcas.dev3 = "0";
}
else
{
_objcas.cate = row[2].ToString();
_objcas.sys = _objbll.Get_SysId(_objcas, _objdb);
_objcas.f_level = row[3].ToString();
int _sqno = 0;
if (IsNumeric(row[4].ToString()) == true)
{
_sqno = Convert.ToInt32(row[4].ToString());
}
_objcas.seq_no = _sqno;
_objcas.loca = "";
_objcas.p_power_to = "";
_objcas.fed_from = "";
_objcas.sub_st = "";
_objcas.desc = "";
_objcas.dev1 = "";
_objcas.dev2 = "0";
_objcas.dev3 = "0";
if (_sch == "2" || _sch == "3")
{
_objcas.loca = row[5].ToString();
_objcas.p_power_to = row[7].ToString();
_objcas.fed_from = row[6].ToString();
_objcas.sub_st = row[8].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[9].ToString();
}
else if (lbprj.Text == "HMIM")
{
_objcas.panel_id = Convert.ToInt32(lblsec.Text);
}
}
else if (_sch == "4")
{
_objcas.loca = row[5].ToString();
_objcas.p_power_to = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
else if (_sch == "5")
{
_objcas.loca = row[5].ToString();
_objcas.p_power_to = row[7].ToString();
_objcas.fed_from = row[6].ToString();
_objcas.dev1 = row[8].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.sub_st = row[9].ToString();
}
if (lbprj.Text == "HMIM")
{
_objcas.panel_id = Convert.ToInt32(lblsec.Text);
}
}
else if (_sch == "6")
{
_objcas.loca = row[5].ToString();
_objcas.p_power_to = row[6].ToString();
if (lbprj.Text == "HMIM")
{
_objcas.panel_id = Convert.ToInt32(lblsec.Text);
}
}
else if (_sch == "7")
{
_objcas.loca = row[5].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.p_power_to = row[7].ToString();
_objcas.fed_from = row[6].ToString();
_objcas.dev1 = row[8].ToString();
_objcas.sub_st = row[9].ToString();
}
else
{
_objcas.dev1 = row[6].ToString();
}
}
else if (_sch == "8")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[8].ToString();
}
}
else if (_sch == "21")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.dev1 = row[7].ToString();
}
else if (_sch == "9")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.fed_from = row[7].ToString();
_objcas.p_power_to = row[8].ToString();
}
else if (lbprj.Text == "NBO")
{
_objcas.fed_from = row[7].ToString();
}
}
else if (_sch == "17")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[8].ToString();
}
}
else if (_sch == "18")
{
if (lbprj.Text == "CCAD")
{
_objcas.sub_st = row[9].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.p_power_to = row[8].ToString();
_objcas.s_c_m = row[10].ToString();
_objcas.dev1 = row[11].ToString();
_objcas.dev2 = row[12].ToString();
}
else
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.dev2 = row[5].ToString();
_objcas.dev1 = row[6].ToString();
}
}
else if (_sch == "19")
{
if (lbprj.Text == "CCAD")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.dev1 = row[6].ToString();
}
else
{
_objcas.loca = row[5].ToString();
_objcas.fed_from = row[6].ToString();
}
}
else if (_sch == "10")
{
_objcas.loca = row[5].ToString();
_objcas.dev2 = row[6].ToString();
_objcas.dev1 = row[7].ToString();
_objcas.sub_st = row[6].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.p_power_to = row[8].ToString();
_objcas.panel_ref = row[9].ToString();
_objcas.panel_id = _objbll.get_panel_id(_objcas, _objdb);
}
}
else if (_sch == "20")
{
_objcas.loca = row[5].ToString();
_objcas.fed_from = row[6].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[7].ToString();
}
else
{
_objcas.dev2 = row[8].ToString();
_objcas.dev3 = row[7].ToString();
_objcas.dev1 = row[9].ToString();
_objcas.sub_st = row[8].ToString();
_objcas.p_power_to = row[7].ToString();
}
}
else if (_sch == "13")
{
_objcas.loca = row[5].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
else if (lbprj.Text == "NCP")
{
_objcas.dev1 = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
else
{
_objcas.dev1 = row[6].ToString();
}
}
else if (_sch == "22")
{
_objcas.loca = row[5].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
else
{
_objcas.dev1 = row[6].ToString();
}
}
else if (_sch == "11")
{
_objcas.loca = row[5].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.panel_ref = row[7].ToString();
_objcas.panel_id = _objbll.get_panel_id(_objcas, _objdb);
_objcas.dev1 = row[6].ToString();
}
else
{
_objcas.dev1 = row[7].ToString();
_objcas.dev2 = row[6].ToString();
_objcas.sub_st = row[6].ToString();
}
}
else if (_sch == "12")
{
_objcas.loca = row[5].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.p_power_to = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.desc = row[8].ToString();
_objcas.sub_st = row[9].ToString();
_objcas.dev2 = row[10].ToString();
_objcas.dev1 = row[11].ToString();
}
else
{
_objcas.dev1 = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
}
else if (_sch == "15")
{
if (lbprj.Text == "CCAD")
{
_objcas.p_power_to = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.loca = row[5].ToString();
_objcas.dev1 = row[8].ToString();
}
else
{
_objcas.dev1 = row[5].ToString();
}
}
else if (_sch == "16")
{
if (lbprj.Text == "CCAD")
{
_objcas.p_power_to = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.loca = row[5].ToString();
_objcas.dev1 = row[8].ToString();
}
else if (lbprj.Text == "NCP")
{
_objcas.p_power_to = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.loca = row[5].ToString();
_objcas.dev2 = row[8].ToString();
_objcas.dev1 = row[9].ToString();
_objcas.sub_st = row[8].ToString();
}
}
else if (_sch == "14")
{
if (lbprj.Text == "CCAD")
{
_objcas.loca = row[5].ToString();
_objcas.dev1 = row[6].ToString();
}
else
{
_objcas.dev1 = row[5].ToString();
}
}
else if (_sch == "23")
{
_objcas.loca = row[5].ToString();
_objcas.fed_from = row[6].ToString();
if (lbprj.Text == "CCAD")
{
_objcas.dev1 = row[7].ToString();
_objcas.p_power_to = row[8].ToString();
}
}
else if (_sch == "24" || _sch == "29")
{
if (lbprj.Text == "CCAD" || lbprj.Text == "NCP")
{
_objcas.loca = row[5].ToString();
_objcas.dev1 = row[7].ToString();
_objcas.fed_from = row[6].ToString();
}
}
else if (_sch == "25")
{
if (lbprj.Text == "CCAD")
{
_objcas.loca = row[5].ToString();
_objcas.dev1 = row[6].ToString();
}
}
else if (_sch == "26")
{
if (lbprj.Text == "CCAD")
{
_objcas.loca = row[5].ToString();
}
}
else if (_sch == "27")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.dev1 = row[7].ToString();
}
else if (_sch == "28")
{
_objcas.sub_st = row[5].ToString();
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.p_power_to = row[8].ToString();
}
else if (_sch == "30")
{
if (lbprj.Text == "ASAO")
{
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
_objcas.dev2 = row[9].ToString();
_objcas.dev3 = row[8].ToString();
_objcas.dev1 = row[10].ToString();
_objcas.sub_st = row[9].ToString();
_objcas.p_power_to = row[8].ToString();
}
}
else if (_sch == "112" || _sch == "113" || _sch == "114" || _sch == "115" || _sch == "116")
{
_objcas.desc = row[5].ToString();
_objcas.loca = row[6].ToString();
_objcas.fed_from = row[7].ToString();
}
_objcas.s_c_m = "";
}
//if ((string)Session["sch"] == "10" || (string)Session["sch"] == "16" || (string)Session["sch"] == "20")
// _objcas.dev2 = txtdesc.Text;
//else
// _objcas.dev2 = "0";
//if ((string)Session["sch"] == "20")
// _objcas.dev3 = txtpprovideto.Text;
//else
// _objcas.dev3 = "0";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objcas.Position = _Idx;
_objbll.Cassheet_Master(_objcas, _objdb);
_Insert += 1;
}
}
string _Msg = _Insert.ToString() + " Rows Uploaded";
ScriptManager.RegisterStartupScript(this, typeof(string), "", "alert('" + _Msg + "');", true);
}