public bool InsertSmartEnergyMeter(Entities.SmartEnergyMeter smaertEnergyMeter)
{
Database db = new SqlDatabase(SmartEmConnectionString);
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SmartEnergyMeterInsert";
cmd.Parameters.Add(new SqlParameter("@Id", smaertEnergyMeter.Id)
{
SqlDbType = SqlDbType.NVarChar
});
cmd.Parameters.Add(new SqlParameter("@CustomerId", smaertEnergyMeter.CustomerId)
{
SqlDbType = SqlDbType.NVarChar
});
cmd.Parameters.Add(new SqlParameter("@TariffType", smaertEnergyMeter.TariffType)
{
SqlDbType = SqlDbType.Int
});
return(cmd.ExecuteNonQuery() > 0);
}
}
}
public List <Entities.SmartEnergyMeter> SmartEnergyMeterGet()
{
Database db = new SqlDatabase(SmartEmConnectionString);
List <Entities.SmartEnergyMeter> smartEnergyMeters = new List <Entities.SmartEnergyMeter>();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SmartEnergyMeterGet";
using (var reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
Entities.SmartEnergyMeter temp = new Entities.SmartEnergyMeter();
temp.Id = (reader["Id"]).ToString();
temp.CustomerId = reader["CustomerId"].ToString();
temp.TariffType = Convert.ToInt32(reader["TariffType"]);
smartEnergyMeters.Add(temp);
}
}
return(smartEnergyMeters);
}
}
}
public async Task <ActionResult> RegisterSmartEnergyMeter(SmartEnergyMeterViewModels model, FormCollection formcollection)
{
if (ModelState.IsValid)
{
SmartEnergyMeter.Entities.SmartEnergyMeter smartEM = new Entities.SmartEnergyMeter();
smartEM.CustomerId = model.CustomerId;
smartEM.Id = model.Id;
smartEM.TariffType = Convert.ToInt32(formcollection["userTypeGrp"]);
await client.SmartEnergyMeterInsert(smartEM);
return(RedirectToAction("ManageSmartEnergyMeter", "AdminAccount"));
}
return(View());
}
public async Task <bool> SmartEnergyMeterInsert(Entities.SmartEnergyMeter smartEnergyMeter)
{
HttpResponseMessage response = await client.PostAsJsonAsync(url + "smartem", smartEnergyMeter);
return(response.StatusCode == System.Net.HttpStatusCode.OK);
}
