/// <summary> /// To fetch details /// </summary> /// <returns></returns> public CropAgeList GetCropAge() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTCROPAGE"; 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); CropAgeBO objCropAge = null; CropAgeList CropAgeList = new CropAgeList(); while (dr.Read()) { objCropAge = new CropAgeBO(); objCropAge.CROPAGEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPAGEID"))); objCropAge.CROPAGE = dr.GetString(dr.GetOrdinal("CROPAGE")); objCropAge.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CropAgeList.Add(objCropAge); } dr.Close(); return(CropAgeList); }
/// <summary> /// To EDIT CROP AGE /// </summary> /// <param name="objCropAge"></param> /// <returns></returns> public string EDITCROPAGE(CropAgeBO objCropAge) { CropAgeDAL CropAgeDAL = new CropAgeDAL(); //Data pass -to Database Layer try { return(CropAgeDAL.EDITCROPAGE(objCropAge)); } catch { throw; } finally { CropAgeDAL = null; } }
/// <summary> /// To Insert Crop Age /// </summary> /// <param name="objCropAge"></param> /// <returns></returns> public string InsertCropAge(CropAgeBO objCropAge) { CropAgeDAL CropAgeDAL = new CropAgeDAL(); //Data pass -to Database Layer try { return(CropAgeDAL.InsertCropAge(objCropAge)); } catch { throw; } finally { CropAgeDAL = null; } }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetCropAgeDetails() { CropAgeBLL CropAgeBLLobj = new CropAgeBLL(); int CROPAGEID = 0; if (ViewState["CROPAGEID"] != null) { CROPAGEID = Convert.ToInt32(ViewState["CROPAGEID"]); } CropAgeBO CropAgeObj = new CropAgeBO(); CropAgeObj = CropAgeBLLobj.GetCropAgeById(CROPAGEID); CropAgeTextBox.Text = CropAgeObj.CROPAGE; CropAgeIDTextBox.Text = CropAgeObj.CROPAGEID.ToString(); //int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID); }
/// <summary> /// Get CropAge By Id /// </summary> /// <param name="CROPAGEID"></param> /// <returns></returns> public CropAgeBO GetCropAgeById(int CROPAGEID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTCROPAGEBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CROPAGEID_", CROPAGEID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropAgeBO CropAgeObj = null; CropAgeList CropAgeList = new CropAgeList(); CropAgeObj = new CropAgeBO(); while (dr.Read()) { if (ColumnExists(dr, "CROPAGE") && !dr.IsDBNull(dr.GetOrdinal("CROPAGE"))) { CropAgeObj.CROPAGE = dr.GetString(dr.GetOrdinal("CROPAGE")); } if (ColumnExists(dr, "CROPAGEID") && !dr.IsDBNull(dr.GetOrdinal("CROPAGEID"))) { CropAgeObj.CROPAGEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPAGEID"))); } if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CropAgeObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CropAgeObj); }
/// <summary> /// To update details to database /// </summary> /// <param name="objCropAge"></param> /// <returns></returns> public string EDITCROPAGE(CropAgeBO objCropAge) { string result = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECROPAGE", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CROPAGE_", objCropAge.CROPAGE); dcmd.Parameters.Add("CROPID_", objCropAge.CROPAGEID); dcmd.Parameters.Add("UpdatedBY", objCropAge.UserID); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { result = dcmd.Parameters["errorMessage_"].Value.ToString(); } } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(result); }
/// <summary> /// save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; int count = 0; if (ViewState["CROPAGEID"].ToString() == "0") { CropAgeBLL CropAgeBLLOBJ = new CropAgeBLL(); try { string uID = Session["USER_ID"].ToString(); CropAgeBO objCropAge = new CropAgeBO(); objCropAge.CROPAGE = CropAgeTextBox.Text.ToString().Trim(); objCropAge.UserID = Convert.ToInt32(uID); CropAgeBLL CropAgeBLLLobj = new CropAgeBLL(); message = CropAgeBLLLobj.InsertCropAge(objCropAge); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } CropAgeIDTextBox.Text = "0"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { CropAgeBLLOBJ = null; } } else if (Convert.ToInt32(ViewState["CROPAGEID"].ToString()) > 0) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); CropAgeBO objCropAge = new CropAgeBO(); objCropAge.CROPAGE = CropAgeTextBox.Text.ToString().Trim(); objCropAge.CROPAGEID = Convert.ToInt32(ViewState["CROPAGEID"].ToString()); objCropAge.UserID = Convert.ToInt32(uID); CropAgeBLL CropAgeBLLobj = new CropAgeBLL(); message = CropAgeBLLobj.EDITCROPAGE(objCropAge); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { concernBLLOBJ = null; } } SetUpdateMode(false); ClearData(); BindGrid(true, true); }