private void Search()
{
MST_StateBAL balMST_State = new MST_StateBAL();
rptStateList.DataSource = balMST_State.SelectAll();
rptStateList.DataBind();
int Count = rptStateList.Items.Count;
lblCount.Text = Count.ToString();
}
public static void FillDropDownListStateID(DropDownList ddl)
{
MST_StateBAL balMST_State = new MST_StateBAL();
ddl.DataSource = balMST_State.SelectComboBox();
ddl.DataValueField = "StateID";
ddl.DataTextField = "StateName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("---Select State---", "-99"));
}
private void FillControls(Int32 StateID)
{
//lblPageHeader.Text = CV.PageHeaderEdit + " State";
MST_StateBAL balMST_State = new MST_StateBAL();
MST_StateENT entMST_State = new MST_StateENT();
entMST_State = balMST_State.SelectPK(StateID);
if (!entMST_State.StateName.IsNull)
{
txtStateName.Text = entMST_State.StateName.Value.ToString();
}
}
protected void rptStateList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
try
{
MST_StateBAL balMST_State = new MST_StateBAL();
balMST_State.Delete(Convert.ToInt32(e.CommandArgument));
}
catch (Exception ex)
{
pnlAlert.Visible = true;
lblMsg.Text = ex.Message;
}
finally
{
Search();
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Request.QueryString["StateID"] == null)
{
MST_StateENT entMST_State = new MST_StateENT();
if (txtStateName.Text.ToString().Trim() != "")
{
entMST_State.StateName = txtStateName.Text.ToString().Trim();
}
entMST_State.CreationDate = DateTime.Now;
entMST_State.ModificationDate = DateTime.Now;
entMST_State.UserID = Convert.ToInt32(Session["UserID"]);
MST_StateBAL balMST_State = new MST_StateBAL();
if (balMST_State.Insert(entMST_State))
{
pnlAlert.Visible = true;
lblMessage.Text = "Data Inserted Successfully.";
ClearControls();
}
}
else
{
MST_StateENT entMST_State = new MST_StateENT();
if (txtStateName.Text.ToString().Trim() != "")
{
entMST_State.StateName = txtStateName.Text.ToString().Trim();
}
entMST_State.StateID = Convert.ToInt32(Request.QueryString["StateID"]);
entMST_State.ModificationDate = DateTime.Now;
entMST_State.UserID = Convert.ToInt32(Session["UserID"]);
MST_StateBAL balMST_State = new MST_StateBAL();
if (balMST_State.Update(entMST_State))
{
Response.Redirect("~/AdminPanel/Master/MST_State/MST_StateList.aspx");
}
}
}
