private void FillForm(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        try
        {
            DataTable dtb = assetBookSetupFormBAL.GetAssetBookSetupListById(assetBookSetupFormUI);

            if (dtb.Rows.Count > 0)
            {
                // txtName.Text = dtb.Rows[0]["Name"].ToString();
                //ddlCountry.SelectedValue = dtb.Rows[0]["tbl_CountryId"].ToString();
            }
            else
            {
                lblError.Text    = Resources.GlobalResource.msgCouldNotLoadData;
                divError.Visible = true;
            }
        }
        catch (Exception exp)
        {
            logExcpUIobj.MethodName       = "FillForm()";
            logExcpUIobj.ResourceName     = "System_Settings_BatchForm.CS";
            logExcpUIobj.RecordId         = batchFormUI.Tbl_BatchId;
            logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
            logExcpDALobj.SaveExceptionToDB(logExcpUIobj);

            log.Error("[Assets_AssetBookSetup_AssetBookSetupForm : FillForm] An error occured in the processing of Record Id : " + batchFormUI.Tbl_BatchId + ". Details : [" + exp.ToString() + "]");
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        AssetBookSetupFormUI assetBookSetupFormUI = new AssetBookSetupFormUI();

        if (!Page.IsPostBack)
        {
            if (Request.QueryString["AssetBookSetupId"] != null)
            {
                assetBookSetupFormUI.Tbl_AssetBookSetupId = Request.QueryString["AssetBookSetupId"];


                //FillForm(batchFormUI);

                btnSave.Visible   = false;
                btnClear.Visible  = false;
                btnUpdate.Visible = true;
                btnDelete.Visible = true;
                lblHeading.Text   = "Update Asset Book Setup";
            }
            else
            {
                btnSave.Visible   = true;
                btnClear.Visible  = true;
                btnUpdate.Visible = false;
                btnDelete.Visible = false;
                lblHeading.Text   = "Add New Asset Book Setup";
            }
        }
    }
Ejemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        AssetBookSetupFormUI assetBookSetupFormUI = new AssetBookSetupFormUI();


        if (!Page.IsPostBack)
        {
            if (Request.QueryString["AssetBookSetupId"] != null)
            {
                assetBookSetupFormUI.Tbl_AssetBookSetupId = Request.QueryString["AssetBookSetupId"];

                Bindopt_CurrentyFiscalYearDropDownList();
                Bindopt_DepreciatedPeriodDropDownList();
                FillForm(assetBookSetupFormUI);

                btnSave.Visible   = false;
                btnClear.Visible  = false;
                btnUpdate.Visible = true;
                btnDelete.Visible = true;
                lblHeading.Text   = "Update Asset Book Setup";
            }
            else
            {
                Bindopt_CurrentyFiscalYearDropDownList();
                Bindopt_DepreciatedPeriodDropDownList();

                btnSave.Visible   = true;
                btnClear.Visible  = true;
                btnUpdate.Visible = false;
                btnDelete.Visible = false;
                lblHeading.Text   = "Add New Asset Book Setup";
            }
        }
    }
    public int DeleteAssetBookSetup(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        int resutl = 0;

        resutl = assetBookSetupFormDAL.DeleteAssetBookSetup(assetBookSetupFormUI);
        return(resutl);
    }
    public int AddAssetBookSetup(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        int resutl = 0;

        resutl = assetBookSetupFormDAL.AddAssetBookSetup(assetBookSetupFormUI);
        return(resutl);
    }
    public DataTable GetAssetBookSetupListById(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        DataTable dtb = new DataTable();

        dtb = assetBookSetupFormDAL.GetAssetBookSetupListById(assetBookSetupFormUI);
        return(dtb);
    }
