protected void grdDescription_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["DescriptionID"] = Convert.ToInt32(e.CommandArgument); int desID = Convert.ToInt32(ViewState["DescriptionID"]); DescriptionBLL objDescriptionBLL = new DescriptionBLL(); DescriptionBO objdesc = new DescriptionBO(); objdesc = objDescriptionBLL.GetAllDescriptionDetailsByID(desID); ddlparam.SelectedValue = Convert.ToString(objdesc.ParameterID); ddloptionAvailable.SelectedValue = Convert.ToString(objdesc.OptionAvailID); txtDescription.Text = objdesc.Description; btnSave.Text = "Update"; btnClear.Text = "Cancel"; ddlparam.Enabled = true; } else if (e.CommandName == "DeleteRow") { string result = ""; ViewState["DescriptionDelID"] = Convert.ToInt32(e.CommandArgument); int desID = Convert.ToInt32(ViewState["DescriptionDelID"]); DescriptionBLL objDescriptionBLL = new DescriptionBLL(); DescriptionBO objdesc = new DescriptionBO(); result = objDescriptionBLL.DeleteDescription(desID); if (string.IsNullOrEmpty(result) || result == "" || result == "null") { result = "Data deleted successfully"; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + result + "');", true); bindGrid(); } }
public DescriptionList GetOptionAvail() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_OPTIONAVAIL"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DescriptionBO DescriptionBO = null; DescriptionList objDescriptionList = new DescriptionList(); while (dr.Read()) { DescriptionBO = new DescriptionBO(); DescriptionBO.OptionID = dr.GetInt32(dr.GetOrdinal("ID")); DescriptionBO.OptionAvailablename = dr.GetValue(dr.GetOrdinal("OPTIONAVAILABLE")).ToString(); objDescriptionList.Add(DescriptionBO); } dr.Close(); return(objDescriptionList); }
public string UpdateDesription(DescriptionBO objDescription) { string result = ""; using (cnn = new OracleConnection(connStr)) { using (cmd = new OracleCommand("USP_UPD_PARAM_OPTION", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("DESCRIPTIONID_", objDescription.DescriptionID); cmd.Parameters.Add("PARAMETERID_", objDescription.ParameterID); cmd.Parameters.Add("OPTIONAVAILABLEID_", objDescription.OptionAvailID); cmd.Parameters.Add("DESCRIPTION_", objDescription.Description); cmd.Parameters.Add("CREATEDBY_", objDescription.CreatedBy); cmd.Parameters.Add("ERRORMESSAGE_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["ERRORMESSAGE_"].Value != null) { result = cmd.Parameters["ERRORMESSAGE_"].Value.ToString(); } cmd.Connection.Close(); } } return(result); }
public ActionResult TestData(ProductBO product) { DescriptionBO descript = new DescriptionBO(); descript.Size = product.Size; descript.UnitPrice = product.UnitPrice; descript.QualityType = product.QualityType; descript.Discount = product.Discount; product.DescriptionBO.Add(descript); return(PartialView("Descript", product)); }
public DescriptionList GetAllDescriptionDetails() { DescriptionList objDescList = null; using (cnn = new OracleConnection(connStr)) { using (cmd = new OracleCommand("USP_OPTION_PARAM_DATA_GRID", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DescriptionBO objDescriptionBO = null; objDescList = new DescriptionList(); while (dr.Read()) { objDescriptionBO = new DescriptionBO(); if (!dr.IsDBNull(dr.GetOrdinal("PARAMETERNAME"))) { objDescriptionBO.ParameterName = dr.GetValue(dr.GetOrdinal("PARAMETERNAME")).ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("OPTIONAVAILABLE"))) { objDescriptionBO.OptionAvailablename = dr.GetValue(dr.GetOrdinal("OPTIONAVAILABLE")).ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("DESCRIPTIONID"))) { objDescriptionBO.DescriptionID = (dr.GetInt32(dr.GetOrdinal("DESCRIPTIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("DESCRIPTION"))) { objDescriptionBO.Description = dr.GetValue(dr.GetOrdinal("DESCRIPTION")).ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { objDescriptionBO.Isdeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } objDescList.Add(objDescriptionBO); } dr.Close(); } } return(objDescList); }
private void updateDescription() { DescriptionBLL descriptionBLL = new DescriptionBLL(); DescriptionBO DescriptionBO = new DescriptionBO(); string message = ""; string uID = string.Empty; uID = Session["USER_ID"].ToString(); DescriptionBO.DescriptionID = Convert.ToInt32(ViewState["DescriptionID"]); DescriptionBO.ParameterID = Convert.ToInt32(ddlparam.SelectedItem.Value); DescriptionBO.OptionAvailID = Convert.ToInt32(ddloptionAvailable.SelectedItem.Value); if (txtDescription.Text != "") { DescriptionBO.Description = txtDescription.Text.Trim(); } DescriptionBO.CreatedBy = Convert.ToInt32(uID); try { message = descriptionBLL.UpdateDesription(DescriptionBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); bindGrid(); btnSave.Text = "Save"; btnClear.Text = "Clear"; } catch (Exception ee) { throw ee; } finally { descriptionBLL = null; } }
public string UpdateDesription(DescriptionBO objDescription) { return((new DescriptionDAL()).UpdateDesription(objDescription)); }
public string AddDescription(DescriptionBO objSubCountyBO) { return((new DescriptionDAL()).AddDescription(objSubCountyBO)); }