private void FillCityGridView()
{
MST_CityBAL balMST_State = new MST_CityBAL();
gvCity.DataSource = balMST_State.SelectAll();;
gvCity.DataBind();
}
private void Search()
{
MST_CityBAL balMST_City = new MST_CityBAL();
rptCityList.DataSource = balMST_City.SelectAll();;
rptCityList.DataBind();
int Count = rptCityList.Items.Count;
lblCount.Text = Count.ToString();
}
public static void FillDropDownListCityID(DropDownList ddl)
{
MST_CityBAL balMST_City = new MST_CityBAL();
ddl.DataSource = balMST_City.SelectComboBox();
ddl.DataValueField = "CityID";
ddl.DataTextField = "CityName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("---Select City---", "-99"));
}
protected void GvCity_ItermCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
try
{
MST_CityBAL balMST_City = new MST_CityBAL();
balMST_City.Delete(Convert.ToInt32(e.CommandArgument));
}
catch (Exception ex)
{
lblMessege.Text = ex.Message;
}
finally
{
FillCityGridView();
}
}
}
protected void rptCityList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
try
{
MST_CityBAL balMST_City = new MST_CityBAL();
balMST_City.Delete(Convert.ToInt32(e.CommandArgument));
}
catch (Exception ex)
{
pnlAlert.Visible = true;
lblMsg.Text = ex.Message;
}
finally
{
Search();
}
}
}
private void FillControls(Int32 CityID)
{
//lblPageHeader.Text = CV.PageHeaderEdit + " City";
MST_CityBAL balMST_City = new MST_CityBAL();
MST_CityENT entMST_City = new MST_CityENT();
entMST_City = balMST_City.SelectPK(CityID);
if (!entMST_City.CityName.IsNull)
{
txtCityName.Text = entMST_City.CityName.Value.ToString();
}
if (!entMST_City.STDCode.IsNull)
{
txtSTDCode.Text = entMST_City.STDCode.Value.ToString();
}
if (!entMST_City.StateID.IsNull)
{
ddlState.SelectedValue = entMST_City.StateID.Value.ToString();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Request.QueryString["CityID"] == null)
{
MST_CityENT entMST_City = new MST_CityENT();
if (txtCityName.Text.ToString().Trim() != "")
{
entMST_City.CityName = txtCityName.Text.ToString().Trim();
}
//if (txtPinCode.Text.ToString().Trim() != "")
//{
// entMST_City.PinCode = txtPinCode.Text.ToString().Trim();
//}
if (txtSTDCode.Text.ToString().Trim() != "")
{
entMST_City.STDCode = txtSTDCode.Text.ToString().Trim();
}
if (ddlState.SelectedIndex > 0)
{
entMST_City.StateID = Convert.ToInt32(ddlState.SelectedValue);
}
entMST_City.CreationDate = DateTime.Now;
entMST_City.ModificationDate = DateTime.Now;
entMST_City.UserID = Convert.ToInt32(Session["UserID"]);
MST_CityBAL balMST_City = new MST_CityBAL();
if (balMST_City.Insert(entMST_City))
{
pnlAlert.Visible = true;
lblMessage.Text = "Data Inserted Successfully.";
ClearControls();
}
}
else
{
MST_CityENT entMST_City = new MST_CityENT();
if (txtCityName.Text.ToString().Trim() != "")
{
entMST_City.CityName = txtCityName.Text.ToString().Trim();
}
//if (txtPinCode.Text.ToString().Trim() != "")
//{
// entMST_City.PinCode = txtPinCode.Text.ToString().Trim();
//}
if (txtSTDCode.Text.ToString().Trim() != "")
{
entMST_City.STDCode = txtSTDCode.Text.ToString().Trim();
}
if (ddlState.SelectedIndex > 0)
{
entMST_City.StateID = Convert.ToInt32(ddlState.SelectedValue);
}
entMST_City.CityID = Convert.ToInt32(Request.QueryString["CityID"]);
entMST_City.ModificationDate = DateTime.Now;
entMST_City.UserID = Convert.ToInt32(Session["UserID"]);
MST_CityBAL balMST_City = new MST_CityBAL();
if (balMST_City.Update(entMST_City))
{
Response.Redirect("~/AdminPanel/Master/MST_City/MST_CityList.aspx");
}
}
}
