public static bool UpdateTelecomPoints(TelecomPoints telecomPoints)
{
try
{
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Connection.ConnectionName].ConnectionString))
{
string sqlstmt = "UPDATE [dbo].[TelecomPoints] SET discount = @discount Where id = @id";
SqlCommand myCommand = new SqlCommand(sqlstmt, myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@discount", telecomPoints.DiscountPercent);
myCommand.Parameters.AddWithValue("@id", telecomPoints.Id);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
catch (Exception ex)
{
return false;
}
return true;
}
private static TelecomPoints FillDataRecord(IDataRecord myDataRecord)
{
TelecomPoints telecomPoints = new TelecomPoints();
telecomPoints.Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Id"));
telecomPoints.MinPoints = myDataRecord.GetInt32(myDataRecord.GetOrdinal("minpoints"));
telecomPoints.MaxPoints = myDataRecord.GetInt32(myDataRecord.GetOrdinal("maxpoints"));
telecomPoints.DiscountPercent = myDataRecord.GetInt32(myDataRecord.GetOrdinal("discount"));
return telecomPoints;
}
public ActionResult Edit(TelecomPoints points)
{
if (ModelState.IsValid)
{
bool retval = AdminManager.UpdateTelecomPoints(points);
if (retval)
{
MvcApplication.SetMessage("Telecom Points updated Successfully.");
return RedirectToAction("ViewTelecomPoints");
}
return View(points);
}
return View(points);
}
public static bool UpdateTelecomPoints(TelecomPoints telecomPoints)
{
return TelecomPointsDB.UpdateTelecomPoints(telecomPoints);
}