/// <summary> /// To insert data to database /// </summary> /// <param name="objCRBO"></param> /// <returns></returns> public string AddCropRate(CropRateBO objCRBO) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); string result = ""; OracleCommand myCommand; myCommand = new OracleCommand("USP_MST_INS_CROPRATE", con); myCommand.Connection = con; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("CROPID_", objCRBO.CropID); myCommand.Parameters.Add("DISTRICTID_", objCRBO.DistrictID); myCommand.Parameters.Add("CROPDESCRIPTIONID_", objCRBO.CropDescriptionID); myCommand.Parameters.Add("CROPRATE_", objCRBO.CropRate); myCommand.Parameters.Add("CREATEDBY_", objCRBO.CreatedBy); myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; con.Open(); myCommand.ExecuteNonQuery(); if (myCommand.Parameters["errorMessage_"].Value != null) { result = myCommand.Parameters["errorMessage_"].Value.ToString(); } con.Close(); return(result); }
public static string[] GetUnitName(string Units) { string[] Ids = Units.Split('|'); int cropID = Convert.ToInt32(Ids[0]); int CropDesID = Convert.ToInt32(Ids[1]); CropNameBLL objCropNameBLL = new CropNameBLL(); CropNameBO objCropname = objCropNameBLL.GetCropNameById(cropID); string[] arrCrop = { "", "" }; string unitMeasureName = ""; string cropRate = ""; CropRateBLL objCropRateBLL = new CropRateBLL(); CropRateBO objCropRateBO = objCropRateBLL.GetCropRateByDistrict(cropID, CropDesID, Convert.ToInt32(HttpContext.Current.Session["HH_ID"])); if (objCropname != null) { unitMeasureName = objCropname.UnitName; if (objCropRateBO != null) { cropRate = objCropRateBO.CropRate; } } arrCrop[0] = unitMeasureName; arrCrop[1] = cropRate; return(arrCrop); }
/// <summary> /// To get details from database /// </summary> /// <param name="cropID"></param> /// <param name="CropDesID"></param> /// <param name="householdID"></param> /// <returns></returns> public CropRateBO GetCropRateByDistrict(int cropID, int CropDesID, int householdID) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_CROPRATEBYDISTRICT"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CROPID", cropID); cmd.Parameters.Add("CROPDESCRIPTIONID_", CropDesID); cmd.Parameters.Add("HHID", householdID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropRateBO objCRBO = null; while (dr.Read()) { objCRBO = new CropRateBO(); objCRBO.CropRateID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPRATEID")))); objCRBO.CropRate = dr.GetValue(dr.GetOrdinal("CROPRATE")).ToString(); } dr.Close(); return(objCRBO); }
/// <summary> /// to fetch details from database /// </summary> /// <param name="cropid"></param> /// <returns></returns> public CropRateList GetCropRate(int cropid) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_CROPRATE"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("cropid_", cropid); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropRateBO objCRBO = null; CropRateList objCRList = new CropRateList(); while (dr.Read()) { objCRBO = new CropRateBO(); objCRBO.CropRateID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPRATEID")))); objCRBO.CropID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPID")))); objCRBO.DistrictName = (Convert.ToString(dr.GetValue(dr.GetOrdinal("DISTRICTNAME")))); objCRBO.CropDescription = (Convert.ToString(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTION")))); objCRBO.CropRate = dr.GetValue(dr.GetOrdinal("CROPRATE")).ToString(); objCRBO.IsDeleted = dr.GetValue(dr.GetOrdinal("ISDELETED")).ToString(); objCRList.Add(objCRBO); } dr.Close(); return(objCRList); }
/// <summary> /// To Add Crop Rate /// </summary> /// <param name="objCRBO"></param> /// <returns></returns> public string AddCropRate(CropRateBO objCRBO) { CropRateDAL objCRDAL = new CropRateDAL(); return(objCRDAL.AddCropRate(objCRBO)); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { CropRateBO objCRBO = new CropRateBO(); CropRateBLL objCRBLL = new CropRateBLL(); grdCropRate.DataSource = objCRBLL.GetCropRate(Convert.ToInt32(ViewState["CROPID"])); grdCropRate.DataBind(); }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click1(object sender, EventArgs e) { string message = ""; CropRateBO objCRBO = new CropRateBO(); objCRBO.CropRateID = int.Parse(ViewState["CROPRATEID"].ToString()); objCRBO.CropID = int.Parse(ViewState["CROPID"].ToString()); objCRBO.DistrictID = Convert.ToInt32(ddlDistrict.SelectedItem.Value); objCRBO.CropDescriptionID = Convert.ToInt32(ddlCropDescription.SelectedItem.Value); objCRBO.CropRate = txtCropRate.Text.Trim(); CropRateBLL objCRBLL = new CropRateBLL(); if (objCRBO.CropRateID == 0) { objCRBO.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objCRBLL.AddCropRate(objCRBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } else { objCRBO.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = objCRBLL.UpdateCropRate(objCRBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true); } SetUpdateMode(false); } ClearDetails(); BindGrid(); }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdCropRate_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["CROPRATEID"] = e.CommandArgument; CropRateBO objCRBO = new CropRateBO(); CropRateBLL objCRBLL = new CropRateBLL(); objCRBO = objCRBLL.GetCropRateByID(Convert.ToInt32(ViewState["CROPRATEID"])); if (objCRBO != null) { txtCropRate.Text = objCRBO.CropRate; ddlDistrict.ClearSelection(); if (ddlDistrict.Items.FindByValue(objCRBO.DistrictID.ToString()) != null) { ddlDistrict.Items.FindByValue(objCRBO.DistrictID.ToString()).Selected = true; } ddlCropDescription.ClearSelection(); if (ddlCropDescription.Items.FindByValue(objCRBO.CropDescriptionID.ToString()) != null) { ddlCropDescription.Items.FindByValue(objCRBO.CropDescriptionID.ToString()).Selected = true; } } SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { string message = string.Empty; CropRateBLL objCRBLL = new CropRateBLL(); message = objCRBLL.DeleteCropRate(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearDetails(); BindGrid(); } }
/// <summary> /// To Update Crop Rate /// </summary> /// <param name="objCRBO"></param> /// <returns></returns> public string UpdateCropRate(CropRateBO objCRBO) { CropRateDAL objCRDAL = new CropRateDAL(); return(objCRDAL.UpdateCropRate(objCRBO)); }