public ActionResult AddContributor(Contributors contributor) { SimchaFundManager manager = new SimchaFundManager(Properties.Settings.Default.ConStr); manager.AddContributor(new Contributors { FirstName = contributor.FirstName, LastName = contributor.LastName, PhoneNum = contributor.PhoneNum, AlwaysInclude = contributor.AlwaysInclude, }); return Redirect("Contributors"); }
public void AddContributor(Contributors newContributor) { using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "INSERT INTO Contributor (FirstName,LastName, Date, AlwaysInclude, Cell) " + "VALUES(@FirstName, @LastName, GetDate(), @AlwaysInclude, @Cell)"; cmd.Parameters.AddWithValue("@FirstName", newContributor.FirstName); cmd.Parameters.AddWithValue("@LastName", newContributor.LastName); cmd.Parameters.AddWithValue("@AlwaysInclude", newContributor.AlwaysInclude); cmd.Parameters.AddWithValue("@Cell", newContributor.Cell); connection.Open(); cmd.ExecuteNonQuery(); } }
public void AddContributor(Contributors contributor) { var connection = new SqlConnection(_connectionString); var cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = @"INSERT INTO Contributors (FirstName, LastName, Date, AlwaysInclude) VALUES (@firstName, @lastName, @date, @alwaysInclude) SELECT SCOPE_IDENTITY()"; cmd.Parameters.AddWithValue("@firstName", contributor.FirstName); cmd.Parameters.AddWithValue("@lastName", contributor.LastName); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysInclude", contributor.AlwaysInclude); contributor.Id = (int)cmd.ExecuteScalar(); }
public void UpdateContributor(Contributors contributor) { var connection = new SqlConnection(_connectionString); var cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = @"UPDATE Contributors SET FirstName = @firstName, LastName = @lastName, Date = @date, AlwaysInclude = @alwaysInclude WHERE Id = @id"; cmd.Parameters.AddWithValue("@firstName", contributor.FirstName); cmd.Parameters.AddWithValue("@lastName", contributor.LastName); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysInclude", contributor.AlwaysInclude); cmd.ExecuteNonQuery(); }
public int AddContributor(Contributors contibutor) { using (SqlConnection connection = new SqlConnection(_connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = @"INSERT INTO Contributor (FirstName, LastName, PhoneNum, AlwaysInclude) VALUES (@firstName, @lastName, @phoneNum, @alwaysInclude) SELECT @@IDENTITY"; command.Parameters.AddWithValue("@firstName", contibutor.FirstName); command.Parameters.AddWithValue("@lastName", contibutor.LastName); command.Parameters.AddWithValue("@phoneNum", contibutor.PhoneNum); command.Parameters.AddWithValue("@alwaysInclude", contibutor.AlwaysInclude); connection.Open(); return (int)(decimal)command.ExecuteScalar(); } }
public void Update(Contributors contributor) { using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = @"update Contributor Set FirstName = @FirstName, LastName = @LastName, Date = GetDate()," + "AlwaysInclude = @AlwaysInclude, Cell = @Cell Where Id = @Id"; cmd.Parameters.AddWithValue("@FirstName", contributor.FirstName); cmd.Parameters.AddWithValue("@LastName", contributor.LastName); cmd.Parameters.AddWithValue("@AlwaysInclude", contributor.AlwaysInclude); cmd.Parameters.AddWithValue("@Cell", contributor.Cell); cmd.Parameters.AddWithValue("@Id", contributor.Id); connection.Open(); cmd.ExecuteNonQuery(); } }
public void AddContributor(Contributors contributor) { using (SqlConnection con = new SqlConnection(_connectionString)) using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO Contributors(firstname, lastname, cellnumber, date, alwaysInclude) " + "VALUES (@firstname, @lastname, @cell, @date, @alwaysInclude) SELECT SCOPE_IDENTITY()"; cmd.Parameters.AddWithValue("@firstname", contributor.FirstName); cmd.Parameters.AddWithValue("@lastname", contributor.LastName); cmd.Parameters.AddWithValue("@cell", contributor.CellNumber); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysInclude", contributor.AlwaysInclude); con.Open(); contributor.Id = (int)(decimal)cmd.ExecuteScalar(); } }
public void UpdateContributor(Contributors contributor) { using (var con = new SqlConnection(_connectionString)) using (var cmd = con.CreateCommand()) { cmd.CommandText = @"UPDATE Contributors SET Firstname = @firstname, Lastname = @lastname, cellnumber = @cell, date = @date, alwaysinclude = @alwaysinclude where id = @id"; cmd.Parameters.AddWithValue("@firstname", contributor.FirstName); cmd.Parameters.AddWithValue("@lastname", contributor.LastName); cmd.Parameters.AddWithValue("@cell", contributor.CellNumber); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysinclude", contributor.AlwaysInclude); cmd.Parameters.AddWithValue("@id", contributor.Id); con.Open(); cmd.ExecuteNonQuery(); } }
public IEnumerable <Contributors> GetContributors() { var contributors = new List <Contributors>(); var connection = new SqlConnection(_connectionString); var cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "SELECT * FROM Contributors"; var reader = cmd.ExecuteReader(); while (reader.Read()) { var contributor = new Contributors(); contributor.Id = (int)reader["Id"]; contributor.FirstName = (string)reader["FirstName"]; contributor.LastName = (string)reader["LastName"]; contributor.Date = (DateTime)reader["Date"]; contributor.AlwaysInclude = (bool)reader["AlwaysInclude"]; contributor.Balance = (int)reader["Balance"]; contributors.Add(contributor); } return(contributors); }
public IEnumerable <Contributors> GetContributors() { using (var con = new SqlConnection(_connectionString)) using (var cmd = con.CreateCommand()) { cmd.CommandText = @"select * from Contributors"; List <Contributors> list = new List <Contributors>(); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Contributors c = new Contributors(); c.Id = (int)reader["Id"]; c.FirstName = (string)reader["FirstName"]; c.LastName = (string)reader["LastName"]; c.CellNumber = (string)reader["CellNumber"]; c.Date = (DateTime)reader["Date"]; c.AlwaysInclude = (bool)reader["AlwaysInclude"]; c.Amount = CurrentBalance(c.Id); list.Add(c); } return(list); } }
public void UpdateContributor(Contributors contribtor) { using (SqlConnection connection = new SqlConnection(_connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = "update Contributor set FirstName = @firstName, LastName = @lastName, PhoneNum = @phoneNum, AlwaysInclude = @alwaysInclude where id = @id"; command.Parameters.AddWithValue("@firstName", contribtor.FirstName); command.Parameters.AddWithValue("@lastName", contribtor.LastName); command.Parameters.AddWithValue("@phoneNum", contribtor.PhoneNum); command.Parameters.AddWithValue("@alwaysInclude", contribtor.AlwaysInclude); command.Parameters.AddWithValue("@id", contribtor.Id); connection.Open(); command.ExecuteNonQuery(); } }
public ActionResult EditContributor(Contributors contributor) { SimchaFundManager manager = new SimchaFundManager(Properties.Settings.Default.ConStr); manager.UpdateContributor(contributor); return Redirect("Contributors"); }