public string createnewengt(int rowid, Excel.Worksheet _valsheet)
{
string showid, cityid, venueid, presenterid, statename = "";
DateTime engtdate;
showid = _valsheet.Cells[rowid, 18].Text;
cityid = _valsheet.Cells[rowid, 15].Text;
if (cityid.Split(',').Length > 1)
{
statename = cityid.Split(',').GetValue(1).ToString();
}
cityid = cityid.Split(',').GetValue(0).ToString();
venueid = _valsheet.Cells[rowid, 19].Text;
presenterid = _valsheet.Cells[rowid, 22].Text;
engtdate = Convert.ToDateTime(_valsheet.Cells[rowid, 21].Text);
MasterData objmst = new MasterData();
String newengtid = objmst.EngtInsert_fromexcel(showid, cityid, venueid, presenterid, engtdate, statename);
return newengtid.ToString();
}