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); }