/// <summary>
/// To get details from database
/// </summary>
/// <returns></returns>
public object GetAllCropDetails()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ALLCROPTYPES";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropTypeBO CropTypeBOObj = new CropTypeBO();
CropTypeList CropTypeListObj = new CropTypeList();
CropTypeBOObj = new CropTypeBO();
while (dr.Read())
{
CropTypeBOObj = new CropTypeBO();
CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE"));
//CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME"));
CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
CropTypeListObj.Add(CropTypeBOObj);
}
dr.Close();
return(CropTypeListObj);
}
/// <summary>
/// calls save method
/// </summary>
/// <returns></returns>
protected void btnSave_Click(object sender, EventArgs e)
{
CropTypeBO CropTypeBOObj = new CropTypeBO();
CropTypeBOObj.CropType = txtCropType.Text.ToString().Trim();
//CropTypeBOObj.UnitMeasure =Convert.ToInt32( ddlUnitOfmeasure.SelectedValue);
CropTypeBOObj.Createdby = Convert.ToInt32(Session["USER_ID"].ToString());
SaveCropTypeDetails(CropTypeBOObj);
ClearCropType();
}
/// <summary>
/// To get details by ID
/// </summary>
/// <param name="CROPTYPEID"></param>
/// <returns></returns>
public CropTypeBO GetCropTypeById(int CROPTYPEID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_CROPTYPE ";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("C_CROPTYPEID", CROPTYPEID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropTypeBO CropTypeBOObj = null;
CropTypeList CropTypeListObj = new CropTypeList();
CropTypeBOObj = new CropTypeBO();
while (dr.Read())
{
if (ColumnExists(dr, "CROPTYPEID") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPEID")))
{
CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
}
if (ColumnExists(dr, "CROPTYPE") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPE")))
{
CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE"));
}
//if (ColumnExists(dr, "UNITNAME") && !dr.IsDBNull(dr.GetOrdinal("UNITNAME")))
// CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME"));
if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(CropTypeBOObj);
}
/// <summary>
/// To fetch details and assign to textbox
/// </summary>
private void GetCropTypeDeatails()
{
CropTypeBO CropTypeBOObj = new CropTypeBO();
int CROPTYPEID = 0;
if (ViewState["CROPTYPEID"] != null)
{
CROPTYPEID = Convert.ToInt32(ViewState["CROPTYPEID"].ToString());
}
CropTypeBLL CropTypeBLLOBj = new CropTypeBLL();
CropTypeBOObj = CropTypeBLLOBj.GetCropTypeById(CROPTYPEID);
txtCropType.Text = CropTypeBOObj.CropType;
//ddlUnitOfmeasure.ClearSelection();
//if (ddlUnitOfmeasure.Items.FindByValue(CropTypeBOObj.UnitMeasure.ToString()) != null)
// ddlUnitOfmeasure.Items.FindByValue(CropTypeBOObj.UnitMeasure.ToString()).Selected = true;
txtCropTypeID.Text = CropTypeBOObj.CROPTYPEID.ToString();
}
/// <summary>
/// To save data to database
/// </summary>
/// <param name="CropTypeBOObj"></param>
/// <returns></returns>
public string InsertCropTypeDetails(CropTypeBO CropTypeBOObj)
{
string returnResult = "";
OracleConnection Con = new OracleConnection(AppConfiguration.ConnectionString);
Con.Open();
OracleCommand cmd = new OracleCommand("USP_MST_INSERT_CROPTYPE", Con);
cmd.CommandType = CommandType.StoredProcedure;
int Count = Convert.ToInt32(cmd.CommandType);
try
{
cmd.Parameters.Add("C_CROPTYPE", CropTypeBOObj.CropType);
//cmd.Parameters.Add("C_UnitId", CropTypeBOObj.UnitMeasure);
cmd.Parameters.Add("C_CREATEDBY", CropTypeBOObj.Createdby);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
return(returnResult);
}
catch (Exception ee)
{
throw ee;
}
finally
{
cmd.Dispose();
Con.Close();
Con.Dispose();
}
}
/// <summary>
/// To update data to database
/// </summary>
/// <param name="CropTypeBOObj"></param>
/// <param name="CROPTYPEID"></param>
/// <returns></returns>
public string EditCropTypeDetails(CropTypeBO CropTypeBOObj, int CROPTYPEID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPD_CROPTYPE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
string result = "";
try
{
dcmd.Parameters.Add("C_CROPTYPEID", CROPTYPEID);
dcmd.Parameters.Add("C_CROPTYPE", CropTypeBOObj.CropType);
//dcmd.Parameters.Add("C_UnitID", CropTypeBOObj.UnitMeasure);
dcmd.Parameters.Add("C_UPDATEDBY", CropTypeBOObj.Createdby);
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>
/// To save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveCropTypeDetails(CropTypeBO CropTypeBOObj)
{
string message = "";
if (txtCropTypeID.Text.ToString().Trim() == string.Empty)
{
try
{
CropTypeBOObj = new CropTypeBO();
CropTypeBLL CropTypeBLLObj = new CropTypeBLL();
CropTypeBOObj.CropType = txtCropType.Text.ToString().Trim();
CropTypeBOObj.CROPTYPEID = Convert.ToInt32(ViewState["CROPTYPEID"]);
//CropTypeBOObj.UnitMeasure= Convert.ToInt32(ddlUnitOfmeasure.SelectedValue);
CropTypeBOObj.Createdby = Convert.ToInt32(Session["USER_ID"].ToString());
message = CropTypeBLLObj.InsertCropTypeDetails(CropTypeBOObj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
BindGrid();
ClearCropType();
}
catch (Exception ex)
{
throw ex;
}
}
else
{
try
{
CropTypeBOObj = new CropTypeBO();
CropTypeBLL CropTypeBLLObj = new CropTypeBLL();
CropTypeBOObj.CropType = txtCropType.Text.ToString().Trim();
//CropTypeBOObj.UnitMeasure = Convert.ToInt32(ddlUnitOfmeasure.SelectedItem.Value);
int CROPTYPEID = Convert.ToInt32(ViewState["CROPTYPEID"]);
CropTypeBOObj.Createdby = Convert.ToInt32(Session["USER_ID"].ToString());
message = CropTypeBLLObj.EditCropTypeDetails(CropTypeBOObj, CROPTYPEID);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
BindGrid();
ClearCropType();
}
catch (Exception ex)
{
throw ex;
}
finally
{
CropTypeBOObj = null;
}
SetUpdateMode(false);
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
/// <summary>
/// To Edit Crop Type Details
/// </summary>
/// <param name="CropTypeBOObj"></param>
/// <param name="CROPTYPEID"></param>
/// <returns></returns>
public string EditCropTypeDetails(CropTypeBO CropTypeBOObj, int CROPTYPEID)
{
CropTypeDAL CropTypeDALObj = new CropTypeDAL();
return(CropTypeDALObj.EditCropTypeDetails(CropTypeBOObj, CROPTYPEID));
}
/// <summary>
/// To Insert Crop Type Details
/// </summary>
/// <param name="CropTypeBOObj"></param>
/// <returns></returns>
public string InsertCropTypeDetails(CropTypeBO CropTypeBOObj)
{
CropTypeDAL CropTypeDALObj = new CropTypeDAL();
return(CropTypeDALObj.InsertCropTypeDetails(CropTypeBOObj));
}
