public void DeleteData(string flag) { flag = (flag.ToLower() == "y") ? flag : "d"; MetroData objmetro = new MetroData(); Int32 metrocityid = Convert.ToInt32(hdnmetrocityid.Value); string msg = objmetro.Metro_Delete(metrocityid, flag); if (msg == "") { divmsg.InnerHtml = (flag.ToLower() == "d") ? "Record deleted successfully!" : "Record undeleted successfully!"; (this.Master as Site1).show_control(flag, pnlmetro); } else { lblerrmsg.Text = msg; } }
public void SaveData() { char[] chDlr = { '$', ',', ' ', '%' }; if (hdnmetrocityid.Value == hdnnearbycityid.Value && hdnStateID.Value == hdnstateidnc.Value && hdncountry.Value == hdncountryidnc.Value) { lblerrmsg.Text = "Metro city and near by metro city should not be same!"; return; } MasterData edl = new MasterData(); List<string> CountryNames = edl.searchcity(txtmetrocityname.Text, "Y"); if (CountryNames.Count != 0 && hdnmetrocityid.Value == "0") { return; } if (CountryNames.Count == 0 || (hdncountry.Value != ddlcountry.SelectedItem.Value || hdnStateID.Value != ddlstate.SelectedItem.Value)) { SaveNewCity(); } Panel pnlfooter = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("pnlfooter") as Panel; if (pnlfooter.Visible == true) { DropDownList ddlcitynearby = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("ddlcitynearby") as DropDownList; if (ddlcitynearby.SelectedIndex > 0) { SaveTempnearbymetro(); } } MetroData objmet = new MetroData(); Int32 Metrocityid = 0, Nearbycityid = 0, countryid = 0, stateid = 0; Nullable<decimal> Metrotax = null; string statename = ""; DataTable dt = (DataTable)ViewState["temptable"]; Metrocityid = Convert.ToInt32(hdnmetrocityid.Value); countryid = Convert.ToInt32(ddlcountry.SelectedItem.Value); stateid = Convert.ToInt32(ddlstate.SelectedItem.Value); statename = txtstate.Text.Trim(); Nullable<int> timezoneid = null; timezoneid = (ddltimezone.SelectedIndex > 0) ? Convert.ToInt32(ddltimezone.SelectedItem.Value) : timezoneid; Metrotax = (txttax.Text == "") ? Metrotax : Convert.ToDecimal(txttax.Text.Trim(chDlr)); string type = "D"; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Nearbycityid = Convert.ToInt32(dt.Rows[i]["cityid"]); if (dt.Rows[i]["metro_id"].ToString() == "0") { objmet.Metro_Insert(Metrocityid, Nearbycityid, Metrotax, type, countryid, stateid, statename, timezoneid); type = "I"; } } } else { objmet.Metro_Insert(Metrocityid, Nearbycityid, Metrotax, type, countryid, stateid, statename, timezoneid); } if (string.IsNullOrEmpty(Request.QueryString["mertorcityid"])) { if (Convert.ToString(ViewState["status"]) == "") Response.Redirect("~/metro.aspx?mertorcityid=" + Metrocityid.ToString() + "&type=I"); } else { divmsg.InnerHtml = "Record updated successfully!"; } }
protected void lnkbtnDeletemetro_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = (DataTable)ViewState["temptable"]; foreach (RepeaterItem gr in Repnearbymetro.Items) { CheckBox chkdelete = (CheckBox)gr.FindControl("chkdelete"); HiddenField hdntempid = (HiddenField)gr.FindControl("hdntempid"); HiddenField hdnmetroid = (HiddenField)gr.FindControl("hdnmetroid"); if (chkdelete.Checked == true) { DataRow[] dr; dr = dt.Select("tempid='" + hdntempid.Value + "'", ""); dt.Rows.Remove(dr[0]); ; if (hdnmetroid.Value != "0") { MetroData objmet = new MetroData(); objmet.NearbyMetro_Delete(Convert.ToInt32(hdnmetroid.Value)); } } } BindNearyByMetro(); showhidefooter(false); }
public void loadmetrodetails() { try { MasterData objmst = new MasterData(); MetroData mdl = new MetroData(); DataSet ds = mdl.GetMetroDetails(Convert.ToInt32(hdnmetrocityid.Value)); DataTable dt1 = ds.Tables[0]; if (dt1.Rows.Count > 0) { txtmetrocityname.Text = dt1.Rows[0]["City_name"].ToString(); ddlstate.SelectedIndex = ddlstate.Items.IndexOf(ddlstate.Items.FindByValue(dt1.Rows[0]["STATE_ID"].ToString())); ddlcountry.SelectedIndex = ddlcountry.Items.IndexOf(ddlcountry.Items.FindByValue(dt1.Rows[0]["Country_ID"].ToString())); ddltimezone.SelectedIndex = ddltimezone.Items.IndexOf(ddltimezone.Items.FindByValue(dt1.Rows[0]["TIMEZONE_ID"].ToString())); txttax.Text = dt1.Rows[0]["METRO_TAX"].ToString(); txtzipcode.Text = dt1.Rows[0]["Zip"].ToString().Trim(); txtstate.Visible = false; ddlstate.Visible = true; hdncountry.Value = ddlcountry.SelectedItem.Value; hdnStateID.Value = ddlstate.SelectedItem.Value; string active_flag = dt1.Rows[0]["metro_flag"].ToString(); if (active_flag.ToLower() == "y") { ImageButton imgbtndelete = (ImageButton)this.Master.FindControl("imgbtndelete"); imgbtndelete.Visible = true; } if (active_flag.ToLower() == "d") { (this.Master as Site1).show_control("n", pnlmetro); } } DataTable dt = new DataTable(); dt = ds.Tables[1]; DataColumn dc = new DataColumn(); dc.ColumnName = "tempid"; dc.DataType = typeof(int); dc.AutoIncrement = true; dc.AutoIncrementSeed = 1; dt.Columns.Add(dc); dt.Columns["metro_id"].DefaultValue = 0; for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["tempid"] = i + 1; } ViewState["temptable"] = dt; dt = new DataTable(); dt = ds.Tables[2]; Repvenue.DataSource = dt; Repvenue.DataBind(); BindNearyByMetro(); if (!string.IsNullOrEmpty(Request.QueryString["mertorcityid"])) { showhidefooter(false); } } catch (Exception ex) { lblerrmsg.Text = "Error: " + ex.Message.ToString(); lblerrmsg.ForeColor = System.Drawing.Color.Red; } }