private void CityCombobox_DropDownClosed(object sender, EventArgs e)
{
string ctyslct = CityCombobox.GetItemText(CityCombobox.SelectedItem);
using (MySqlConnection cmn = new MySqlConnection(Globals.connStr))
{
cmn.Open();
MySqlCommand mmmd = new MySqlCommand("SELECT cityId from city where city = '" + ctyslct + "';", cmn);
MySqlDataAdapter mapt = new MySqlDataAdapter(mmmd);
DataTable mdm = new DataTable();
mapt.Fill(mdm);
if (mdm.Rows.Count > 0)
{
int idc = (int)mdm.Rows[0][0];
Globals.CtyID = idc;
}
cmn.Close();
}
}
private void ACAddButton_Click(object sender, EventArgs e)
{//SAVE NEW CUSTOMER
if (String.IsNullOrEmpty(ACNameTextbox.Text))
{
MessageBox.Show("Please enter a name.");
return;
}
if (String.IsNullOrEmpty(ACAddressTextbox.Text))
{
MessageBox.Show("Please enter an address.");
return;
}
if (String.IsNullOrEmpty(ACZipTextbox.Text))
{
MessageBox.Show("Please enter a zip code.");
return;
}
if (String.IsNullOrEmpty(ACPhoneTextBox.Text))
{
MessageBox.Show("Please enter a phone number.");
return;
}
try
{
//Get City ID
string ctd = CityCombobox.GetItemText(CityCombobox.SelectedItem);
using (MySqlConnection comn = new MySqlConnection(Globals.connStr))
{
comn.Open();
MySqlCommand mmd = new MySqlCommand("SELECT cityId from city where city = '" + ctd + "';", comn);
MySqlDataAdapter apt = new MySqlDataAdapter(mmd);
DataTable md = new DataTable();
apt.Fill(md);
if (md.Rows.Count > 0)
{
int idc = (int)md.Rows[0][0];
Globals.CtyID = idc;
}
comn.Close();
}
//insert ADDRESS/CITY/COUNTRY
string Query = "Insert into address(address,cityId,postalCode,phone,createDate,createdBy) " +
"Values('" + ACAddressTextbox.Text + "','" + Globals.CtyID + "','" + ACZipTextbox.Text + "','" + ACPhoneTextBox.Text + "','" + TimeZoneInfo.ConvertTimeToUtc(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss") + "','" + Globals.CurrUserName + "');";
MySqlConnection con2 = new MySqlConnection(Globals.connStr);
MySqlCommand comm = new MySqlCommand(Query, con2);
MySqlDataReader rdr;
con2.Open();
rdr = comm.ExecuteReader();
con2.Close();
//get ADDRESS ID
MySqlConnection cmn = new MySqlConnection(Globals.connStr);
MySqlCommand mmmd = new MySqlCommand("SELECT addressId from address where phone = '" + ACPhoneTextBox.Text + "';", cmn);
MySqlDataAdapter mapt = new MySqlDataAdapter(mmmd);
cmn.Open();
DataTable mdm = new DataTable();
mapt.Fill(mdm);
if (mdm.Rows.Count > 0)
{
int idc = (int)mdm.Rows[0][0];
Globals.AddID = idc;
}
cmn.Close();
//insert into CUSTOMER
string Queryx = "Insert into customer(customerName,addressId,active,createDate,createdBy)" +
"Values('" + ACNameTextbox.Text + "','" + Globals.AddID + "','1','" + TimeZoneInfo.ConvertTimeToUtc(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss") + "','" + Globals.CurrUserName + "');";
MySqlConnection con2x = new MySqlConnection(Globals.connStr);
MySqlCommand commx = new MySqlCommand(Queryx, con2x);
MySqlDataReader rdrx;
con2x.Open();
rdrx = commx.ExecuteReader();
MessageBox.Show("Data Saved");
while (rdrx.Read())
{
}
con2x.Close();
}
catch (Exception)
{
MessageBox.Show("Customer could not be added.", "Error");
}
this.Hide();
Dashboard db = new Dashboard();
db.ShowDialog();
}
protected void StateCombobox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
String State = StateCombobox.Text;
String Country = CountryCombobox.Text;
System.Net.WebClient web = new System.Net.WebClient();
web.QueryString.Add("Country", Country);
web.QueryString.Add("State", State);
string response = web.DownloadString("http://jnitinc.com/WebService/GetCity.php?Country=" + Country + "&State=" + State + "");
//List<City> ls = deserializeJson<List<LocationValues>>(response);
List <CityNames> lst = new List <CityNames>();
DataContractJsonSerializer jsonSer = new DataContractJsonSerializer(lst.GetType());
System.IO.MemoryStream ms = new System.IO.MemoryStream(System.Text.Encoding.Unicode.GetBytes(response));
lst = (List <CityNames>)jsonSer.ReadObject(ms);
DataTable dt = new DataTable();
dt.Columns.Add("City");
foreach (CityNames city in lst)
{
DataRow row = dt.NewRow();
row["City"] = city.City;
dt.Rows.Add(row);
}
CityCombobox.DataSource = dt;
CityCombobox.TextField = "City";
CityCombobox.ValueField = "City";
CityCombobox.DataBind();
CityCombobox.Focus();
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
/*
*
* try
* {
*
* DataTable dt = new DataTable();
* dt = VSWebBL.SecurityBL.LocationsBL.Ins.GetCitiesFromStateAndCountry(StateCombobox.Text, CountryCombobox.Text);
*
* }
* catch (Exception ex)
* {
* Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
* throw ex;
* }
* finally { }
*/
}
