コード例 #1
0
        private void UpdateDatabase()
        {
            // Get ids
            int companyId = int.Parse(hdfCompanyId.Value);

            // Delete
            DB.Open();
            DB.BeginTransaction();
            try
            {
                string category = hdfCategory.Value;

                if (category == "Subcontractors")
                {
                    ActualCostsInformationSubcontractorBasicInformation actualCostsInformationSubcontractorBasicInformation = new ActualCostsInformationSubcontractorBasicInformation(actualCostsInformationTDS);
                    actualCostsInformationSubcontractorBasicInformation.Save(companyId);
                }
                else
                {
                    if (category == "Hotels")
                    {
                        ActualCostsInformationHotelCostsBasicInformation actualCostsInformationHotelCostsBasicInformation = new ActualCostsInformationHotelCostsBasicInformation(actualCostsInformationTDS);
                        actualCostsInformationHotelCostsBasicInformation.Save(companyId);
                    }
                    else
                    {
                        if (category == "Insurance")
                        {
                            ActualCostsInformationInsuranceCostsBasicInformation actualCostsInformationInsuranceCostsBasicInformation = new ActualCostsInformationInsuranceCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationInsuranceCostsBasicInformation.Save(companyId);
                        }
                        else
                        {
                            if (category == "Bonding")
                            {
                                ActualCostsInformationBondingCostsBasicInformation actualCostsInformationBondingCostsBasicInformation = new ActualCostsInformationBondingCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationBondingCostsBasicInformation.Save(companyId);
                            }
                            else
                            {
                                // other categories
                                ActualCostsInformationOtherCostsBasicInformation actualCostsInformationOtherCostsBasicInformation = new ActualCostsInformationOtherCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationOtherCostsBasicInformation.Save(companyId);
                            }
                        }
                    }
                }

                DB.CommitTransaction();
            }
            catch (Exception ex)
            {
                DB.RollbackTransaction();

                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }
コード例 #2
0
        private void Delete()
        {
            int currentProjectId = int.Parse(hdfCurrentProjectId.Value);
            int currentRefId = int.Parse(hdfCurrentRefId.Value);

            string category = hdfCategory.Value;

            if (category == "Subcontractors")
            {
                    ActualCostsInformationSubcontractorBasicInformation actualCostsInformationSubcontractorBasicInformation = new ActualCostsInformationSubcontractorBasicInformation(actualCostsInformationTDS);
                    actualCostsInformationSubcontractorBasicInformation.Delete(currentProjectId, currentRefId);
            }
            else
            {
                if (category == "Hotels")
                {
                    ActualCostsInformationHotelCostsBasicInformation actualCostsInformationHotelCostsBasicInformation = new ActualCostsInformationHotelCostsBasicInformation(actualCostsInformationTDS);
                    actualCostsInformationHotelCostsBasicInformation.Delete(currentProjectId, currentRefId);
                }
                else
                {
                    if (category == "Insurance")
                    {
                        ActualCostsInformationInsuranceCostsBasicInformation actualCostsInformationInsuranceCostsBasicInformation = new ActualCostsInformationInsuranceCostsBasicInformation(actualCostsInformationTDS);
                        actualCostsInformationInsuranceCostsBasicInformation.Delete(currentProjectId, currentRefId);
                    }
                    else
                    {
                        if (category == "Bonding")
                        {
                            ActualCostsInformationBondingCostsBasicInformation actualCostsInformationBondingCostsBasicInformation = new ActualCostsInformationBondingCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationBondingCostsBasicInformation.Delete(currentProjectId, currentRefId);
                        }
                        else
                        {
                            // other categories
                            ActualCostsInformationOtherCostsBasicInformation actualCostsInformationOtherCostsBasicInformation = new ActualCostsInformationOtherCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationOtherCostsBasicInformation.Delete(currentProjectId, currentRefId);
                        }
                    }
                }
            }

            // Store datasets
            Session["actualCostsInformationTDS"] = actualCostsInformationTDS;
        }
コード例 #3
0
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {                if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_ACTUAL_COSTS_ADMIN"])))
                {
                    // Security check
                    if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_ACTUAL_COSTS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_ACTUAL_COSTS_EDIT"])))
                    {
                        Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
                    }

                    // Validate query string
                    if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["ref_id"] == null))
                    {
                        Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in actual_costs_edit.aspx");
                    }
                }

                // Initialize  variables
                hdfProjectId.Value = Request.QueryString["project_id"].ToString();
                hdfRefId.Value = Request.QueryString["ref_id"].ToString();
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfCategory.Value = Request.QueryString["category"].ToString();

                // If coming from
                int currentRefId = Int32.Parse(hdfRefId.Value);
                int currentProjectId = Int32.Parse(hdfProjectId.Value);
                int companyId = Int32.Parse(hdfCompanyId.Value);
                string category = hdfCategory.Value;

                // ... actual_costs_navigator2.aspx
                if (Request.QueryString["source_page"] == "actual_costs_navigator2.aspx")
                {
                    StoreNavigatorState();
                    ViewState["update"] = "si";

                    actualCostsInformationTDS = new ActualCostsInformationTDS();

                    if (category == "Subcontractors")
                    {
                        lblTitle.Text = "Subcontractor Costs";
                        lblCategoryName.Text = "Subcontractor";
                        ActualCostsInformationSubcontractorBasicInformation actualCostsInformationSubcontractorBasicInformation = new ActualCostsInformationSubcontractorBasicInformation(actualCostsInformationTDS);
                        actualCostsInformationSubcontractorBasicInformation.LoadByProjectIdRefId(currentProjectId, currentRefId, companyId);
                    }
                    else
                    {
                        if (category == "Hotels")
                        {
                            lblTitle.Text = "Hotel Costs";
                            lblCategoryName.Text = "Hotels";
                            tbxState.Visible = false;
                            ActualCostsInformationHotelCostsBasicInformation actualCostsInformationHotelCostsBasicInformation = new ActualCostsInformationHotelCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationHotelCostsBasicInformation.LoadByProjectIdRefId(currentProjectId, currentRefId, companyId);
                        }
                        else
                        {
                            if (category == "Insurance")
                            {
                                lblTitle.Text = "Insurance Company Costs";
                                lblCategoryName.Text = "Insurance Company";
                                tbxState.Visible = false;
                                ActualCostsInformationInsuranceCostsBasicInformation actualCostsInformationInsuranceCostsBasicInformation = new ActualCostsInformationInsuranceCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationInsuranceCostsBasicInformation.LoadByProjectIdRefId(currentProjectId, currentRefId, companyId);
                            }
                            else
                            {
                                if (category == "Bonding")
                                {
                                    lblTitle.Text = "Bonding Company Costs";
                                    lblCategoryName.Text = "Bonding Company";
                                    tbxState.Visible = false;
                                    ActualCostsInformationBondingCostsBasicInformation actualCostsInformationBondingCostsBasicInformation = new ActualCostsInformationBondingCostsBasicInformation(actualCostsInformationTDS);
                                    actualCostsInformationBondingCostsBasicInformation.LoadByProjectIdRefId(currentProjectId, currentRefId, companyId);
                                }
                                else
                                {
                                    // other categories
                                    lblTitle.Text = "Other Costs";
                                    lblCategoryName.Text = "Category";
                                    tbxState.Visible = false;
                                    ActualCostsInformationOtherCostsBasicInformation actualCostsInformationOtherCostsBasicInformation = new ActualCostsInformationOtherCostsBasicInformation(actualCostsInformationTDS);
                                    actualCostsInformationOtherCostsBasicInformation.LoadByProjectIdRefId(currentProjectId, currentRefId, companyId);
                                }
                            }
                        }
                    }

                    // ... Store dataset
                    Session["actualCostsInformationTDS"] = actualCostsInformationTDS;
                }

                // ... actual_costs_summary.aspx or actual_costs_edit.aspx
                if ((Request.QueryString["source_page"] == "actual_costs_summary.aspx") || (Request.QueryString["source_page"] == "actual_costs_edit.aspx"))
                {
                    StoreNavigatorState();
                    ViewState["update"] = Request.QueryString["update"];

                    // ... Restore dataset
                    actualCostsInformationTDS = (ActualCostsInformationTDS)Session["actualCostsInformationTDS"];
                }

                // ... Data for current employee
                LoadData(currentProjectId, currentRefId);
            }
            else
            {
                // Restore datasets
                actualCostsInformationTDS = (ActualCostsInformationTDS)Session["actualCostsInformationTDS"];
            }
        }
