/// <summary>
/// To update details to database
/// </summary>
/// <param name="objCountyBO"></param>
/// <returns></returns>
public string UpdateCounty(CountyBO objCountyBO)
{
string result = "";
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_UPD_COUNTY", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("COUNTYID_", objCountyBO.CountyID);
cmd.Parameters.Add("COUNTYNAME_", objCountyBO.CountyName);
cmd.Parameters.Add("UPDATEDBY_", objCountyBO.UpdatedBy);
cmd.Parameters.Add("ERRORMESSAGE_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["ERRORMESSAGE_"].Value != null)
{
result = cmd.Parameters["ERRORMESSAGE_"].Value.ToString();
}
cmd.Connection.Close();
}
}
return(result);
}
/// <summary>
/// To fetch details
/// </summary>
/// <param name="districtID"></param>
/// <returns></returns>
public CountyList GetCounty(string districtID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_COUNTY";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DISTRICTID_", districtID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objcountBO = null;
CountyList objcountlist = new CountyList();
while (dr.Read())
{
objcountBO = new CountyBO();
objcountBO.CountyID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("COUNTYID"))));
objcountBO.CountyName = dr.GetValue(dr.GetOrdinal("COUNTYNAME")).ToString();
objcountlist.Add(objcountBO);
}
dr.Close();
return(objcountlist);
}
/// <summary>
/// To fetch details
/// </summary>
/// <param name="districtID"></param>
/// <returns></returns>
public CountyList GetAllCounties(int districtID)
{
CountyList objCountyList = null;
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_GET_COUNTY_ALL", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DistrictIDIN", districtID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objCountyBO = null;
objCountyList = new CountyList();
while (dr.Read())
{
objCountyBO = new CountyBO();
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYID")))
{
objCountyBO.CountyID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("COUNTYID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYNAME")))
{
objCountyBO.CountyName = dr.GetValue(dr.GetOrdinal("COUNTYNAME")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objCountyBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
objCountyBO.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
// if (!dr.IsDBNull(dr.GetOrdinal("districtid"))) objCountyBO.DistrictID =Convert.ToInt32( dr.GetString(dr.GetOrdinal("districtid")));
objCountyList.Add(objCountyBO);
}
dr.Close();
}
}
return(objCountyList);
}
/// <summary>
/// to update data to database
/// </summary>
/// <returns></returns>
private void UpdateCounty()
{
CountyBLL CountyBLLobj = new CountyBLL();
CountyBO CountyBOobj = new CountyBO();
string message = "";
try
{
if (ViewState["COUNTYID"] != null)
{
CountyBOobj.CountyID = Convert.ToInt32(ViewState["COUNTYID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
CountyBOobj.DistrictID = Convert.ToInt32(ddlDistrictName.SelectedItem.Value);
CountyBOobj.CountyName = txtCounty.Text.Trim();
CountyBOobj.UpdatedBy = Convert.ToInt32(uID);
message = CountyBLLobj.UpdateCounty(CountyBOobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
ClearData();
SetUpdateMode(false);
BindGrid();
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
CountyBLLobj = null;
}
}
/// <summary>
/// to get county names based on ID
/// </summary>
/// <returns></returns>
private void GetCountyById()
{
CountyBLL CountyBLLobj = new CountyBLL();
CountyBO CountyBOobj = CountyBLLobj.GetCountyById(Convert.ToInt32(ViewState["COUNTYID"]));
if (CountyBOobj != null)
{
txtCounty.Text = CountyBOobj.CountyName;
}
ddlDistrictName.ClearSelection();
if (ddlDistrictName.Items.FindByText(CountyBOobj.DistrictName.ToString()) != null)
{
ddlDistrictName.Items.FindByText(CountyBOobj.DistrictName.ToString()).Selected = true;
}
CountyBOobj = null;
CountyBLLobj = null;
}
/// <summary>
/// To get details
/// </summary>
/// <param name="County"></param>
/// <returns></returns>
public CountyList GetCounties(string County)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SER_COUNTY";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("COUNTYNAME_", County);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objcountBO = null;
CountyList objcountlist = new CountyList();
while (dr.Read())
{
objcountBO = new CountyBO();
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYID")))
{
objcountBO.CountyID = dr.GetInt32(dr.GetOrdinal("COUNTYID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DISTRICTID")))
{
objcountBO.DistrictID = dr.GetInt32(dr.GetOrdinal("DISTRICTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYNAME")))
{
objcountBO.CountyName = dr.GetString(dr.GetOrdinal("COUNTYNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objcountBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
objcountBO.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
objcountlist.Add(objcountBO);
}
dr.Close();
return(objcountlist);
}
/// <summary>
/// To get details by ID
/// </summary>
/// <param name="countyID"></param>
/// <returns></returns>
public CountyBO GetCountyById(int countyID)
{
proc = "USP_MST_GET_COUNTYBYID";
cnn = new OracleConnection(connStr);
CountyBO CountyBOobj = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("COUNTYID_", countyID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
CountyBOobj = new CountyBO();
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYID")))
{
CountyBOobj.CountyID = dr.GetInt32(dr.GetOrdinal("COUNTYID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYNAME")))
{
CountyBOobj.CountyName = dr.GetString(dr.GetOrdinal("COUNTYNAME"));
}
//if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) CountyBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
CountyBOobj.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(CountyBOobj);
}
/// <summary>
/// to save data to database
/// </summary>
/// <returns></returns>
private void SaveCounty()
{
CountyBLL CountyBLLobj = new CountyBLL();
CountyBO CountyBOobj = new CountyBO();
string message = "";
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
CountyBOobj.DistrictID = Convert.ToInt32(ddlDistrictName.SelectedItem.Value);
CountyBOobj.CountyName = txtCounty.Text.Trim();
CountyBOobj.CreatedBy = Convert.ToInt32(uID);
try
{
message = CountyBLLobj.AddCounty(CountyBOobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearData();
BindGrid();
}
catch (Exception ee)
{
throw ee;
}
finally
{
CountyBLLobj = null;
}
}
public CountyList LoadCountyData(string pDstrictId)
{
cnn = new OracleConnection(AppConfiguration.ConnectionString);
string proc = "USP_MST_GET_COUNTY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DistrictIDIN", pDstrictId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO obMaster = null;
CountyList Master = new CountyList();
while (dr.Read())
{
obMaster = new CountyBO();
obMaster.CountyID = dr.GetInt32(dr.GetOrdinal("COUNTYID"));
obMaster.CountyName = dr.GetString(dr.GetOrdinal("COUNTYNAME"));
Master.Add(obMaster);
}
dr.Close();
return(Master);
}
/// <summary>
/// converts a county data object to a county business object
/// </summary>
/// <param name="county"></param>
/// <returns></returns>
private CountyBO GetCounty(CountyDO county)
{
CountyBO bo = new CountyBO() { CountyID = county.CountyID, Description = county.Description, PermitKey = PermitKey };
if (SelectedCounties.Find(c => c.CountyID == bo.CountyID) != null) // is this county in the Selected counties list?
bo.Selected = true;
return bo;
}
/// <summary>
/// To Update County
/// </summary>
/// <param name="CountyBOobj"></param>
/// <returns></returns>
public string UpdateCounty(CountyBO CountyBOobj)
{
return((new CountyDAL()).UpdateCounty(CountyBOobj));
}
/// <summary>
/// To Add County
/// </summary>
/// <param name="CountyBOobj"></param>
/// <returns></returns>
public string AddCounty(CountyBO CountyBOobj)
{
return((new CountyDAL()).AddCounty(CountyBOobj));
}
