/// <summary> /// To fetch edtails /// </summary> /// <returns></returns> public CropDiameterList GetCropDiameter() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTCROPDIAMTR"; 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); CropDiameterBO objCropDiameter = null; CropDiameterList CropDiameterList = new CropDiameterList(); while (dr.Read()) { objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID"))); objCropDiameter.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER")); objCropDiameter.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CropDiameterList.Add(objCropDiameter); } dr.Close(); return(CropDiameterList); }
/// <summary> /// To fetch details and assign to textbox /// </summary> private void GetCropDiameterDetails() { CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); int CROPDIAMETERID = 0; if (ViewState["CropDiaMeterID"] != null) { CROPDIAMETERID = Convert.ToInt32(ViewState["CropDiaMeterID"]); } CropDiameterBO CropDiameterObj = new CropDiameterBO(); CropDiameterObj = CropDiameterBLLobj.GetCropDiameterById(CROPDIAMETERID); CropDiameterTextBox.Text = CropDiameterObj.CROPDIAMETER; CropDiameterIDTextBox.Text = CropDiameterObj.CROPDIAMETERID.ToString(); }
/// <summary> /// To EDIT Crop Diameter /// </summary> /// <param name="objCropDiameter"></param> /// <returns></returns> public string EDITCropDiameter(CropDiameterBO objCropDiameter) { CropDiameterDAL CropDiameterDAL = new CropDiameterDAL(); //Data pass -to Database Layer try { return(CropDiameterDAL.EDITCropDiameter(objCropDiameter)); } catch { throw; } finally { CropDiameterDAL = null; } }
/// <summary> /// To update details to database /// </summary> /// <param name="objCropDiameter"></param> /// <returns></returns> public string EDITCropDiameter(CropDiameterBO objCropDiameter) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECROPDIAMTR", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CROPDIAMETER_", objCropDiameter.CROPDIAMETER); dcmd.Parameters.Add("CROPDIAMETERID_", objCropDiameter.CROPDIAMETERID); dcmd.Parameters.Add("UpdatedBY", objCropDiameter.UserID); 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> /// get details by ID /// </summary> /// <param name="CROPDIAMETERID"></param> /// <returns></returns> public CropDiameterBO GetCropDiameterById(int CROPDIAMETERID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSECTCROPDIAMETRID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CROPDIAMETERID_", CROPDIAMETERID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropDiameterBO CropDiameterObj = null; CropDiameterList CropDiameterList = new CropDiameterList(); CropDiameterObj = new CropDiameterBO(); while (dr.Read()) { if (ColumnExists(dr, "CROPDIAMETER") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETER"))) { CropDiameterObj.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER")); } if (ColumnExists(dr, "CROPDIAMETERID") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETERID"))) { CropDiameterObj.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID"))); } if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CropDiameterObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CropDiameterObj); }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; int count = 0; if (CropDiameterIDTextBox.Text.ToString().Trim() == "0" || CropDiameterIDTextBox.Text.ToString().Trim() == string.Empty) { CropDiameterBLL CropDiameterBLLOBJ = new CropDiameterBLL(); try { string uID = Session["USER_ID"].ToString(); CropDiameterBO objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim(); objCropDiameter.UserID = Convert.ToInt32(uID); CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); message = CropDiameterBLLobj.InsertCropDiameter(objCropDiameter); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } CropDiameterIDTextBox.Text = "0"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { CropDiameterBLLOBJ = null; } BindGrid(); } //edit the data in the textbox exiting in the Grid else if (CropDiameterIDTextBox.Text.ToString().Trim() != string.Empty) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); CropDiameterBO objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim(); objCropDiameter.CROPDIAMETERID = Convert.ToInt32(CropDiameterIDTextBox.Text.ToString().Trim()); objCropDiameter.UserID = Convert.ToInt32(uID); CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); message = CropDiameterBLLobj.EDITCropDiameter(objCropDiameter); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; BindGrid(); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { concernBLLOBJ = null; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); }