private void fillControls(SqlInt32 CityID)
{
CitiesENT entCity = new CitiesENT();
CitiesBAL balCity = new CitiesBAL();
entCity = balCity.SelectByPK(CityID);
if (entCity != null)
{
if (!entCity.CityName.IsNull)
{
txtCityName.Text = entCity.CityName.Value.ToString();
}
if (!entCity.Pincode.IsNull)
{
txtPincode.Text = entCity.Pincode.Value.ToString();
}
if (!entCity.STDCode.IsNull)
{
txtSTDCode.Text = entCity.STDCode.Value.ToString();
}
if (!entCity.StateID.IsNull)
{
ddlState.SelectedValue = entCity.StateID.Value.ToString();
}
}
else
{
lblError.Text = balCity.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
lblError.Text = "";
if (txtCityName.Text.Trim().ToUpper() == "")
{
lblError.Text += "Enter City Name <br/>";
}
if (ddlState.SelectedValue == "-1")
{
lblError.Text += "Please Select State <br/>";
}
if (lblError.Text != "")
{
return;
}
#endregion Server Side Validation
#region Collecting Data
CitiesENT entCity = new CitiesENT();
if (ddlState.SelectedValue != "-1" && txtCityName.Text.Trim().ToUpper() != "")
{
entCity.CityName = txtCityName.Text.Trim().ToUpper();
entCity.StateID = Convert.ToInt32(ddlState.SelectedValue);
entCity.Pincode = txtPincode.Text.Trim();
entCity.STDCode = txtSTDCode.Text.Trim();
}
CitiesBAL balCity = new CitiesBAL();
#endregion Collecting Data
if (Request.QueryString["CityID"] == null)
{
#region insertingData
if (balCity.Insert(entCity))
{
Response.Redirect("~/AdminPanel/City/CityList.aspx");
}
else
{
lblError.Text = balCity.Message;
}
#endregion insertingData
}
else
{
#region updatingData
entCity.CityID = Convert.ToInt32(Request.QueryString["CityID"]);
if (balCity.Update(entCity))
{
Response.Redirect("~/AdminPanel/City/CityList.aspx");
}
else
{
lblError.Text = balCity.Message;
}
#endregion updatingData
}
}
public Boolean Update(CitiesENT entCities)
{
CitiesDAL dalCities = new CitiesDAL();
if (dalCities.Update(entCities))
{
return(true);
}
else
{
Message = dalCities.Message;
return(false);
}
}
public Boolean Insert(CitiesENT entCities)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Cities_Insert";
objCmd.Parameters.Add("@CityID", SqlDbType.Int).Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("@CityName", SqlDbType.VarChar).Value = entCities.CityName;
objCmd.Parameters.AddWithValue("@Pincode", SqlDbType.VarChar).Value = entCities.Pincode;
objCmd.Parameters.AddWithValue("@STDCode", SqlDbType.VarChar).Value = entCities.STDCode;
objCmd.Parameters.AddWithValue("@StateID", SqlDbType.Int).Value = entCities.StateID;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@CityID"] != null)
{
entCities.CityID = Convert.ToInt32(objCmd.Parameters["@CityID"].Value);
}
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(CitiesENT entCities)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Cities_UpdateByPK";
objCmd.Parameters.AddWithValue("@CityID", entCities.CityID);
objCmd.Parameters.AddWithValue("@CityName", entCities.CityName);
objCmd.Parameters.AddWithValue("@Pincode", entCities.Pincode);
objCmd.Parameters.AddWithValue("@STDCode", entCities.STDCode);
objCmd.Parameters.AddWithValue("@StateID", entCities.StateID);
#endregion Prepare Command
objCmd.ExecuteNonQuery();
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public CitiesENT SelectByPK(SqlInt32 CitiesID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Cities_SelectByPK";
objCmd.Parameters.AddWithValue("@CitiesID", CitiesID);
#endregion Prepare Command
#region ReadData and Set Controls
CitiesENT entCities = new CitiesENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["CityID"].Equals(DBNull.Value))
{
entCities.CityID = Convert.ToInt32(objSDR["CityID"]);
}
if (!objSDR["CityName"].Equals(DBNull.Value))
{
entCities.CityName = Convert.ToString(objSDR["CityName"]);
}
if (!objSDR["Pincode"].Equals(DBNull.Value))
{
entCities.Pincode = Convert.ToString(objSDR["Pincode"]);
}
if (!objSDR["STDCode"].Equals(DBNull.Value))
{
entCities.STDCode = Convert.ToString(objSDR["STDCode"]);
}
if (!objSDR["StateID"].Equals(DBNull.Value))
{
entCities.StateID = Convert.ToInt32(objSDR["StateID"]);
}
}
}
return(entCities);
#endregion ReadData and Set Controls
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(null);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
