//Create a method for Save FromUpazila
public int SaveFromUpazila(FromUpazila fromUpazila)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "INSERT INTO FromUpazila VALUES('" + fromUpazila.FromUpazilaName + "'," + fromUpazila.DistrictId + ")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffected = cmd.ExecuteNonQuery();
con.Close();
return(rowAffected);
}
//Create a Method for SaveFromUpazila
public string SaveFromUpazila(FromUpazila fromUpazila)
{
FromUpazila aFromUpazila = fromUpazilaGateway.IsExist(fromUpazila);
if (aFromUpazila == null)
{
int rowAffected = fromUpazilaGateway.SaveFromUpazila(fromUpazila);
if (rowAffected > 0)
{
return("Save Successfully");
}
else
{
return("Saving failed");
}
}
else
{
return("From Upazila Name is Exist");
}
}
//Create a mmethod for checking FromUpazila Name exist or not
public FromUpazila IsExist(FromUpazila fromUpazila)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "SELECT * FROM FromUpazila WHERE FromUpazilaName='" + fromUpazila.FromUpazilaName + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
FromUpazila aFromUpazila = null;
if (reader.HasRows)
{
reader.Read();
aFromUpazila = new FromUpazila();
aFromUpazila.FromUpazilaId = (int)reader["FromUpazilaId"];
aFromUpazila.FromUpazilaName = reader["FromUpazilaName"].ToString();
}
reader.Close();
con.Close();
return(aFromUpazila);
}
//From Upazila Save Button Code here.......
protected void btnSaveFromUpazilla_Click(object sender, EventArgs e)
{
if (txtFromUpazillaName.Text == string.Empty)
{
lblFromUpazila.Text = "Text Boxcan not be null";
}
else
{
string fromUpazilaName = txtFromUpazillaName.Text.ToUpper();
int districtId = Convert.ToInt32(ddlDistrictId.SelectedValue);
FromUpazila fromUpazila = new FromUpazila(fromUpazilaName, districtId);
lblFromUpazila.Text = fromUpazilaManager.SaveFromUpazila(fromUpazila);
}
//Display success message and clear the form.
//string message = "Your details have been saved successfully.";
//string script = "window.onload = function(){ alert('";
//script += message;
//script += "');";
//script += "window.location = '";
//script += Request.Url.AbsoluteUri;
//script += "'; }";
//ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
}
