/// <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)); }