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