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