/// <summary>
/// GetCropDescription
/// </summary>
/// <returns></returns>
public CropDescriptionList GetCropDescription()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SELECTCROPDESCRIPTION";
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);
CropDescriptionBO objCropDescription = null;
CropDescriptionList CropDescriptionList = new CropDescriptionList();
while (dr.Read())
{
objCropDescription = new CropDescriptionBO();
objCropDescription.CROPDESID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID")));
objCropDescription.CROPDESNAME = dr.GetString(dr.GetOrdinal("CROPDESCRIPTION"));
objCropDescription.CROPDESISDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
objCropDescription.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
CropDescriptionList.Add(objCropDescription);
}
dr.Close();
return(CropDescriptionList);
}
/// <summary>
/// To EDIT Crop Descr
/// </summary>
/// <param name="objCropDesc"></param>
/// <returns></returns>
public string EDITCropDescr(CropDescriptionBO objCropDesc)
{
CropDescriptionDAL CropDescriptionDAL = new CropDescriptionDAL(); //Data pass -to Database Layer
try
{
return(CropDescriptionDAL.EDITCropDescr(objCropDesc));
}
catch
{
throw;
}
finally
{
CropDescriptionDAL = null;
}
}
/// <summary>
/// To fetch details and assign to textbox
/// </summary>
private void GetOCCUPATIONDetails()
{
CropDescriptionBLL CropDescriptionBLLobj = new CropDescriptionBLL();
int CROPDESCRIPTIONID = 0;
if (ViewState["CROPDESID"] != null)
{
CROPDESCRIPTIONID = Convert.ToInt32(ViewState["CROPDESID"]);
}
CropDescriptionBO CropDescriptionObj = new CropDescriptionBO();
CropDescriptionObj = CropDescriptionBLLobj.GetCropDescriptionId(CROPDESCRIPTIONID);
CropDescriptionTextBox.Text = CropDescriptionObj.CROPDESNAME;
CropDescriptionIDTextBox.Text = CropDescriptionObj.CROPDESID.ToString();
}
/// <summary>
/// To update details to database
/// </summary>
/// <param name="objCropDesc"></param>
/// <returns></returns>
public string EDITCropDescr(CropDescriptionBO objCropDesc)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECROPDESC", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("CROPNAME_", objCropDesc.CROPDESNAME);
dcmd.Parameters.Add("CROPID_", objCropDesc.CROPDESID);
dcmd.Parameters.Add("UpdatedBY", objCropDesc.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>
/// to get details by ID
/// </summary>
/// <param name="CROPDESCRIPTIONID"></param>
/// <returns></returns>
public CropDescriptionBO GetCropDescriptionId(int CROPDESCRIPTIONID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETSELECTCROPDESC";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CROPDESCRIPTIONID_", CROPDESCRIPTIONID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropDescriptionBO CropDescriptionObj = null;
CropDescriptionList CropDescriptionList = new CropDescriptionList();
CropDescriptionObj = new CropDescriptionBO();
while (dr.Read())
{
if (ColumnExists(dr, "CROPDESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTION")))
{
CropDescriptionObj.CROPDESNAME = dr.GetString(dr.GetOrdinal("CROPDESCRIPTION"));
}
if (ColumnExists(dr, "CROPDESCRIPTIONID") && !dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTIONID")))
{
CropDescriptionObj.CROPDESID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID")));
}
if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
CropDescriptionObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(CropDescriptionObj);
}
/// <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 (CropDescriptionIDTextBox.Text.ToString().Trim() == "0")
{
CropDescriptionBLL CropDescriptionBLLOBJ = new CropDescriptionBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropDescriptionBO objCropDescription = new CropDescriptionBO();
objCropDescription.CROPDESNAME = CropDescriptionTextBox.Text.ToString().Trim();
objCropDescription.UserID = Convert.ToInt32(uID);
CropDescriptionBLL CropDescriptionBLLobj = new CropDescriptionBLL();
message = CropDescriptionBLLobj.InsertCropDescription(objCropDescription);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
CropDescriptionIDTextBox.Text = "0";
BindGrid();
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
CropDescriptionBLLOBJ = null;
}
}
//edit the data in the textbox exiting in the Grid
else if (CropDescriptionIDTextBox.Text.ToString().Trim() != string.Empty)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropDescriptionBO objCropDesc = new CropDescriptionBO();
objCropDesc.CROPDESNAME = CropDescriptionTextBox.Text.ToString().Trim();
objCropDesc.CROPDESID = Convert.ToInt32(CropDescriptionIDTextBox.Text.ToString().Trim());
objCropDesc.UserID = Convert.ToInt32(uID);
CropDescriptionBLL CropDescriptionBLLobj = new CropDescriptionBLL();
message = CropDescriptionBLLobj.EDITCropDescr(objCropDesc);
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();
}
