public void Delete(bll_ReasonOfUnsold bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_reasonOfUnsold '" + bllcreate.REASONID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
            //Use label to print an error >> lbl.text = e.Message;
        }
    }
    public void Insert(bll_ReasonOfUnsold bllcreate)
    {
        try
        {
            cmd = "EXEC Insert_reasonOfUnsold '" + bllcreate.REASONTYPE + "','"
                  + bllcreate.REASONDETAILS + "' ,'"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }
        catch (Exception e)
        {
        }
    }