public ActionResult Create(FormCollection collection)
{
TaxSystemOperatMODEL newOperation = new TaxSystemOperatMODEL();
SqlConnection connCREATEpost = new SqlConnection();
try
{
connCREATEpost.ConnectionString = ConfigurationManager.ConnectionStrings["SRFNconnection"].ConnectionString;
newOperation.isin = collection["isin"];
newOperation.purchaseDate = Convert.ToDateTime(collection["purchaseDate"].ToString());
newOperation.sellDate = Convert.ToDateTime(collection["sellDate"].ToString());
//newOperation.sellDate = collection["sellDate"].ToString("YYYY-MM-dd");
newOperation.amount = collection["amount"];
newOperation.description = collection["description"];
string queryCREATE = "INSERT INTO Nutella.operations (isin,purchaseDate,sellDate,amount,description)" +
" VALUES ('" +
newOperation.isin + "','" +
newOperation.purchaseDate + "','" +
newOperation.sellDate + "','" +
newOperation.amount + "','" +
newOperation.description + "');";
connCREATEpost.Open();
SqlCommand commCREATEpost = new SqlCommand(queryCREATE, connCREATEpost);
commCREATEpost.ExecuteNonQuery();
return(RedirectToAction("Manage"));
}
catch
{
return(View());
}
finally
{
connCREATEpost.Close();
}
}
static List <TaxSystemOperatMODEL> ReadAllOperationsFromDB()
{
List <TaxSystemOperatMODEL> myOperations = new List <TaxSystemOperatMODEL>();
SqlConnection myConnSRFN2 = new SqlConnection();
try
{
myConnSRFN2.ConnectionString = ConfigurationManager.ConnectionStrings["SRFNconnection"].ConnectionString;
myConnSRFN2.Open();
string queryString = "SELECT operationId,isin,purchaseDate,sellDate,amount,description FROM Nutella.operations;";
SqlCommand commandReadAll = new SqlCommand(queryString, myConnSRFN2);
SqlDataReader myUsersResults = commandReadAll.ExecuteReader();
while (myUsersResults.Read())
{
TaxSystemOperatMODEL newOperation = new TaxSystemOperatMODEL();
newOperation.operationId = int.Parse(myUsersResults["operationId"].ToString());
newOperation.isin = myUsersResults["isin"].ToString();
newOperation.purchaseDate = (DateTime)myUsersResults["purchaseDate"];
newOperation.sellDate = Convert.ToDateTime(myUsersResults["sellDate"]);
//the most correct one: the one with selldate but with Tostring("YYYY-MM-dd") at the end newOperation.amount = myUsersResults["amount"].ToString();
newOperation.description = myUsersResults["description"].ToString();
myOperations.Add(newOperation);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnSRFN2.Close();
}
return(myOperations);
}
