protected void UpdateButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["HiringConnectionString"].ToString().DataDirectory(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Update Positions set Name=@Name, Description=@Description, StartDate=@StartDate, Deadline=@Deadline, Hired=@Hired, ClientContactName=@ClientContactName, ClientContactPhone=@ClientContactPhone, ClientContactEmail=@ClientContactEmail where id = @id", conn); cmd.AddNewParameter("@Name", SqlDbType.VarChar, NameTextBox.Text); cmd.AddNewParameter("@Description", SqlDbType.VarChar, DescriptionTextBox.Text); cmd.AddNewParameter("@StartDate", SqlDbType.Date, StartDateTextBox.Text); cmd.AddNewParameter("@Deadline", SqlDbType.Date, DeadlineTextBox.Text); cmd.AddNewParameter("@Hired", SqlDbType.Bit, HiredCheckbox.Checked); cmd.AddNewParameter("@ClientContactName", SqlDbType.VarChar, ClientContactNameTextBox.Text); cmd.AddNewParameter("@ClientContactPhone", SqlDbType.VarChar, ClientContactPhoneTextBox.Text); cmd.AddNewParameter("@ClientContactEmail", SqlDbType.VarChar, ClientContactEmailTextBox.Text); cmd.AddNewParameter("@id", SqlDbType.Int, IdLabel1.Text); var affectedRows = cmd.ExecuteNonQuery(); if (affectedRows == 1) { ClientScript.SendScript("alert('Position updated succesfully');"); } } }
protected void UpdateButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["HiringConnectionString"].ToString().DataDirectory(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Update Clients set Name=@Name, Phone=@Phone, Email=@Email, ContactName=@ContactName, Website=@Website where id = @id", conn); cmd.Parameters.Add("@Name", SqlDbType.VarChar); cmd.Parameters["@Name"].Value = NameTextBox.Text; cmd.Parameters.Add("@Phone", SqlDbType.VarChar); cmd.Parameters["@Phone"].Value = PhoneTextBox.Text; cmd.Parameters.Add("@Email", SqlDbType.VarChar); cmd.Parameters["@Email"].Value = EmailTextBox.Text; cmd.Parameters.Add("@ContactName", SqlDbType.VarChar); cmd.Parameters["@ContactName"].Value = ContactNameTextBox.Text; cmd.Parameters.Add("@Website", SqlDbType.VarChar); cmd.Parameters["@Website"].Value = WebsiteTextBox.Text; cmd.Parameters.Add("@id", SqlDbType.VarChar); cmd.Parameters["@id"].Value = IdLabel1.Text; var affectedRows = cmd.ExecuteNonQuery(); if (affectedRows == 1) { ClientScript.SendScript($"alert('Client updated succesfully');"); } } }
protected void InsertButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["HiringConnectionString"].ToString().DataDirectory(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Insert into Positions(Name, Description, StartDate, Deadline, Hired, ClientContactName, ClientContactPhone, ClientContactEmail, IdClient) OUTPUT INSERTED.ID " + " values (@Name, @Description, @StartDate, @Deadline, @Hired, @ClientContactName, @ClientContactPhone, @ClientContactEmail, @IdClient)", conn); cmd.AddNewParameter("@Name", SqlDbType.VarChar, NameTextBox.Text); cmd.AddNewParameter("@Description", SqlDbType.VarChar, DescriptionTextBox.Text); cmd.AddNewParameter("@StartDate", SqlDbType.Date, StartDateTextBox.Text); cmd.AddNewParameter("@Deadline", SqlDbType.Date, DeadlineTextBox.Text); cmd.AddNewParameter("@Hired", SqlDbType.Bit, HiredCheckbox.Checked); cmd.AddNewParameter("@ClientContactName", SqlDbType.VarChar, ClientContactNameTextBox.Text); cmd.AddNewParameter("@ClientContactPhone", SqlDbType.VarChar, ClientContactPhoneTextBox.Text); cmd.AddNewParameter("@ClientContactEmail", SqlDbType.VarChar, ClientContactEmailTextBox.Text); cmd.AddNewParameter("@IdClient", SqlDbType.Int, ClientCombo.SelectedValue); var id = cmd.ExecuteScalar(); IdLabel1.Text = id.ToString(); ClientScript.SendScript($"alert('Position added succesfully');"); } }
protected void InsertButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["HiringConnectionString"].ToString().DataDirectory(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Insert into Clients (Name, Phone, Email, ContactName, Website) OUTPUT INSERTED.ID " + " values (@Name, @Phone, @Email, @ContactName, @Website)", conn); cmd.Parameters.Add("@Name", SqlDbType.VarChar); cmd.Parameters["@Name"].Value = NameTextBox.Text; cmd.Parameters.Add("@Phone", SqlDbType.VarChar); cmd.Parameters["@Phone"].Value = PhoneTextBox.Text; cmd.Parameters.Add("@Email", SqlDbType.VarChar); cmd.Parameters["@Email"].Value = EmailTextBox.Text; cmd.Parameters.Add("@ContactName", SqlDbType.VarChar); cmd.Parameters["@ContactName"].Value = ContactNameTextBox.Text; cmd.Parameters.Add("@Website", SqlDbType.VarChar); cmd.Parameters["@Website"].Value = WebsiteTextBox.Text; var id = cmd.ExecuteScalar(); IdLabel1.Text = id.ToString(); ClientScript.SendScript($"alert('Client added succesfully')"); } }