public ActionResult Index(string surveyid)
{
EIWSTModel TestModel = new EIWSTModel();
try
{
string version = Assembly.GetExecutingAssembly().GetName().Version.ToString();
ViewBag.Version = version;
// string _connectionString = ConfigurationManager.AppSettings["TEST_CONNECTION_STRING"];
//string connectionStringName = "EIWSADO";
string connectionStringName = "EWEADO";
//Decrypt connection string here
string _connectionString = Cryptography.Decrypt(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString);
// string _connectionString ="Data Source=ETIDHAP56-SQL;Initial Catalog=OSELS_EIWS;User ID=SA;Password=put6uQ";
using (var conn = new System.Data.SqlClient.SqlConnection(_connectionString))
using (var cmd = conn.CreateCommand())
{
conn.Open();
TestModel.DBTestStatus = TestResultEnum.Success.ToString();
cmd.CommandText = "SELECT * FROM lk_Status";
cmd.Parameters.AddWithValue("@StatusId", 1);
using (var reader = cmd.ExecuteReader())
{
if (!reader.Read())
{
return(null);
}
var TestValue = reader.GetString(reader.GetOrdinal("Status"));
}
TestModel.DBTestStatus = TestResultEnum.Success.ToString();
}
}
catch (Exception ex)
{
TestModel.DBTestStatus = TestResultEnum.Error.ToString();
TestModel.STestStatus = "Incomplete";
TestModel.EFTestStatus = "Incomplete";
TempData["exc"] = ex.Message.ToString();
TempData["exc1"] = ex.Source.ToString();
TempData["exc2"] = ex.StackTrace.ToString();
return(View(Epi.Web.MVC.Constants.Constant.INDEX_PAGE, TestModel));
}
try
{
Epi.Web.EF.EntityOrganizationDao NewEntity = new Epi.Web.EF.EntityOrganizationDao();
List <Epi.Web.Enter.Common.BusinessObject.OrganizationBO> OrganizationBO = new List <Enter.Common.BusinessObject.OrganizationBO>();
OrganizationBO = NewEntity.GetOrganizationNames();
if (OrganizationBO != null)
{
TestModel.EFTestStatus = TestResultEnum.Success.ToString();
}
}
catch (Exception ex)
{
TestModel.EFTestStatus = TestResultEnum.Error.ToString();
TestModel.STestStatus = "Incomplete";
TempData["exc"] = ex.Message.ToString();
TempData["exc1"] = ex.Source.ToString();
TempData["exc2"] = ex.StackTrace.ToString();
return(View(Epi.Web.MVC.Constants.Constant.INDEX_PAGE, TestModel));
}
//try
// {
// SurveyInfoModel surveyInfoModel = _isurveyFacade.GetSurveyInfoModel(surveyid);
// if (surveyInfoModel != null)
// {
// TestModel.STestStatus = TestResultEnum.Success.ToString();
// }
// return View(Epi.Web.MVC.Constants.Constant.INDEX_PAGE, TestModel);
// }
//catch (Exception ex)
// {
// TestModel.STestStatus = TestResultEnum.Error.ToString();
// TempData["exc"] = ex.Message.ToString();
// TempData["exc1"] = ex.Source.ToString();
// TempData["exc2"] = ex.StackTrace.ToString();
// return View(Epi.Web.MVC.Constants.Constant.INDEX_PAGE, TestModel);
// }
return(View(Epi.Web.MVC.Constants.Constant.INDEX_PAGE, TestModel));
}
public ActionResult Index(string surveyid)
{
EIWSTModel TestModel = new EIWSTModel();
try
{
string version = Assembly.GetExecutingAssembly().GetName().Version.ToString();
ViewBag.Version = version;
string connectionString = ConnectionStrings.GetConnectionString(ConnectionStrings.Key.EWEADO);
using (var conn = new System.Data.SqlClient.SqlConnection(connectionString))
using (var cmd = conn.CreateCommand())
{
conn.Open();
TestModel.DBTestStatus = TestResultEnum.Success.ToString();
cmd.CommandText = "SELECT * FROM lk_Status";
cmd.Parameters.AddWithValue("@StatusId", 1);
using (var reader = cmd.ExecuteReader())
{
if (!reader.Read())
{
return(null);
}
var TestValue = reader.GetString(reader.GetOrdinal("Status"));
}
TestModel.DBTestStatus = TestResultEnum.Success.ToString();
}
}
catch (Exception ex)
{
TestModel.DBTestStatus = TestResultEnum.Error.ToString();
TestModel.STestStatus = "Incomplete";
TestModel.EFTestStatus = "Incomplete";
TempData[TempDataKeys.ExceptionMessage] = ex.Message.ToString();
TempData[TempDataKeys.ExceptionSource] = ex.Source.ToString();
TempData[TempDataKeys.ExceptionStackTrace] = ex.StackTrace.ToString();
return(View(ViewActions.Index, TestModel));
}
try
{
Epi.Web.EF.EntityOrganizationDao NewEntity = new Epi.Web.EF.EntityOrganizationDao();
List <OrganizationBO> OrganizationBO = new List <OrganizationBO>();
OrganizationBO = NewEntity.GetOrganizationNames();
if (OrganizationBO != null)
{
TestModel.EFTestStatus = TestResultEnum.Success.ToString();
}
}
catch (Exception ex)
{
TestModel.EFTestStatus = TestResultEnum.Error.ToString();
TestModel.STestStatus = "Incomplete";
TempData[TempDataKeys.ExceptionMessage] = ex.Message.ToString();
TempData[TempDataKeys.ExceptionSource] = ex.Source.ToString();
TempData[TempDataKeys.ExceptionStackTrace] = ex.StackTrace.ToString();
return(View(ViewActions.Index, TestModel));
}
return(View(ViewActions.Index, TestModel));
}