/// <summary> /// To Get All Land Received /// </summary> /// <returns></returns> public LandReceivedMSTList GetAllLandReceived() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTLANDRECDALL"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LandReceivedMSTBO objLandReceived = null; LandReceivedMSTList LandReceivedMSTList = new LandReceivedMSTList(); while (dr.Read()) { objLandReceived = new LandReceivedMSTBO(); objLandReceived.LandReceivedID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LANDRECDFROMID"))); objLandReceived.LandReceived = dr.GetString(dr.GetOrdinal("LANDRECDFROM")); objLandReceived.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); LandReceivedMSTList.Add(objLandReceived); } dr.Close(); return(LandReceivedMSTList); }
/// <summary> /// To EDIT LAND RECEIVED /// </summary> /// <param name="LandReceivedMSTBOObj"></param> /// <returns></returns> public string EDITLANDRECEIVED(LandReceivedMSTBO LandReceivedMSTBOObj) { LandReceivedMSTDAL LandReceivedMSTDALOBJ = new LandReceivedMSTDAL(); //Data pass -to Database Layer try { return(LandReceivedMSTDALOBJ.EDITLANDRECEIVED(LandReceivedMSTBOObj)); } catch { throw; } finally { LandReceivedMSTDALOBJ = null; } }
/// <summary> /// To Insert Land Received /// </summary> /// <param name="LandReceivedMSTBOObj"></param> /// <returns></returns> public string InsertLandReceived(LandReceivedMSTBO LandReceivedMSTBOObj) { LandReceivedMSTDAL LandReceivedMSTDAL = new LandReceivedMSTDAL(); //Data pass -to Database Layer try { return(LandReceivedMSTDAL.InsertLandReceived(LandReceivedMSTBOObj)); } catch { throw; } finally { LandReceivedMSTDAL = null; } }
public string EDITLANDRECEIVED(LandReceivedMSTBO LandReceivedMSTBOObj) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATELANDRECDFROM", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("LandReceived_", LandReceivedMSTBOObj.LandReceived); dcmd.Parameters.Add("LandReceivedID_", LandReceivedMSTBOObj.LandReceivedID); dcmd.Parameters.Add("UpdatedBY", LandReceivedMSTBOObj.UserID); //return dcmd.ExecuteNonQuery(); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(returnResult); }
/// <summary> ///To fetch details from database based on ID /// </summary private void GetLandReceivedByID() { LandReceivedMSTBLL LandReceivedMSTOBJ = new LandReceivedMSTBLL(); int LandReceivedID = 0; if (ViewState["LandReceivedID"] != null) { LandReceivedID = Convert.ToInt32(ViewState["LandReceivedID"]); } LandReceivedMSTBO LandReceivedObj = new LandReceivedMSTBO(); LandReceivedObj = LandReceivedMSTOBJ.GetLandReceivedByID(LandReceivedID); txtLandReceived.Text = LandReceivedObj.LandReceived; txtLandReceivedID.Text = LandReceivedObj.LandReceivedID.ToString(); }
//get the data in mst_Concern table using USP_MST_GETSELECTCONCERN-SP signal Data based on ID public LandReceivedMSTBO GetLandReceivedByID(int LandReceivedID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTLANDRECD"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("LandReceivedID_", LandReceivedID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LandReceivedMSTBO LandReceivedMSTBOObj = null; LandReceivedMSTList LandReceivedMSTList = new LandReceivedMSTList(); LandReceivedMSTBOObj = new LandReceivedMSTBO(); while (dr.Read()) { if (ColumnExists(dr, "LANDRECDFROM") && !dr.IsDBNull(dr.GetOrdinal("LANDRECDFROM"))) { LandReceivedMSTBOObj.LandReceived = dr.GetString(dr.GetOrdinal("LANDRECDFROM")); } if (ColumnExists(dr, "LANDRECDFROMID") && !dr.IsDBNull(dr.GetOrdinal("LANDRECDFROMID"))) { LandReceivedMSTBOObj.LandReceivedID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LANDRECDFROMID"))); } if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { LandReceivedMSTBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(LandReceivedMSTBOObj); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; LandReceivedMSTBLL LandReceivedMSTOBJ = new LandReceivedMSTBLL(); LandReceivedMSTBO LandReceivedMSTBOObj = new LandReceivedMSTBO(); int uID = Convert.ToInt32(Session["USER_ID"].ToString()); if (txtLandReceivedID.Text.ToString().Trim() == string.Empty) { try { LandReceivedMSTBOObj.LandReceived = txtLandReceived.Text.ToString().Trim(); LandReceivedMSTBOObj.UserID = uID; message = LandReceivedMSTOBJ.InsertLandReceived(LandReceivedMSTBOObj); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); Clear(); BindGrid(); } } catch (Exception ex) { throw ex; } finally { LandReceivedMSTOBJ = null; } } else { try { LandReceivedMSTBOObj.LandReceived = txtLandReceived.Text.ToString().Trim(); LandReceivedMSTBOObj.LandReceivedID = Convert.ToInt32(txtLandReceivedID.Text.ToString().Trim()); LandReceivedMSTBOObj.UserID = Convert.ToInt32(uID); message = LandReceivedMSTOBJ.EDITLANDRECEIVED(LandReceivedMSTBOObj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); Clear(); SetUpdateMode(false); BindGrid(); } } catch (Exception ex) { throw ex; } finally { LandReceivedMSTOBJ = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }