public StatesENT SelectByPK(SqlInt32 StatesID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_States_SelectByPK";
objCmd.Parameters.AddWithValue("@StateID", StatesID);
#endregion Prepare Command
#region ReadData and Set Controls
StatesENT entStates = new StatesENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["StateID"].Equals(DBNull.Value))
{
entStates.StateID = Convert.ToInt32(objSDR["StateID"]);
}
if (!objSDR["CountryID"].Equals(DBNull.Value))
{
entStates.CountryID = Convert.ToInt32(objSDR["CountryID"]);
}
if (!objSDR["StateName"].Equals(DBNull.Value))
{
entStates.StateName = Convert.ToString(objSDR["StateName"]);
}
}
}
return(entStates);
#endregion ReadData and Set Controls
}
catch (SqlException sqlex)
{
Message = sqlex.Message.ToString();
return(null);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
lblError.Text = "";
if (txtStateName.Text.Trim().ToUpper() == "")
{
lblError.Text += "Enter State Name <br/>";
}
if (ddlCountry.SelectedValue == "-1")
{
lblError.Text += "Please Select Country <br/>";
}
if (lblError.Text != "")
{
return;
}
#endregion Server Side Validation
#region Collecting Data
StatesENT entState = new StatesENT();
if (ddlCountry.SelectedValue != "-1" && txtStateName.Text.Trim().ToUpper() != "")
{
entState.StateName = txtStateName.Text.Trim().ToUpper();
entState.CountryID = Convert.ToInt32(ddlCountry.SelectedValue);
}
StatesBAL balState = new StatesBAL();
#endregion Collecting Data
if (Request.QueryString["StateID"] == null)
{
#region insertingData
if (balState.Insert(entState))
{
Response.Redirect("~/AdminPanel/State/StateList.aspx");
}
else
{
lblError.Text = balState.Message;
}
#endregion insertingData
}
else
{
#region updatingData
entState.StateID = Convert.ToInt32(Request.QueryString["StateID"]);
if (balState.Update(entState))
{
Response.Redirect("~/AdminPanel/State/StateList.aspx");
}
else
{
lblError.Text = balState.Message;
}
#endregion updatingData
}
}
public Boolean Update(StatesENT entStates)
{
StatesDAL dalStates = new StatesDAL();
if (dalStates.Update(entStates))
{
return(true);
}
else
{
Message = dalStates.Message;
return(false);
}
}
public Boolean Insert(StatesENT entStates)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_States_Insert";
objCmd.Parameters.Add("@StateID", SqlDbType.Int).Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("@CountryID", SqlDbType.Int).Value = entStates.CountryID;
objCmd.Parameters.AddWithValue("@StateName", SqlDbType.VarChar).Value = entStates.StateName;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@StateID"] != null)
{
entStates.StateID = Convert.ToInt32(objCmd.Parameters["@StateID"].Value);
}
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(StatesENT entStates)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_States_UpdateByPK";
objCmd.Parameters.AddWithValue("@StateID", entStates.StateID);
objCmd.Parameters.AddWithValue("@CountryID", entStates.CountryID);
objCmd.Parameters.AddWithValue("@StateName", entStates.StateName);
#endregion Prepare Command
objCmd.ExecuteNonQuery();
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
private void fillControls(SqlInt32 StateID)
{
StatesENT entState = new StatesENT();
StatesBAL balState = new StatesBAL();
entState = balState.SelectByPK(StateID);
if (entState != null)
{
if (!entState.StateName.IsNull)
{
txtStateName.Text = entState.StateName.Value.ToString();
}
if (!entState.CountryID.IsNull)
{
ddlCountry.SelectedValue = entState.CountryID.Value.ToString();
}
}
else
{
lblError.Text = balState.Message;
}
}
