Ejemplo n.º 1
0
        public List <Agency> GetAgencyContactsByAgencyId(int agencyid)
        {
            var result = new List <Agency>();

            var qry = _db.Agencies.Where(q => q.AgencyId == agencyid).OrderBy(q => q.FirstName);

            foreach (var q in qry)
            {
                var n = new Agency();
                n.AgencyId  = q.AgencyId;
                n.FirstName = q.FirstName;
                n.LastName  = q.LastName;
                n.Address   = q.Address;
                n.Phone     = q.Phone;

                n.Salutation = q.Salutation;
                n.Fax        = q.Fax;

                result.Add(n);
            }

            return(result);
        }
Ejemplo n.º 2
0
        protected void AgencyButtonClicked(object sender, RadToolBarEventArgs e)
        {
            if (e.Item.Text == @"New")
            {
                RadGridAgency.SelectedIndexes.Clear();
                ResetForm();
            }
            else if (e.Item.Text == @"Update" && RadGridAgency.SelectedValue != null)
            {
                if (IsValid)
                {
                    var cAgency = new CAgency();
                    var agc     = cAgency.Get(Convert.ToInt32(RadGridAgency.SelectedValue));

                    var oriBasicCommission    = Convert.ToDouble(agc.CommissionRateBasic);
                    var oriSeasonalCommission = Convert.ToDouble(agc.CommissionRateSeasonal);
                    var oriCreditLimit        = Convert.ToDouble(agc.CreditLimit);

                    agc.Name                   = RadComboBoxAgencyName.Text;
                    agc.Abbreviation           = tbAgencyShortName.Text;
                    agc.GroupName              = tbAgencyGroupName.Text;
                    agc.PrintingName           = tbAgencyPrintName.Text;
                    agc.AgencyType             = tbAgencyType.Text;
                    agc.CommissionRateBasic    = tbCommissionRateBasic.Value;
                    agc.CommissionRateSeasonal = tbCommissionRateSeason.Value;
                    agc.CreditLimit            = tbCreditLimit.Value;
                    agc.Location               = Convert.ToInt32(ddlBusinessLocation.SelectedValue);
                    agc.MainTargetCountry      = Convert.ToInt32(ddlMainTarget.SelectedValue);
                    if (tbContractStart.SelectedDate != null)
                    {
                        agc.ContractStartDate = Convert.ToDateTime(tbContractStart.SelectedDate);
                    }
                    if (tbContractEnd.SelectedDate != null)
                    {
                        agc.ContractEndDate = Convert.ToDateTime(tbContractEnd.SelectedDate);
                    }
                    agc.APPaymentTerm        = tbAPPayTerm.Text;
                    agc.APPaymentMethod      = tbAPPayMethod.Text;
                    agc.APBillingType        = tbAPBillingType.Text;
                    agc.APPaymentPriority    = tbAPPAymentPriority.Text;
                    agc.APPaymentSchedule    = tbAPPaySchedule.Text;
                    agc.ARCollectionTerm     = tbARCollectionTerm.Text;
                    agc.ARType               = tbARType.Text;
                    agc.ARCollectionPriority = tbARCollection.Text;
                    agc.ARCollectionSchedule = tbARCollectionSchedule.Text;
                    agc.ARCollectionMethod   = tbARCollectionMethod.Text;
                    agc.AgencyRegNo          = tbAgencyNo.Text;
                    agc.Currency             = tbCurrency.Text;
                    agc.Comment              = tbComment.Text;

                    agc.AgencyId   = agc.AgencyId;
                    agc.FirstName  = agFname.Text;
                    agc.LastName   = agLname.Text;
                    agc.Salutation = agTitle.Text;
                    agc.Phone      = agPhone.Text;
                    agc.Mobile     = agMobile.Text;
                    agc.Fax        = agFax.Text;
                    agc.PEmail     = agPEmail.Text;
                    agc.SEmail     = agSEmail.Text;
                    agc.Website    = agWebsite.Text;
                    agc.Address    = agAddress.Text;
                    agc.City       = agCity.Text;
                    agc.Province   = agProvince.Text;
                    agc.Postal     = agPostal.Text;
                    if (ddlAgencyCountry.SelectedValue != string.Empty)
                    {
                        agc.CountryId = Convert.ToInt32(ddlAgencyCountry.SelectedValue);
                    }

                    agc.FirstName1  = agFname1.Text;
                    agc.LastName1   = agLname1.Text;
                    agc.Salutation1 = agTitle1.Text;
                    agc.Phone1      = agPhone1.Text;
                    agc.Mobile1     = agMobile1.Text;
                    agc.Fax1        = agFax1.Text;
                    agc.PEmail1     = agPEmail1.Text;
                    agc.SEmail1     = agSEmail1.Text;
                    agc.Website1    = agWebsite1.Text;
                    agc.Address1    = agAddress1.Text;
                    agc.City1       = agCity1.Text;
                    agc.Province1   = agProvince1.Text;
                    agc.Postal1     = agPostal1.Text;
                    if (ddlAgencyCountry1.SelectedValue != string.Empty)
                    {
                        agc.CountryId1 = Convert.ToInt32(ddlAgencyCountry1.SelectedValue);
                    }

                    agc.IsActive    = RadButtonActive.Checked;
                    agc.UpdatedId   = CurrentUserId;
                    agc.UpdatedDate = DateTime.Now;

                    if (oriBasicCommission == tbCommissionRateBasic.Value && oriSeasonalCommission == tbCommissionRateSeason.Value && oriCreditLimit == tbCreditLimit.Value)
                    {
                        cAgency.Update(agc);
                    }
                    else
                    {
                        cAgency.Update(agc);

                        var cHistory = new CAgencyCommissionHistory();
                        var history  = new AgencyCommissionHistory();

                        history.AgencyId = agc.AgencyId;

                        history.OriBasicCommission  = oriBasicCommission;
                        history.OriSeasonCommission = oriSeasonalCommission;
                        history.OriCreditLimit      = oriCreditLimit;

                        history.ChBasicCommission  = (double)agc.CommissionRateBasic;
                        history.ChSeasonCommission = (double)agc.CommissionRateSeasonal;
                        history.ChCreditLimit      = (double)agc.CreditLimit;

                        history.SiteLocationId = CurrentSiteLocationId;
                        history.UpdatedDate    = DateTime.Now;
                        history.UpdatedId      = CurrentUserId;

                        cHistory.Add(history);
                    }

                    var cAgencySiteLocation = new CAgencySiteLocation();
                    cAgencySiteLocation.DelAgencySiteLocationList(Convert.ToInt32(RadGridAgency.SelectedValue));

                    foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems)
                    {
                        var agencySiteLocation = new AgencySiteLocation()
                        {
                            CreatedId      = CurrentUserId,
                            AgencyId       = Convert.ToInt32(RadGridAgency.SelectedValue),
                            SiteLocationId = Convert.ToInt32(siteLocation.Value),
                            CreatedDate    = DateTime.Now
                        };
                        cAgencySiteLocation.Add(agencySiteLocation);
                    }

                    RadGridAgency.Rebind();
                    ShowMessage("Update Agency Info Successfully");
                }
            }
            else if (e.Item.Text == @"Save")
            {
                if (IsValid)
                {
                    var cAgency = new CAgency();
                    var agc     = new Erp2016.Lib.Agency();

                    agc.Name                   = RadComboBoxAgencyName.Text;
                    agc.Abbreviation           = tbAgencyShortName.Text;
                    agc.GroupName              = tbAgencyGroupName.Text;
                    agc.PrintingName           = tbAgencyPrintName.Text;
                    agc.AgencyType             = tbAgencyType.Text;
                    agc.CommissionRateBasic    = tbCommissionRateBasic.Value;
                    agc.CommissionRateSeasonal = tbCommissionRateSeason.Value;
                    agc.CreditLimit            = tbCreditLimit.Value;
                    agc.Location               = Convert.ToInt32(ddlBusinessLocation.SelectedValue);
                    agc.MainTargetCountry      = Convert.ToInt32(ddlMainTarget.SelectedValue);
                    agc.ContractStartDate      = (tbContractStart.SelectedDate == null) ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(tbContractStart.SelectedDate);
                    agc.ContractEndDate        = (tbContractEnd.SelectedDate == null) ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(tbContractEnd.SelectedDate);

                    agc.APPaymentTerm        = tbAPPayTerm.Text;
                    agc.APPaymentMethod      = tbAPPayMethod.Text;
                    agc.APBillingType        = tbAPBillingType.Text;
                    agc.APPaymentPriority    = tbAPPAymentPriority.Text;
                    agc.APPaymentSchedule    = tbAPPaySchedule.Text;
                    agc.ARCollectionTerm     = tbARCollectionTerm.Text;
                    agc.ARType               = tbARType.Text;
                    agc.ARCollectionPriority = tbARCollection.Text;
                    agc.ARCollectionSchedule = tbARCollectionSchedule.Text;
                    agc.ARCollectionMethod   = tbARCollectionMethod.Text;
                    agc.AgencyRegNo          = tbAgencyNo.Text;
                    agc.Currency             = tbCurrency.Text;
                    agc.Comment              = tbComment.Text;

                    agc.ApprovalDate = DateTime.Now;

                    agc.IsActive    = RadButtonActive.Checked;
                    agc.CreatedId   = CurrentUserId;
                    agc.CreatedDate = DateTime.Now;

                    agc.AgencyId   = agc.AgencyId;
                    agc.FirstName  = agFname.Text;
                    agc.LastName   = agLname.Text;
                    agc.Salutation = agTitle.Text;
                    agc.Phone      = agPhone.Text;
                    agc.Mobile     = agMobile.Text;
                    agc.Fax        = agFax.Text;
                    agc.PEmail     = agPEmail.Text;
                    agc.SEmail     = agSEmail.Text;
                    agc.Website    = agWebsite.Text;
                    agc.Address    = agAddress.Text;
                    agc.City       = agAddress.Text;
                    agc.Province   = agProvince.Text;
                    agc.Postal     = agPostal.Text;
                    if (ddlAgencyCountry.SelectedValue != string.Empty)
                    {
                        agc.CountryId = Convert.ToInt32(ddlAgencyCountry.SelectedValue);
                    }

                    agc.FirstName1  = agFname1.Text;
                    agc.LastName1   = agLname1.Text;
                    agc.Salutation1 = agTitle1.Text;
                    agc.Phone1      = agPhone1.Text;
                    agc.Mobile1     = agMobile1.Text;
                    agc.Fax1        = agFax1.Text;
                    agc.PEmail1     = agPEmail1.Text;
                    agc.SEmail1     = agSEmail1.Text;
                    agc.Website1    = agWebsite1.Text;
                    agc.Address1    = agAddress1.Text;
                    agc.City1       = agCity1.Text;
                    agc.Province1   = agProvince1.Text;
                    agc.Postal1     = agPostal1.Text;
                    if (ddlAgencyCountry1.SelectedValue != string.Empty)
                    {
                        agc.CountryId1 = Convert.ToInt32(ddlAgencyCountry1.SelectedValue);
                    }

                    int agencyId = cAgency.Add(agc);
                    if (agencyId > 0)
                    {
                        var cAgencySiteLocation = new CAgencySiteLocation();
                        cAgencySiteLocation.DelAgencySiteLocationList(agencyId);

                        foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems)
                        {
                            var agencySiteLocation = new AgencySiteLocation()
                            {
                                CreatedId      = CurrentUserId,
                                AgencyId       = agencyId,
                                SiteLocationId = Convert.ToInt32(siteLocation.Value),
                                CreatedDate    = DateTime.Now
                            };
                            cAgencySiteLocation.Add(agencySiteLocation);
                        }

                        RadGridAgency.Rebind();
                        ShowMessage("Add Agency Info Successfully");
                    }
                }
                else
                {
                    ShowMessage("Failed To Add.");
                }
            }
            else if (e.Item.Text == "Old Agency Lookup")
            {
                RunClientScript("ShowAgencyOldInfoWindow();");
            }
        }