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