public ActionResult AddDTHPackage(DTHPackage dthPackage)
{
if (ModelState.IsValid)
{
try
{
if (dthPackage.ProviderId <= 0)
{
ModelState.AddModelError("", "Specifying Provider Name is mandatory.");
return View(dthPackage);
}
DTHManager.SaveDTHPackage(dthPackage);
MvcApplication.SetMessage("DTH Package added successfully.");
return RedirectToAction("ViewPackages");
}
catch (Exception ex)
{
MvcApplication.SetMessage(ex.Message);
ViewBag.message = MvcApplication.GetMessage();
}
}
else
{
if (dthPackage.ProviderId <= 0)
ModelState.AddModelError("", "Specifying Provider Name is mandatory.");
}
return View(dthPackage);
}
public static DTHPackage GetDTHPackage(int packageid)
{
DTHPackage DTHPackageDetails = new DTHPackage();
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Connection.ConnectionName].ConnectionString))
{
string sqlstmt = "select id, name, provider, duration, details, cost, points from [dbo].[DTHPackages] where id=@packageid";
SqlCommand myCommand = new SqlCommand(sqlstmt, myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@packageid", packageid);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.Read())
{
DTHPackageDetails = FillDataRecord(myReader);
}
myReader.Close();
}
myConnection.Close();
}
return DTHPackageDetails;
}
public static int Insert(DTHPackage dthPackage)
{
int result = 0;
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Connection.ConnectionName].ConnectionString))
{
string insertstmt = "INSERT INTO [dbo].[DTHPackages] ([name], [provider], [details], [duration], [cost], [points]) VALUES (@name, @provider, @details, @duration, @cost, @points)";
SqlCommand command = new SqlCommand(insertstmt, myConnection);
command.CommandType = CommandType.Text;
command.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = dthPackage.Name;
command.Parameters.Add("@provider", SqlDbType.Int).Value = dthPackage.ProviderId;
if (dthPackage.Description == null)
command.Parameters.Add("@details", SqlDbType.VarChar, 400).Value = DBNull.Value;
else
command.Parameters.Add("@details", SqlDbType.VarChar, 400).Value = dthPackage.Description;
command.Parameters.Add("@duration", SqlDbType.Int).Value = dthPackage.Duration;
command.Parameters.Add("@cost", SqlDbType.Money).Value = dthPackage.Cost;
command.Parameters.Add("@points", SqlDbType.Int).Value = dthPackage.Points;
DbParameter returnValue;
returnValue = command.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(returnValue);
myConnection.Open();
command.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
myConnection.Close();
}
return result;
}
public static int SaveDTHPackage(DTHPackage dthPackage)
{
return DTHPackageDB.Insert(dthPackage);
}
private static DTHPackage FillDataRecord(IDataRecord myDataRecord)
{
DTHPackage package = new DTHPackage();
package.Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("id"));
package.Name = myDataRecord.GetString(myDataRecord.GetOrdinal("name"));
package.ProviderId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("provider"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("details")))
package.Description = myDataRecord.GetString(myDataRecord.GetOrdinal("details"));
else
package.Description = "";
package.Duration = myDataRecord.GetInt32(myDataRecord.GetOrdinal("duration"));
package.Cost = myDataRecord.GetDecimal(myDataRecord.GetOrdinal("cost"));
package.Points = myDataRecord.GetInt32(myDataRecord.GetOrdinal("points"));
return package;
}
public AvailPackageViewModel()
{
dthPackage = new DTHPackage();
paymentModel = new PaymentControlModel();
}
