public Register9Data DeleteRegisterData(int id)
        {
            Register9Data data9 = null;

            using (var context = new WebKikDataContext())
            {
                data9 = context.Registers9Data.Where(d => d.Id == id).FirstOrDefault();
                context.Registers9Data.Remove(data9);
                context.SaveChanges();
            }
            return(data9);
        }
        public Register9Data EditRegisterData(Register9Data data)
        {
            Register9Data data9 = null;

            using (var context = new WebKikDataContext())
            {
                data9 = context.Registers9Data.Where(d => d.Id == data.Id).FirstOrDefault();
                if (data9 != null)
                {
                    data9.StockholderName                            = data.StockholderName;
                    data9.CountryCodeId                              = data.CountryCodeId;
                    data9.LastYearDividendPaymentYear                = data.LastYearDividendPaymentYear;
                    data9.CurrentYearDividendPaymentData             = data.CurrentYearDividendPaymentData;
                    data9.CurrentYearDividendSum                     = data.CurrentYearDividendSum;
                    data9.CurrentYearTransitionalDividendPaymentData = data.CurrentYearTransitionalDividendPaymentData;
                    data9.CurrentYearTransitionalDividendSum         = data.CurrentYearTransitionalDividendSum;
                    data9.LastYearDividendPaymentData                = data.LastYearDividendPaymentData;
                    data9.LastYearDividendSum                        = data.LastYearDividendSum;
                }
                context.SaveChanges();
            }
            return(data9);
        }
        public Register9Data CreateRegisterData(Register9Data data)
        {
            Register9Data register;

            using (var context = new WebKikDataContext())
            {
                var data9 = context.Registers9Data.Add(new Register9Data
                {
                    Register9Id                                = data.Register9Id,
                    StockholderName                            = data.StockholderName,
                    CountryCodeId                              = data.CountryCodeId,
                    LastYearDividendPaymentYear                = data.LastYearDividendPaymentYear,
                    CurrentYearDividendPaymentData             = data.CurrentYearDividendPaymentData.HasValue ? data.CurrentYearDividendPaymentData.Value : new DateTime(0),
                    CurrentYearDividendSum                     = data.CurrentYearDividendSum,
                    CurrentYearTransitionalDividendPaymentData = data.CurrentYearTransitionalDividendPaymentData.HasValue ? data.CurrentYearTransitionalDividendPaymentData.Value : new DateTime(0),
                    CurrentYearTransitionalDividendSum         = data.CurrentYearTransitionalDividendSum,
                    LastYearDividendPaymentData                = data.LastYearDividendPaymentData.HasValue ? data.LastYearDividendPaymentData.Value : new DateTime(0),
                    LastYearDividendSum                        = data.LastYearDividendSum
                });
                context.SaveChanges();
                return(data9);
            }
        }