public ActionResult Update(ChargeExtendet chargeExtendet) { if (ModelState.IsValid) { _chargeServise.Update(chargeExtendet); return(RedirectToAction("Index")); } return(View(chargeExtendet)); }
// GET: Store/Products/Edit public ActionResult Update(int?id) { if (!id.HasValue) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChargeExtendet chargeExtendet = _chargeServise.GetItem(id.Value); if (chargeExtendet == null) { return(HttpNotFound()); } return(View(chargeExtendet)); }
private ChargeExtendet ConvertSqlRowToCharge(DataRow dr) { ChargeExtendet charge = new ChargeExtendet { Date = Convert.ToDateTime(dr["Date"]), GroupName = dr["GroupName"].ToString(), GroupId = Convert.ToInt32(dr["GroupId"]), Id = Convert.ToInt32(dr["Id"]), Name = dr["Name"].ToString(), Summ = Convert.ToDecimal(dr["Summ"]) }; return(charge); }
public void Insert(ChargeExtendet chargeExtendet) { string sql = "insert into [dbo].[Charges] (Name, Summ, Date, GroupId) values(@PName, @PSumm, @PDate, @PGroupId)"; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand comm = new SqlCommand(sql, connection); comm.Parameters.AddWithValue("PName", chargeExtendet.Name.ToString()); comm.Parameters.AddWithValue("PSumm", chargeExtendet.Summ.ToString()); comm.Parameters.AddWithValue("PDate", chargeExtendet.Date.ToString()); comm.Parameters.AddWithValue("PGroupId", chargeExtendet.GroupId.ToString()); //comm.ExecuteScalar(); int numrow = comm.ExecuteNonQuery(); } }
public void Update(ChargeExtendet chargeExtendet) { string sql = "update [dbo].[Charges] set Name = @PName, Summ = @PSumm, Date = @PDate, GroupId = @PGroupId where Id = @PId"; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand comm = new SqlCommand(sql, connection); comm.Parameters.AddWithValue("PName", chargeExtendet.Name.ToString()); comm.Parameters.AddWithValue("PSumm", chargeExtendet.Summ.ToString()); comm.Parameters.AddWithValue("PDate", chargeExtendet.Date.ToString()); comm.Parameters.AddWithValue("PGroupId", chargeExtendet.GroupId.ToString()); comm.Parameters.AddWithValue("PId", chargeExtendet.Id.ToString()); //comm.ExecuteScalar(); int numrow = comm.ExecuteNonQuery(); } }
public ChargeExtendet GetItem(int id) { using (var connection = new SqlConnection(_connectionString)) { string sql = "select c.Id, cg.Name as GroupName, cg.Id as GroupId, c.Name, c.Summ, c.Date from Charges c join ChargeGroup cg on c.GroupId = cg.Id where c.Id = " + id.ToString(); var comm = new SqlCommand(sql, connection); DataTable dt = new DataTable(); var adapter = new SqlDataAdapter(comm); adapter.Fill(dt); ChargeExtendet result = null; foreach (DataRow dr in dt.Rows) //NOT VAR { result = ConvertSqlRowToCharge(dr); break; } return(result); } }
public void Update(ChargeExtendet chargeExtendet) { _chargeRepository.Update(chargeExtendet); }
public void Insert(ChargeExtendet chargeExtendet) { _chargeRepository.Insert(chargeExtendet); }