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