//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); }