コード例 #4
0
        private void Save()
        {
            // Validate data
            bool validData = false;

            Page.Validate("Data");
            if (Page.IsValid)
            {
                validData = true;
            }

            if (validData)
            {
                // Save data
                int companyId = Int32.Parse(hdfCompanyId.Value);
                int projectId = Int32.Parse(hdfProjectId.Value);
                int refId = Int32.Parse(hdfRefId.Value);
                Int64 countryId = Int64.Parse(hdfCountryId.Value);

                // ... Get subcontractor hors data
                DateTime? newDate = tkrdpDate_.SelectedDate;
                decimal newRateCad = 0;
                decimal newRateUsd = 0;

                if (countryId == 1) // Canada
                {
                    newRateCad = decimal.Parse(tbxRate.Text.Trim());
                }
                else
                {
                    newRateUsd = decimal.Parse(tbxRate.Text.Trim());
                }
                string newComment = tbxComments.Text.Trim();
                string category = hdfCategory.Value;

                // Update basic information data
                if (category == "Subcontractors")
                {
                    double newQuantity = double.Parse(tbxQuantity.Text.Trim());
                    decimal newTotalCad = 0;
                    decimal newTotalUsd = 0;

                    if (countryId == 1) // Canada
                    {
                        newTotalCad = decimal.Parse(tbxTotal.Text.Trim());
                    }
                    else
                    {
                        newTotalUsd = decimal.Parse(tbxTotal.Text.Trim());
                    }

                    ActualCostsInformationSubcontractorBasicInformation actualCostsInformationSubcontractorBasicInformation = new ActualCostsInformationSubcontractorBasicInformation(actualCostsInformationTDS);
                    actualCostsInformationSubcontractorBasicInformation.Update(projectId, refId, (DateTime)newDate, newQuantity, newRateCad, newTotalCad, newRateUsd, newTotalUsd, newComment);
                }
                else
                {
                    if (category == "Hotels")
                    {
                        ActualCostsInformationHotelCostsBasicInformation actualCostsInformationHotelCostsBasicInformation = new ActualCostsInformationHotelCostsBasicInformation(actualCostsInformationTDS);
                        actualCostsInformationHotelCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                    }
                    else
                    {
                        if (category == "Insurance")
                        {
                            ActualCostsInformationInsuranceCostsBasicInformation actualCostsInformationInsuranceCostsBasicInformation = new ActualCostsInformationInsuranceCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationInsuranceCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                        }
                        else
                        {
                            if (category == "Bonding")
                            {
                                ActualCostsInformationBondingCostsBasicInformation actualCostsInformationBondingCostsBasicInformation = new ActualCostsInformationBondingCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationBondingCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                            }
                            else
                            {
                                // other categories
                                ActualCostsInformationOtherCostsBasicInformation actualCostsInformationOtherCostsBasicInformation = new ActualCostsInformationOtherCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationOtherCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                            }
                        }
                    }
                }

                // Store datasets
                Session["actualCostsInformationTDS"] = actualCostsInformationTDS;

                // Update database
                UpdateDatabase();

                ViewState["update"] = "yes";

                // Redirect
                string url = "";
                if (Request.QueryString["source_page"] == "actual_costs_navigator2.aspx" )
                {
                    url = "./actual_costs_navigator2.aspx?source_page=actual_costs_edit.aspx&project_id=" + hdfProjectId.Value + "&ref_id=" + hdfRefId.Value + GetNavigatorState() + "&update=yes" + "&category=" + hdfCategory.Value;
                }

                if (Request.QueryString["source_page"] == "actual_costs_summary.aspx")
                {
                    url = "./actual_costs_summary.aspx?source_page=actual_costs_edit.aspx&project_id=" + hdfProjectId.Value + "&ref_id=" + hdfRefId.Value + GetNavigatorState() + "&update=yes" + "&category=" + hdfCategory.Value;
                }

                Response.Redirect(url);
            }
        }
