//
// GET: /Station/
//public ActionResult Index()
//{
// return View();
//}
public ActionResult AddStation()
{
#region Test Authorization
//var ben = ServiceProvider.Instance().GetBeneficiaryServices().GetBeneficiary(1);
//if (ben == null)
//{
//}
//var authParameter = new AccessParameter
//{
// DeviceIP = "192.168.8.38",
// DeviceId = "7C0507CF9FC0",
// StationName = "Upa River Curtain",
// StationId = "UBA-RV",
// Surname = "Agbure",
// FirstName = "Shelly",
// UserName = "******",
// MobileNumber = "08034256634",
// Email = "*****@*****.**"
//};
//var authParameter = new StationRegObj
//{
// DeviceIP = "192.168.8.38",
// DeviceId = "7C0507CF9FC0",
// StationName = "Upa River Curtain",
// StationId = "UBA-RV",
// Surname = "Agbure",
// FirstName = "Shelly",
// UserName = "******",
// MobileNumber = "08034256634",
// Email = "*****@*****.**"
//};
//var resp = ServiceProvider.Instance().GetClientStationServices().RegisterStation(authParameter);
//return View();
#endregion
ViewBag.Errors = Session["CreateErrors"] as List <string>;
ViewBag.Error = Session["CreateError"] as string;
Session["CreateErrors"] = "";
Session["CreateError"] = "";
if (Session["_NewStation"] == null)
{
var station = new ClientStation {
APIAccessKey = "4567382910", Status = 1
};
return(View(station));
}
var model = Session["_NewStation"] as ClientStation;
return(View(model));
}
public long AddClientStation(ClientStation station, out string msg)
{
try
{
return(_clientStationRepository.AddClientStation(station, out msg));
}
catch (Exception ex)
{
msg = "Processing Error Occurred! Please try again later";
BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult AddStation(ClientStation model)
{
var errorLists = new List <string>();
try
{
Session["_NewStation"] = model;
if (!ModelState.IsValid)
{
Session["_NewStation"] = model;
errorLists = (from value in ViewData.ModelState.Values
where value.Errors.Count > 0
from error in value.Errors
where !string.IsNullOrEmpty(error.ErrorMessage)
select error.ErrorMessage).ToList();
Session["CreateErrors"] = errorLists;
return(Redirect(Url.RouteUrl(new { action = "AddStation" })));
}
var helper = new ClientStation
{
StationName = model.StationName,
OrganizationId = model.OrganizationId,
StateId = model.StateId,
LocalAreaId = model.LocalAreaId,
StationId = model.StationId,
RegisteredByUserId = 1,
};
string msg;
var retId = ServiceProvider.Instance().GetClientStationServices().AddClientStation(helper, out msg);
if (retId < 1)
{
ViewBag.ErrorMessage = string.IsNullOrEmpty(msg) ? "Unable to add new client station" : msg;
return(View(model));
}
Session["_NewStation"] = null;
Session["Reply"] = "Station Information was added successfully";
return(Redirect(Url.RouteUrl(new { action = "AddStation" })));
}
catch (Exception ex)
{
Session["CreateError"] = ex.Message;
return(Redirect(Url.RouteUrl(new { action = "AddStation" })));
}
}
internal long AddClientStation(ClientStation clientStation, out string msg)
{
try
{
clientStation.APIAccessKey = "3924156302";
List <ValidationResult> valResults;
if (!EntityValidatorHelper.Validate(clientStation, out valResults))
{
var errorDetail = new StringBuilder();
if (!valResults.IsNullOrEmpty())
{
errorDetail.AppendLine("Following error occurred:");
valResults.ForEachx(m => errorDetail.AppendLine(m.ErrorMessage));
}
else
{
errorDetail.AppendLine("Validation error occurred! Please check all supplied parameters and try again");
}
msg = errorDetail.ToString();
return(-1);
}
#region Get Organization Info
//var clientOrg = new OrganizationRepository().GetOrganization(clientStation.OrganizationId);
#endregion
//var key = GenerateStationKey(clientStation.StationName, clientOrg.PhoneNumber, clientStation.StationId);
var key = GenerateStationKey(clientStation.StationName, "08036975694", clientStation.StationId);
if (string.IsNullOrEmpty(key) || key.Length != 10)
{
msg = "Unable to generate Station Key";
return(-1);
}
clientStation.APIAccessKey = key;
clientStation.TimeStampRegistered = DateTime.Now;
clientStation.Status = 1;
var processedClientStation = _repository.Add(clientStation);
_uoWork.SaveChanges();
msg = "";
return(processedClientStation.ClientStationId);
}
catch (Exception ex)
{
msg = "Processing Error Occurred! Please try again later " + ex.GetBaseException().Message;
BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public static List <ClientStation> GetStationByOrganizationId(int orgId)
{
try
{
var connection = ConfigurationManager.ConnectionStrings["DataKioskEntities"].ConnectionString;
if (string.IsNullOrEmpty(connection))
{
return(new List <ClientStation>());
}
using (var sqlConnection = new SqlConnection(connection))
{
sqlConnection.Open();
var sqlBuilder = new StringBuilder();
sqlBuilder.AppendFormat("SELECT * " +
" FROM \"EnrollKiosk\".\"ClientStation\" " +
" WHERE \"OrganizationId\" = {0}", orgId);
string sql = sqlBuilder.ToString();
var command = new SqlCommand(sql, sqlConnection);
var dr = command.ExecuteReader();
var items = new List <ClientStation>();
while (dr.Read())
{
var item = new ClientStation();
{
item.ClientStationId = dr.GetInt64(dr.GetOrdinal("ClientStationId"));
item.StationName = dr.GetString(dr.GetOrdinal("StationName"));
};
items.Add(item);
}
sqlConnection.Close();
return(items);
}
}
catch (Exception ex)
{
BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
return(new List <ClientStation>());
}
}
