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')");
}
}