コード例 #5
0
        private void Apply()
        {
            // Validate data
            bool validData = false;

            Page.Validate("Data");
            if (Page.IsValid)
            {
                validData = true;
            }

            if (validData)
            {
                // Save data
                int companyId = Int32.Parse(hdfCompanyId.Value);
                int projectId = Int32.Parse(hdfProjectId.Value);
                int refId = Int32.Parse(hdfRefId.Value);
                Int64 countryId = Int64.Parse(hdfCountryId.Value);

                // ... Get subcontractor hors data
                DateTime? newDate = tkrdpDate_.SelectedDate;

                decimal newRateCad = 0;
                decimal newRateUsd = 0;

                if (countryId == 1) // Canada
                {
                    newRateCad = decimal.Parse(tbxRate.Text.Trim());
                }
                else
                {
                    newRateUsd = decimal.Parse(tbxRate.Text.Trim());
                }
                string newComment = tbxComments.Text.Trim();
                string category = hdfCategory.Value;

                // Update basic information data
                if (category == "Subcontractors")
                {
                    double newQuantity = double.Parse(tbxQuantity.Text.Trim());
                    decimal newTotalCad = 0;
                    decimal newTotalUsd = 0;

                    if (countryId == 1) // Canada
                    {
                        newTotalCad = decimal.Parse(tbxTotal.Text.Trim());
                    }
                    else
                    {
                        newTotalUsd = decimal.Parse(tbxTotal.Text.Trim());
                    }

                    ActualCostsInformationSubcontractorBasicInformation actualCostsInformationSubcontractorBasicInformation = new ActualCostsInformationSubcontractorBasicInformation(actualCostsInformationTDS);
                    actualCostsInformationSubcontractorBasicInformation.Update(projectId, refId, (DateTime)newDate, newQuantity, newRateCad, newTotalCad, newRateUsd, newTotalUsd, newComment);
                }
                else
                {
                    if (category == "Hotels")
                    {
                        ActualCostsInformationHotelCostsBasicInformation actualCostsInformationHotelCostsBasicInformation = new ActualCostsInformationHotelCostsBasicInformation(actualCostsInformationTDS);
                        actualCostsInformationHotelCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                    }
                    else
                    {
                        if (category == "Insurance")
                        {
                            ActualCostsInformationInsuranceCostsBasicInformation actualCostsInformationInsuranceCostsBasicInformation = new ActualCostsInformationInsuranceCostsBasicInformation(actualCostsInformationTDS);
                            actualCostsInformationInsuranceCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                        }
                        else
                        {
                            if (category == "Bonding")
                            {
                                ActualCostsInformationBondingCostsBasicInformation actualCostsInformationBondingCostsBasicInformation = new ActualCostsInformationBondingCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationBondingCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                            }
                            else
                            {
                                // for other categories
                                ActualCostsInformationOtherCostsBasicInformation actualCostsInformationOtherCostsBasicInformation = new ActualCostsInformationOtherCostsBasicInformation(actualCostsInformationTDS);
                                actualCostsInformationOtherCostsBasicInformation.Update(projectId, refId, (DateTime)newDate, newRateCad, newRateUsd, newComment);
                            }
                        }
                    }
                }

                // Store datasets
                Session["actualCostsInformationTDS"] = actualCostsInformationTDS;

                // Update database
                UpdateDatabase();

                ViewState["update"] = "yes";
            }
        }