public void updateProject(Project anProject) { using (SqlCommand cmd = DatabaseContext.Connection.CreateCommand()) { cmd.CommandText = "update project set ProjectName=" + "'" + anProject.ProjectName + "',isClosed='" + anProject.isClosed + "', CustomerNo='" + anProject.CustomerNo + "' where projectno=" + anProject.ProjectNo + ";"; cmd.ExecuteNonQuery(); } }
public Project getProjectByNo(int no) { Project result = null; using (SqlCommand cmd = new SqlCommand("select * from project where projectNo = " + no, DatabaseContext.Connection )) { SqlDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { result = new Project { ProjectName = reader["ProjectName"].ToString() }; } reader.Close(); } return result; }
private void updateProject() { Project anProject = new Project { ProjectNo = Int32.Parse(tbAdminProjectNo.Text.ToString()), ProjectName = tbAdminProjectName.Text.ToString(), isClosed = Convert.ToBoolean(cboxAdminProjectIsClosed.Checked), CustomerNo = Int32.Parse(Regex.Replace(cbAdminProjectCustomerNo.Text.ToString(), @"\D", string.Empty)), }; context.ProjectService.updateProject(anProject); }
public void updateProject(Project anProject) { context.ProjectRepository.updateProject(anProject); }