Ejemplo n.º 7
0
    public int UpdateAssetBookSetup(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        int result = 0;

        try
        {
            using (SqlConnection SupportCon = new SqlConnection(connectionString))
            {
                SupportCon.Open();
                SqlCommand sqlCmd = new SqlCommand("SP_AssetBookSetup_Update", SupportCon);
                sqlCmd.CommandType    = CommandType.StoredProcedure;
                sqlCmd.CommandTimeout = commandTimeout;

                sqlCmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar);
                sqlCmd.Parameters["@ModifiedBy"].Value = assetBookSetupFormUI.ModifiedBy;

                sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar);
                sqlCmd.Parameters["@tbl_OrganizationId"].Value = assetBookSetupFormUI.Tbl_OrganizationId;

                sqlCmd.Parameters.Add("@tbl_AssetBookSetupId", SqlDbType.NVarChar);
                sqlCmd.Parameters["@tbl_AssetBookSetupId"].Value = assetBookSetupFormUI.Tbl_AssetBookSetupId;

                sqlCmd.Parameters.Add("@AssetBookSetupCode", SqlDbType.NVarChar);
                sqlCmd.Parameters["@AssetBookSetupCode"].Value = assetBookSetupFormUI.AssetBookSetupCode;

                sqlCmd.Parameters.Add("@Description", SqlDbType.NVarChar);
                sqlCmd.Parameters["@Description"].Value = assetBookSetupFormUI.Description;

                sqlCmd.Parameters.Add("@opt_CurrentyFiscalYear", SqlDbType.Int);
                sqlCmd.Parameters["@opt_CurrentyFiscalYear"].Value = assetBookSetupFormUI.opt_CurrentyFiscalYear;

                sqlCmd.Parameters.Add("@opt_DepreciatedPeriod", SqlDbType.Int);
                sqlCmd.Parameters["@opt_DepreciatedPeriod"].Value = assetBookSetupFormUI.opt_DepreciatedPeriod;

                result = sqlCmd.ExecuteNonQuery();
                sqlCmd.Dispose();
                SupportCon.Close();
            }
        }
        catch (Exception exp)
        {
            logExcpUIobj.MethodName       = "UpdateAssetBookSetup()";
            logExcpUIobj.ResourceName     = "AssetBookSetupFormDAL.CS";
            logExcpUIobj.RecordId         = assetBookSetupFormUI.Tbl_AssetBookSetupId;
            logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
            logExcpDALobj.SaveExceptionToDB(logExcpUIobj);

            log.Error("[AssetBookSetupFormDAL : UpdateAssetBookSetup] An error occured in the processing of Record Id : " + assetBookSetupFormUI.Tbl_AssetBookSetupId + ". Details : [" + exp.ToString() + "]");
        }

        return(result);
    }
Ejemplo n.º 8
0
    public DataTable GetAssetBookSetupListById(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        DataSet   ds   = new DataSet();
        DataTable dtbl = new DataTable();

        try
        {
            using (SqlConnection SupportCon = new SqlConnection(connectionString))
            {
                SqlCommand sqlCmd = new SqlCommand("SP_AssetBookSetup_SelectById", SupportCon);
                sqlCmd.CommandType    = CommandType.StoredProcedure;
                sqlCmd.CommandTimeout = commandTimeout;

                sqlCmd.Parameters.Add("@tbl_AssetBookSetupId", SqlDbType.NVarChar);
                sqlCmd.Parameters["@tbl_AssetBookSetupId"].Value = assetBookSetupFormUI.Tbl_AssetBookSetupId;

                using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd))
                {
                    adapter.Fill(ds);
                }
            }
            if (ds.Tables.Count > 0)
            {
                dtbl = ds.Tables[0];
            }
        }
        catch (Exception exp)
        {
            logExcpUIobj.MethodName       = "GetAssetBookSetupListById()";
            logExcpUIobj.ResourceName     = "AssetBookSetupFormDAL.CS";
            logExcpUIobj.RecordId         = assetBookSetupFormUI.Tbl_AssetBookSetupId;
            logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
            logExcpDALobj.SaveExceptionToDB(logExcpUIobj);

            log.Error("[AssetBookSetupFormDAL : GetAssetBookSetupListById] An error occured in the processing of Record Id : " + assetBookSetupFormUI.Tbl_AssetBookSetupId + ". Details : [" + exp.ToString() + "]");
        }
        finally
        {
            ds.Dispose();
        }

        return(dtbl);
    }
Ejemplo n.º 9
0
    public int DeleteAssetBookSetup(AssetBookSetupFormUI assetBookSetupFormUI)
    {
        int result = 0;

        try
        {
            using (SqlConnection SupportCon = new SqlConnection(connectionString))
            {
                SupportCon.Open();
                SqlCommand sqlCmd = new SqlCommand("SP_AssetBookSetup_Delete", SupportCon);

                sqlCmd.CommandType    = CommandType.StoredProcedure;
                sqlCmd.CommandTimeout = commandTimeout;

                sqlCmd.Parameters.Add("@tbl_AssetBookSetupId", SqlDbType.NVarChar);
                sqlCmd.Parameters["@tbl_AssetBookSetupId"].Value = assetBookSetupFormUI.Tbl_AssetBookSetupId;

                result = sqlCmd.ExecuteNonQuery();

                sqlCmd.Dispose();
                SupportCon.Close();
            }
        }
        catch (Exception exp)
        {
            logExcpUIobj.MethodName       = "DeleteAssetBookSetup()";
            logExcpUIobj.ResourceName     = "AssetPurchaseDetailsFormDAL.CS";
            logExcpUIobj.RecordId         = assetBookSetupFormUI.Tbl_AssetBookSetupId;
            logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
            logExcpDALobj.SaveExceptionToDB(logExcpUIobj);

            log.Error("[AssetBookSetupFormDAL : DeleteAssetBookSetup] An error occured in the processing of Record Id : " + assetBookSetupFormUI.Tbl_AssetBookSetupId + ". Details : [" + exp.ToString() + "]");
        }

        return(result);
    }