public int Execute_Excel_InitialTracker() { int Value = 0; DML_Utility objDML = new DML_Utility(); try { string strFilePath = ""; string strFileName = ""; // Get HostName // Get_Data_Utility objGet = new Get_Data_Utility(); List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("MISDATA"); foreach (var ob in lstConfig) { strFilePath = ob.configstring; strFileName = ob.FileName; } string path = strFilePath + strFileName; // //FilePath_Container.FilePath + FilePath_Container.FileName_InitationTracker; if (File.Exists(path)) { DataTable dt = Read_Excel("Sheet1", path); if (dt.Rows.Count > 0) { // Add Rows Count into table // long rowcount = dt.Rows.Count; objDML.Add_Rows_Count_Data(path, rowcount); Value = addData(dt); } else { Value = 9; // No data exist } } } catch (Exception ex) { Value = -1; ////// Exception Log /// int iException = objDML.Add_Exception_Log(ex.Message, ""); } return(Value); }