//Destination Upazila Button Code here.....
protected void btnSaveDestinationUpazilla_Click(object sender, EventArgs e)
{
if (txtDestinationUpazillaName.Text == string.Empty)
{
lblDestinationUpazila.Text = "Textbox can not be null";
}
else
{
string destinationUpazilaName = txtDestinationUpazillaName.Text.ToUpper();
int districtId = Convert.ToInt32(ddlDistrictId.SelectedValue);
DestinationUpazila destinationUpazila = new DestinationUpazila(destinationUpazilaName, districtId);
lblDestinationUpazila.Text = destinationUpazilaManager.SaveDestinationUpazila(destinationUpazila);
}
}
//Create a method for Save DestinationUpazila
public int SaveDestinationUpazila(DestinationUpazila destinationUpazila)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "INSERT INTO DestinationUpazila VALUES('" + destinationUpazila.DestinationUpazilaName + "'," + destinationUpazila.DistrictId + ")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffected = cmd.ExecuteNonQuery();
con.Close();
return(rowAffected);
}
//Create a Method for SaveFromUpazila
public string SaveDestinationUpazila(DestinationUpazila destinationUpazila)
{
DestinationUpazila aDestinationUpazila = destinationUpazilaGateway.IsExist(destinationUpazila);
if (aDestinationUpazila == null)
{
int rowAffected = destinationUpazilaGateway.SaveDestinationUpazila(destinationUpazila);
if (rowAffected > 0)
{
return("Save Successfully");
}
else
{
return("Saving failed");
}
}
else
{
return("Destination Upazila Name Exist");
}
}
//Create a method for checking DestinationUpazila Name exist or not
public DestinationUpazila IsExist(DestinationUpazila destinationUpazila)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "SELECT * FROM DestinationUpazila WHERE DestinationUpazilaName='" + destinationUpazila.DestinationUpazilaName + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
DestinationUpazila aDestinationUpazila = null;
if (reader.HasRows)
{
reader.Read();
aDestinationUpazila = new DestinationUpazila();
aDestinationUpazila.DestinationUpazilaId = (int)reader["DestinationUpazilaId"];
aDestinationUpazila.DestinationUpazilaName = reader["DestinationUpazilaName"].ToString();
}
reader.Close();
con.Close();
return(aDestinationUpazila);
}
