public JsonResult LS_Edit(LocationModalModel jsonString)
{
string MachineKey = jsonString.MachineKey;
string MachineID = jsonString.MachineID;
string MachineLocation = jsonString.MachineLocation;
int OpeningHour = jsonString.OpeningHour;
int ClosingHour = jsonString.ClosingHour;
string TotalCapacity = jsonString.TotalCapacity;
bool OutOfOrder = jsonString.OutOfOrder;
string Notes = jsonString.Notes;
//Notes field is allowed to be null, therfore account for string variation
if (Notes != null)
{
Notes = "'" + Notes + "'";
}
else
{
Notes = "NULL";
}
bool editStatus = locationsupply.EditQuery(MachineKey, MachineID, MachineLocation, OpeningHour, ClosingHour, TotalCapacity, OutOfOrder, Notes);
IsTrueOrFalse model = new IsTrueOrFalse(editStatus);
return(ResultJson(model));
}
public JsonResult LS_HourlyChartData(LocationModalModel jsonString)
{
string MachineID = jsonString.MachineID;
int openingHour = jsonString.OpeningHour;
int closingHour = jsonString.ClosingHour;
List <HourlyDataModel> list = locationsupply.GetHourlyChartData(MachineID, openingHour, closingHour);
return(ResultJson(list));
}
public JsonResult LS_GetRecord(string MachineKey)
{
LocationModalModel model = locationsupply.GetRecord(MachineKey);
return(ResultJson(model));
}
/*
* Function: GetRecord
*
* Get data for location supply modals.
*
* Returns:
*
* model - a LocationModalModel model of the record with the primary key equal to the MachineKey
*/
public static LocationModalModel GetRecord(string MachineKey)
{
SqlConnection dbconnection = new SqlConnection();
SqlCommand dbcommand = new SqlCommand();
SqlDataReader dbreader;
string connectionstring = ConfigurationManager.ConnectionStrings["MugShareDB"].ToString();
string queryString = "SELECT * FROM LocationSupply WHERE pKey = " + MachineKey;
LocationModalModel model = new LocationModalModel();
try
{
if (dbconnection.State == ConnectionState.Closed)
{
dbconnection.ConnectionString = connectionstring; dbconnection.Open();
}
dbcommand.Connection = dbconnection;
dbcommand.CommandTimeout = 600;
dbcommand.CommandText = queryString;
dbcommand.CommandType = CommandType.Text;
dbreader = dbcommand.ExecuteReader();
if (dbreader.HasRows)
{
dbreader.Read();
if (!string.IsNullOrEmpty(dbreader["pKey"].ToString()))
{
model.MachineKey = dbreader["pKey"].ToString();
}
if (!string.IsNullOrEmpty(dbreader["MachineID"].ToString()))
{
model.MachineID = dbreader["MachineID"].ToString();
}
if (!string.IsNullOrEmpty(dbreader["MachineLocation"].ToString()))
{
model.MachineLocation = dbreader["MachineLocation"].ToString();
}
if (!string.IsNullOrEmpty(dbreader["OpeningHour"].ToString()))
{
model.OpeningHour = Convert.ToInt32(dbreader["OpeningHour"]);
}
if (!string.IsNullOrEmpty(dbreader["ClosingHour"].ToString()))
{
model.ClosingHour = Convert.ToInt32(dbreader["ClosingHour"]);
}
if (!string.IsNullOrEmpty(dbreader["CurrentSupply"].ToString()))
{
model.CurrentSupply = dbreader["CurrentSupply"].ToString();
}
if (!string.IsNullOrEmpty(dbreader["TotalCapacity"].ToString()))
{
model.TotalCapacity = dbreader["TotalCapacity"].ToString();
}
if (!string.IsNullOrEmpty(dbreader["TotalMugsDispensed"].ToString()))
{
model.TotalMugsDispensed = dbreader["TotalMugsDispensed"].ToString();
}
if (dbreader["OutOfOrder"].ToString() == "True")
{
model.OutOfOrder = true;
}
else
{
model.OutOfOrder = false;
}
if (!string.IsNullOrEmpty(dbreader["Notes"].ToString()))
{
model.Notes = dbreader["Notes"].ToString();
}
}
return(model);
}
catch (Exception e)
{
throw new Exception(@"Mug-Share Application GetRecord() failed : ", e);
}
finally
{
if (dbconnection.State == ConnectionState.Open)
{
dbconnection.Close();
}
}
}
