Exemple #1
0
        public int Update(Models.SysUserView data)
        {
            try
            {
                this.Validate(data);

                data.ModifiedBy       = GlobalVariant.GetAppUser().UserID;
                data.ModifiedDateTime = DateTime.Now;
                var olddata = GetById(data.UserID);
                if (olddata.Name != data.Name || olddata.Password != data.Password)
                {
                    data.Password = Accounting.Services.MD5.GenerateHashDigest(data.Name + data.Password);
                }

                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);

                return(data.UserID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #2
0
        public int Insert(Models.AppFixedAssetView data)
        {
            try
            {
                this.Validate(data);

                data.CreatedBy       = GlobalVariant.GetAppUser().UserID;
                data.CreatedDateTime = DateTime.Now;

                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);

                #region Xử lý line
                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);

                var AppFixedAssetLineTables = data.AppFixedAssetLineTables.ToList();
                var AppFixedAssetLineTablez = data.AppFixedAssetLineTablez.ToList();
                for (int i = 0; i < AppFixedAssetLineTables.Count; i++)
                {
                    var itemz = AppFixedAssetLineTablez[i];
                    if (itemz != -1)
                    {
                        var item = AppFixedAssetLineTables[i];
                        item.FixedAssetID = data.FixedAssetID;
                        this.InsertLine(item);
                    }
                }

                #endregion

                #region Xử lý VAT
                if (data.AppEquipmentTables != null)
                {
                    this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);

                    var AppEquipmentTables = data.AppEquipmentTables.ToList();
                    var AppEquipmentTablez = data.AppEquipmentTablez.ToList();
                    for (int i = 0; i < AppEquipmentTables.Count; i++)
                    {
                        var itemz = AppEquipmentTablez[i];
                        if (itemz != -1)
                        {
                            var item = AppEquipmentTables[i];
                            item.FixedAssetID = data.FixedAssetID;
                            this.InsertVAT(item);
                        }
                    }
                }

                #endregion

                return((int)parameters.GetValueSqlParam(this._paramnameoutput));
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #3
0
        public long UpdateVAT(Models.AppVPO05VATView data)
        {
            try
            {
                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamevatoutput), this._paramnamevatupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameVATU, parameters);

                return(data.DocumentVATID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #4
0
        public long InsertVAT(Models.AppVPO05VATView data)
        {
            try
            {
                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamevatoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameVATI, parameters);
                data.DocumentVATID = (long)parameters.GetValueSqlParam(this._paramnamevatoutput);

                return(data.DocumentVATID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #5
0
        public int UpdateLine(Models.AppFixedAssetLineTable data)
        {
            try
            {
                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamelineoutput), this._paramnamelineupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameLineU, parameters);

                return(data.FixedAssetLineID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #6
0
        public int InsertVAT(Models.AppEquipmentTable data)
        {
            try
            {
                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamevatoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameVATI, parameters);
                data.EquipmentID = (int)parameters.GetValueSqlParam(this._paramnamevatoutput);

                return(data.EquipmentID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #7
0
        public int InsertLine(Models.AppFixedAssetLineTable data)
        {
            try
            {
                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamelineoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameLineI, parameters);
                data.FixedAssetLineID = (int)parameters.GetValueSqlParam(this._paramnamelineoutput);

                return(data.FixedAssetLineID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #8
0
        public int Insert(Models.AppExpenseTable data)
        {
            try
            {
                this.Validate(data);

                data.CreatedBy       = GlobalVariant.GetAppUser().UserID;
                data.CreatedDateTime = DateTime.Now;

                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);

                return((int)parameters.GetValueSqlParam(this._paramnameoutput));
            }
            catch (Exception)
            {
                throw;
            }
        }
        public IList <VcRuleCell> GetRules(BaseEntity Ety)
        {
            IList <VcRuleCell> Result = new List <VcRuleCell>();

            List <KindIdent> KindIdents;
            Int32            RulesIdx;

            if (Find(Ety, out KindIdents, out RulesIdx))
            {
                ExIList.Append <VcRuleCell>(KindIdents[RulesIdx].Rules, Result);
                return(Result);
            }
            else
            {
                KindIdent ki = new KindIdent(Ety.GetType().Name);
                foreach (OleDbDataReader Reader in ThisModule.OleDB.EachRows("select FRule, FTime from TRule "
                                                                             + " where FKind = '" + ki.Kind + "'"
                                                                             + " and FId = " + Ety.Id))
                {
                    VcRuleCell rt = new VcRuleCell();
                    //rt.Rule = (eRule)ExMath.Bound(Convert.ToInt32(Reader[0]), (Int32)eRule.crisscross, (Int32)eRule.excellent, (Int32)eRule.common);

                    var rd = ExConvert.TryToInt32(Reader[0], 0);
                    rt.Rule = rd <(Int32)eRule.crisscross || rd> (Int32) eRule.excellent ? eRule.common : (eRule)rd;
                    rt.Time = VcTimeLogic.GetTimeFromInt32(Convert.ToInt32(Reader[1]));
                    ki.Rules.Add(rt);
                }
                if (KindIdents == null)
                {
                    KindIdents = new List <KindIdent>();
                    KindIdents.Add(ki);
                    RuleBuf.Add(Ety.Id, KindIdents);
                }
                else
                {
                    KindIdents.Add(ki);
                }

                ExIList.Append <VcRuleCell>(ki.Rules, Result);
                return(Result);
            }
        }
Exemple #10
0
        public int Update(Models.AppExpenseTable data)
        {
            try
            {
                this.Validate(data);

                data.ModifiedBy       = GlobalVariant.GetAppUser().UserID;
                data.ModifiedDateTime = DateTime.Now;

                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);

                return(data.ExpenseID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #11
0
        //public string EncryptPassWord(string username,string password)
        //{
        //    return Accounting.Services.MD5.GenerateHashDigest(username + password);
        //}

        public int Insert(Models.SysUserView data)
        {
            try
            {
                this.Validate(data);

                data.CreatedBy       = GlobalVariant.GetAppUser().UserID;
                data.CreatedDateTime = DateTime.Now;

                data.Password = Accounting.Services.MD5.GenerateHashDigest(data.Name + data.Password);

                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);

                return((int)parameters.GetValueSqlParam(this._paramnameoutput));
            }
            catch (Exception)
            {
                throw;
            }
        }
            public AtomDtAccess(IDbAccess OleDB)
            {
                this.OleDB = OleDB;

                IsCourse = typeof(T) == typeof(EnSubject);
                Kind     = typeof(T).Name;

                foreach (OleDbDataReader reader in OleDB.EachRows(
                             "select Id, FName, FColor from TAtomAndGrp"
                             + " where FKind = '" + Kind + "'"))
                {
                    T ety = new T();
                    ety.Id   = Convert.ToInt64(reader[0]);
                    ety.Name = reader[1].ToString();
                    if (IsCourse)
                    {
                        (ety as EnSubject).Color = Color.FromArgb(ExConvert.TryToInt32(reader[2], 0));
                    }

                    Entities.Add(ety.Id, ety);
                }
            }
Exemple #13
0
        public long Update(Models.AppVPO05View data)
        {
            try
            {
                this.ValidateUpdate(data);
                this.Validate(data);

                data.ModifiedBy       = GlobalVariant.GetAppUser().UserID;
                data.ModifiedDateTime = DateTime.Now;

                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamemasteroutput), this._paramnamemasterupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);

                #region X? lý line
                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);


                var appvpo05lineviews = data.AppVPO05LineViews.ToList();
                var appvpo05lineviewz = data.AppVPO05LineViewz.ToList();
                for (int i = 0; i < appvpo05lineviews.Count; i++)
                {
                    var itemz = appvpo05lineviewz[i];
                    var item  = appvpo05lineviews[i];

                    if (itemz != -1)
                    {
                        //có 2 tru?ng h?p: 1 - thêm m?i thu?ng DocumentLineID==0, 2 - s?a d? li?u cu DocumentLineID<>0
                        item.DocumentID = data.DocumentID;
                        //item.AccountDebitLineID = data.AccountDebitID;
                        item.AccountCreditLineID = data.AccountCreditID;
                        item.MeasureRate         = item.MeasureRate ?? 1;
                        item.Quantity            = item.Quantity0 * item.MeasureRate;
                        if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
                        {
                            //item.Debit = 0;
                            //item.Credit = 0;
                            //item.ExchangeRateLine = 0;
                            item.AmountFC = 0;
                        }


                        if (item.DocumentLineID == 0)
                        {
                            this.InsertLine(item);
                        }
                        else
                        {
                            this.UpdateLine(item);
                        }
                    }
                    else
                    {
                        //n?u xóa có 2 tru?ng h?p : 1 - xóa d? li?u có tru?c DocumentLineID<>0, 2 - xóa d? li?u m?i thêm DocumentLineID ==0
                        if (item.DocumentLineID > 0)
                        {
                            this.DeleteLine(item.DocumentLineID);
                        }
                    }
                }


                #endregion

                #region X? lý thu?
                if (data.AppVPO05VATViews != null)
                {
                    this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);


                    var appvpo05vatviews = data.AppVPO05VATViews.ToList();
                    var appvpo05vatviewz = data.AppVPO05VATViewz.ToList();
                    for (int i = 0; i < appvpo05vatviews.Count; i++)
                    {
                        var itemz = appvpo05vatviewz[i];
                        var item  = appvpo05vatviews[i];

                        if (itemz != -1)
                        {
                            //có 2 tru?ng h?p: 1 - thêm m?i thu?ng DocumentLineID==0, 2 - s?a d? li?u cu DocumentLineID<>0
                            item.DocumentID = data.DocumentID;
                            //item.AccountDebitLineID = data.AccountDebitID;
                            //item.AccountCreditLineID = data.AccountCreditID;
                            if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
                            {
                                item.AmountFC    = 0;
                                item.AmountVATFC = 0;
                            }


                            if (item.DocumentVATID == 0)
                            {
                                this.InsertVAT(item);
                            }
                            else
                            {
                                this.UpdateVAT(item);
                            }
                        }
                        else
                        {
                            //n?u xóa có 2 tru?ng h?p : 1 - xóa d? li?u có tru?c DocumentLineID<>0, 2 - xóa d? li?u m?i thêm DocumentLineID ==0
                            if (item.DocumentVATID > 0)
                            {
                                this.DeleteVAT(item.DocumentVATID);
                            }
                        }
                    }
                }


                #endregion

                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname);

                Services.Voucher.PostStoreProcedure(data.VoucherID, data.DocumentID);

                return(data.DocumentID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #14
0
        public long Insert(Models.AppVPO05View data)
        {
            try
            {
                data.DocumentID = 0;
                //Ki?m tra thêm m?i ch?ng t? nhu trùng s? ho?c ngày khóa s?
                this.ValidateInsert(data);
                //Ki?m tra ki?u nh?p d? li?u
                this.Validate(data);

                #region x? lý master

                data.CreatedBy       = GlobalVariant.GetAppUser().UserID;
                data.CreatedDateTime = DateTime.Now;

                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamemasteroutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
                data.DocumentID = (long)parameters.GetValueSqlParam(this._paramnamemasteroutput);

                #endregion

                #region X? lý line
                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);

                var appvpo05lineviews = data.AppVPO05LineViews.ToList();
                var appvpo05lineviewz = data.AppVPO05LineViewz.ToList();
                for (int i = 0; i < appvpo05lineviews.Count; i++)
                {
                    var itemz = appvpo05lineviewz[i];
                    if (itemz != -1)
                    {
                        var item = appvpo05lineviews[i];
                        item.DocumentID = data.DocumentID;
                        //item.AccountDebitLineID = data.AccountDebitID;
                        item.AccountCreditLineID = data.AccountCreditID;
                        item.MeasureRate         = item.MeasureRate ?? 1;
                        item.Quantity            = item.Quantity0 * item.MeasureRate;
                        if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
                        {
                            //item.Debit = 0;
                            //item.Credit = 0;
                            //item.ExchangeRateLine = 0;
                            item.AmountFC = 0;
                        }

                        this.InsertLine(item);
                    }
                }

                #endregion

                #region X? lý VAT
                if (data.AppVPO05VATViews != null)
                {
                    this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);

                    var appvpo05vatviews = data.AppVPO05VATViews.ToList();
                    var appvpo05vatviewz = data.AppVPO05VATViewz.ToList();
                    for (int i = 0; i < appvpo05vatviews.Count; i++)
                    {
                        var itemz = appvpo05vatviewz[i];
                        if (itemz != -1)
                        {
                            var item = appvpo05vatviews[i];
                            item.DocumentID = data.DocumentID;
                            //item.AccountDebitLineID = data.AccountDebitID;
                            //item.AccountCreditLineID = data.AccountCreditID;
                            if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
                            {
                                item.AmountFC    = 0;
                                item.AmountVATFC = 0;
                            }

                            this.InsertVAT(item);
                        }
                    }
                }

                #endregion

                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname);

                //Post vào sổ sách
                Services.Voucher.PostStoreProcedure(data.VoucherID, data.DocumentID);
                //cập nhật số chứng từ
                Services.Voucher.SaveVoucherNumber(data.VoucherID, data.VoucherNumber);
                return(data.DocumentID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #15
0
        public ActionResult Notification(int Id)
        {
            try
            {
                #region mail cho người dùng
                var giftcard = _dataobject.GetById(Id);

                if (giftcard == null)
                {
                    throw new Exception("phải chọn thẻ");
                }
                if (giftcard.RecipientName == null)
                {
                    throw new Exception("phải nhập tên người nhận");
                }
                if (giftcard.RecipientEmail == null)
                {
                    throw new Exception("phải nhập email người nhận");
                }


                //IWebHelper webhelper = new WebHelper(this.HttpContext);
                //var urlactive = Url.Action("RegisterActive").Remove(0, 1);
                //string RegisterActiveUrl = string.Format("{0}{1}?id={2}", webhelper.GetStoreLocation(), urlactive, user.UserId);
                string emailto = giftcard.RecipientEmail;

                // xử lí tạm cần dùng một mẫu tạm để gửi cho khách hàng
                #region thiết lập token

                GlobalToken.setToken("SenGiftCard.RecipientEmail", giftcard.RecipientEmail);
                GlobalToken.setToken("SenGiftCard.RecipientName", giftcard.RecipientName);

                GlobalToken.setToken("SenGiftCard.SenderEmail", giftcard.SenderEmail);
                GlobalToken.setToken("SenGiftCard.SenderName", giftcard.SenderName);

                GlobalToken.setToken("SenGiftCard.Message", giftcard.Message);
                GlobalToken.setToken("SenGiftCard.GiftCardCouponCode", giftcard.GiftCardCouponCode);
                GlobalToken.setToken("SenGiftCard.Amount", ExConvert.Data2String(giftcard.Amount, "numeric", "n0", ""));

                #endregion

                string SenMessageTemplate_Name = "sengiftcard.notification";


                var db = new SenContext();
                var messagetemplate = db.SenMessageTemplates.SingleOrDefault(m => m.Name == SenMessageTemplate_Name && m.IsActive == true);

                var queuedemail = new WebApp.Models.SenQueuedEmail();
                queuedemail.CreatedOnUtc   = DateTime.UtcNow;
                queuedemail.EmailAccountId = messagetemplate.EmailAccountId;
                queuedemail.From           = messagetemplate.SenEmailAccount.Email;
                queuedemail.FromName       = messagetemplate.SenEmailAccount.DisplayName;
                queuedemail.Bcc            = messagetemplate.BccEmailAddresses;
                queuedemail.Subject        = GlobalToken.MappingToken(messagetemplate.Subject);
                queuedemail.To             = emailto;
                queuedemail.ToName         = giftcard.RecipientName;
                queuedemail.Priority       = 0;
                queuedemail.Body           = GlobalToken.MappingToken(messagetemplate.Body);

                db.SenQueuedEmails.Add(queuedemail);
                db.SaveChanges();
                #endregion

                giftcard.IsRecipientNotified = true;
                _dataobject.Update(giftcard);
            }
            catch (Exception ex)
            {
                return(Json(new { ketqua = ex.Message }));
            }



            return(Json(new { ketqua = "Đã email Ok." }));
        }
Exemple #16
0
        public int Update(Models.AppFixedAssetView data)
        {
            try
            {
                this.Validate(data);

                data.ModifiedBy       = GlobalVariant.GetAppUser().UserID;
                data.ModifiedDateTime = DateTime.Now;

                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);

                #region Xử lý line
                this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);


                var AppFixedAssetLineTables = data.AppFixedAssetLineTables.ToList();
                var AppFixedAssetLineTablez = data.AppFixedAssetLineTablez.ToList();
                for (int i = 0; i < AppFixedAssetLineTables.Count; i++)
                {
                    var itemz = AppFixedAssetLineTablez[i];
                    var item  = AppFixedAssetLineTables[i];

                    if (itemz != -1)
                    {
                        //có 2 trường hợp: 1 - thêm mới thường DocumentLineID==0, 2 - sửa dữ liệu cũ DocumentLineID<>0
                        item.FixedAssetID = data.FixedAssetID;

                        if (item.FixedAssetLineID == 0)
                        {
                            this.InsertLine(item);
                        }
                        else
                        {
                            this.UpdateLine(item);
                        }
                    }
                    else
                    {
                        //nếu xóa có 2 trường hợp : 1 - xóa dữ liệu có trước DocumentLineID<>0, 2 - xóa dữ liệu mới thêm DocumentLineID ==0
                        if (item.FixedAssetLineID > 0)
                        {
                            this.DeleteLine(item.FixedAssetLineID);
                        }
                    }
                }


                #endregion


                #region Xử lý thuế
                if (data.AppEquipmentTables != null)
                {
                    this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);


                    var AppEquipmentTables = data.AppEquipmentTables.ToList();
                    var AppEquipmentTablez = data.AppEquipmentTablez.ToList();
                    for (int i = 0; i < AppEquipmentTables.Count; i++)
                    {
                        var itemz = AppEquipmentTablez[i];
                        var item  = AppEquipmentTables[i];

                        if (itemz != -1)
                        {
                            //có 2 trường hợp: 1 - thêm mới thường DocumentLineID==0, 2 - sửa dữ liệu cũ DocumentLineID<>0
                            item.FixedAssetID = data.FixedAssetID;

                            if (item.EquipmentID == 0)
                            {
                                this.InsertVAT(item);
                            }
                            else
                            {
                                this.UpdateVAT(item);
                            }
                        }
                        else
                        {
                            //nếu xóa có 2 trường hợp : 1 - xóa dữ liệu có trước DocumentLineID<>0, 2 - xóa dữ liệu mới thêm DocumentLineID ==0
                            if (item.EquipmentID > 0)
                            {
                                this.DeleteVAT(item.EquipmentID);
                            }
                        }
                    }
                }


                #endregion

                return(data.FixedAssetID);
            }
            catch (Exception)
            {
                throw;
            }
        }