protected void NewCustomerAdd_Click1(object sender, EventArgs e)
{
ErrorLabelCustomer.Text = "";
var firstName = NewFirstname.Text;
var lastname = NewLastname.Text;
var birthdayText = NewBirthday.Text;
if (!string.IsNullOrWhiteSpace(firstName) && !string.IsNullOrWhiteSpace(lastname))
{
if (DateTime.TryParse(birthdayText, out DateTime birthday))
{
SqlDataSourceCustomer.InsertParameters["Firstname"].DefaultValue = firstName;
SqlDataSourceCustomer.InsertParameters["Lastname"].DefaultValue = lastname;
SqlDataSourceCustomer.InsertParameters["Birthday"].DefaultValue = birthday.ToString();
SqlDataSourceCustomer.Insert();
Customers.DataBind();
NewFirstname.Text = "";
NewLastname.Text = "";
NewBirthday.Text = "";
}
else
{
ErrorLabelOrder.Text = "Дата рождения не является датой!";
}
}
else
{
ErrorLabelOrder.Text = "Имя и фамилия не могут быть пустыми!";
}
}
private void BindSqlDataSources()
{
SqlDataSourceCustomer.SelectCommand = String.Format("SELECT TOP 1 * FROM [Customers] WHERE CustomerID={0}", int.Parse(textCustomerID.Text));
SqlDataSourceCustomer.DataBind();
TechSupportDataSource.SelectCommand = String.Format("SELECT * FROM [Incidents] WHERE CustomerID={0}", int.Parse(textCustomerID.Text));
TechSupportDataSource.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
SqlDataSourceCustomer.InsertParameters["Customer_Name"].DefaultValue = Customer_Name.Text;
SqlDataSourceCustomer.InsertParameters["Address"].DefaultValue = Address.Text;
SqlDataSourceCustomer.InsertParameters["City"].DefaultValue = City.Text;
SqlDataSourceCustomer.InsertParameters["State"].DefaultValue = State.Text;
SqlDataSourceCustomer.InsertParameters["Zipcode"].DefaultValue = Zipcode.Text;
SqlDataSourceCustomer.InsertParameters["Email"].DefaultValue = Email.Text;
SqlDataSourceCustomer.InsertParameters["Phone"].DefaultValue = Phone.Text;
SqlDataSourceCustomer.InsertParameters["Fax"].DefaultValue = Fax.Text;
SqlDataSourceCustomer.Insert();
CustomerGridView.DataBind();
panelAddCustomer.Visible = false;
panelSaveCustomer.Visible = true;
Fax.Text = string.Empty;
Phone.Text = string.Empty;
Email.Text = string.Empty;
Zipcode.Text = string.Empty;
State.Text = string.Empty;
City.Text = string.Empty;
Address.Text = string.Empty;
Customer_Name.Text = string.Empty;
}
private void BindSqlDataSources()
{
SqlDataSourceCustomer.SelectCommand = String.Format("SELECT * FROM [Customers] WHERE CustomerID={0}", int.Parse(textBoxGetCustomerID.Text));
SqlDataSourceCustomer.DataBind();
}
