/// <summary>
/// To fetch details
/// </summary>
/// <param name="districtID"></param>
/// <returns></returns>
public MaxCapList GetMaxCapByDist(string districtID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_MAXCAP";
cmd = new OracleCommand(proc, con);
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);
MaxCapBO objcountBO = null;
MaxCapList objcountlist = new MaxCapList();
while (dr.Read())
{
objcountBO = new MaxCapBO();
objcountBO.MaxCapID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MAXCAPCROPDISTID"))));
objcountBO.MaxCapVal = dr.GetDecimal(dr.GetOrdinal("MAXCAPSTNDRDRATE"));
objcountlist.Add(objcountBO);
}
dr.Close();
return(objcountlist);
}
/// <summary>
/// To update details to database
/// </summary>
/// <param name="objMaxCapBO"></param>
/// <returns></returns>
public string UpdateMaxCap(MaxCapBO objMaxCapBO)
{
string result = "";
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_UPD_MAXCAP", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("MAXCAPID_", objMaxCapBO.MaxCapID);
cmd.Parameters.Add("DISTRICTID_", objMaxCapBO.DistrictID);
cmd.Parameters.Add("MAXCAPVAL_", objMaxCapBO.MaxCapVal);
cmd.Parameters.Add("PROJECTID_", objMaxCapBO.ProjectID);
cmd.Parameters.Add("UPDATEDBY_", objMaxCapBO.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 MaxCapList GetAllMaxCap(int ProjectId)
{
MaxCapList objCountyList = null;
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_GET_MAXCAP_ALL", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTID_", ProjectId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
MaxCapBO objMaxCapBO = null;
objCountyList = new MaxCapList();
while (dr.Read())
{
objMaxCapBO = new MaxCapBO();
if (!dr.IsDBNull(dr.GetOrdinal("MAXCAPCROPDISTID")))
{
objMaxCapBO.MaxCapID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MAXCAPCROPDISTID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("MAXCAPSTNDRDRATE")))
{
objMaxCapBO.MaxCapVal = dr.GetDecimal(dr.GetOrdinal("MAXCAPSTNDRDRATE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objMaxCapBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
objMaxCapBO.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
// if (!dr.IsDBNull(dr.GetOrdinal("districtid"))) objMaxCapBO.DistrictID =Convert.ToInt32( dr.GetString(dr.GetOrdinal("districtid")));
objCountyList.Add(objMaxCapBO);
}
dr.Close();
}
}
return(objCountyList);
}
/// <summary>
/// to update data to database
/// </summary>
/// <returns></returns>
private void UpdateDistrict()
{
MaxCapBLL DistrictBLLobj = new MaxCapBLL();
MaxCapBO DistrictBOobj = new MaxCapBO();
string message = "";
try
{
if (ViewState["MAXCAPID"] != null)
{
DistrictBOobj.MaxCapID = Convert.ToInt32(ViewState["MAXCAPID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
DistrictBOobj.DistrictID = Convert.ToInt32(ddlDistrictName.SelectedItem.Value);
DistrictBOobj.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
DistrictBOobj.MaxCapVal = Convert.ToDecimal(txtMaxCap.Text.Trim());
DistrictBOobj.UpdatedBy = Convert.ToInt32(uID);
message = DistrictBLLobj.UpdateMaxCap(DistrictBOobj);
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
{
DistrictBLLobj = null;
}
}
/// <summary>
/// to get District names based on ID
/// </summary>
/// <returns></returns>
private void GetDistrictById()
{
MaxCapBLL DistrictBLLobj = new MaxCapBLL();
MaxCapBO DistrictBOobj = DistrictBLLobj.GetMaxCapById(Convert.ToInt32(ViewState["MAXCAPID"]));
if (DistrictBOobj != null)
{
txtMaxCap.Text = Convert.ToString(DistrictBOobj.MaxCapVal);
}
ddlDistrictName.ClearSelection();
if (ddlDistrictName.Items.FindByText(DistrictBOobj.DistrictName.ToString()) != null)
{
ddlDistrictName.Items.FindByText(DistrictBOobj.DistrictName.ToString()).Selected = true;
}
DistrictBOobj = null;
DistrictBLLobj = null;
}
/// <summary>
/// To get details
/// </summary>
/// <param name="MaxCap"></param>
/// <returns></returns>
public MaxCapList GetMaxCap(string MaxCap)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SER_MAXCAP";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("MAXCAPVAL_", MaxCap);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
MaxCapBO objcountBO = null;
MaxCapList objcountlist = new MaxCapList();
while (dr.Read())
{
objcountBO = new MaxCapBO();
if (!dr.IsDBNull(dr.GetOrdinal("MAXCAPCROPDISTID")))
{
objcountBO.MaxCapID = dr.GetInt32(dr.GetOrdinal("MAXCAPCROPDISTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DISTRICTID")))
{
objcountBO.DistrictID = dr.GetInt32(dr.GetOrdinal("DISTRICTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MAXCAPSTNDRDRATE")))
{
objcountBO.MaxCapVal = dr.GetDecimal(dr.GetOrdinal("MAXCAPSTNDRDRATE"));
}
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="maxCapID"></param>
/// <returns></returns>
public MaxCapBO GetMaxCapById(int maxCapID)
{
proc = "USP_MST_GET_MAXCAPBYID";
cnn = new OracleConnection(connStr);
MaxCapBO CountyBOobj = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("MAXCAPID_", maxCapID);
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 MaxCapBO();
if (!dr.IsDBNull(dr.GetOrdinal("maxcapcropdistid")))
{
CountyBOobj.MaxCapID = dr.GetInt32(dr.GetOrdinal("maxcapcropdistid"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MAXCAPSTNDRDRATE")))
{
CountyBOobj.MaxCapVal = dr.GetDecimal(dr.GetOrdinal("MAXCAPSTNDRDRATE"));
}
//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 Update County
/// </summary>
/// <param name="CountyBOobj"></param>
/// <returns></returns>
public string UpdateMaxCap(MaxCapBO CountyBOobj)
{
return((new MaxCapDAL()).UpdateMaxCap(CountyBOobj));
}
/// <summary>
/// To Add County
/// </summary>
/// <param name="CountyBOobj"></param>
/// <returns></returns>
public string AddMaxCap(MaxCapBO CountyBOobj)
{
return((new MaxCapDAL()).AddMaxCap(CountyBOobj));
}
