public SurveyInfoModel GetSurveyInfo(string SurveyId)
{
SurveyInfoModel surveyInfoModel = _isurveyFacade.GetSurveyInfoModel(SurveyId);
return(surveyInfoModel);
}
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";
//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.Common.BusinessObject.OrganizationBO> OrganizationBO = new List <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));
}
}