コード例 #1
0
        private void Create()
        {
            newEntity = new WithdrawalEntity();

            newEntity.Amount = Convert.ToDecimal(this.txtAmount.Text.Trim());
            newEntity.Date = Convert.ToDateTime(this.txtDate.Text.Trim());
            newEntity.Userid = GlobalObjects.User.ID;
            newEntity.Notes = this.txtNotes.Text.Trim();
            newEntity.Status = 1;

            newService.Save(ActionType.Create, newEntity,1);

            Response.Redirect("ManageExpenses.aspx");
        }
コード例 #2
0
        private WithdrawalEntity SetData(DataRow oRow)
        {
            try
            {
                WithdrawalEntity ent = new WithdrawalEntity();
                ent.ID = Convert.ToInt32(oRow["id"]);
                ent.Amount = Convert.ToDecimal(oRow["amount"]);
                ent.Userid = Convert.ToInt32(oRow["user_id"]);
                ent.Date = Convert.ToDateTime(oRow["date"]);
                ent.Notes = oRow["notes"].ToString();
                ent.Status = Convert.ToInt32(oRow["status"]);

                return ent;

            }
            catch (Exception ex) { throw ex; }
        }
コード例 #3
0
        public void Save(ActionType type, WithdrawalEntity ent, int remType = 0)
        {
            try
            {

                using (Database db = new Database(GlobalObjects.CONNECTION_STRING))
                {
                    db.Open();
                    int ret = 0;
                    int typ = (int)type;
                    string sql = "SaveWithdrawals";
                    string[] asParams;
                    DbType[] atParamTypes;
                    object[] aoValues;

                    asParams = new string[] {   "@actiontype",
                                                "@id",
                                                "@userid",
                                                "@amount",
                                                "@date",
                                                "@notes",
                                                "@remType",
                                                "@status",
                                                "@createdby",
                                                "@createddate",
                                                "@updatedby",
                                                "@updateddate"};

                    atParamTypes = new DbType[] {
                                                    DbType.Int16,
                                                    DbType.Int32,
                                                    DbType.Int32,
                                                    DbType.Decimal,
                                                    DbType.Date,
                                                    DbType.String,
                                                    DbType.Int16,
                                                    DbType.Int32,
                                                    DbType.String,
                                                    DbType.DateTime,
                                                    DbType.String,
                                                    DbType.DateTime };

                    aoValues = new object[] {
                                                typ,
                                                ent.ID,
                                                ent.Userid,
                                                ent.Amount,
                                                ent.Date,
                                                ent.Notes,
                                                remType,
                                                ent.Status,
                                                appUsr.UserName,
                                                DateTime.Now,
                                                appUsr.UserName,
                                                DateTime.Now
                                            };

                    db.ExecuteCommandNonQuery(sql, asParams, atParamTypes, aoValues, out ret, CommandTypeEnum.StoredProcedure);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #4
0
        public WithdrawalEntity GetOne(int userId)
        {
            try
            {

                using (Database db = new Database(GlobalObjects.CONNECTION_STRING))
                {
                    db.Open();
                    string sql;
                    int ret = 0;
                    DataTable oTable = new DataTable();
                    sql = "GetWithdrawal";
                    db.ExecuteCommandReader(sql,
                        new string[] { "@id" },
                        new DbType[] { DbType.Int32 },
                        new object[] { userId },
                        out ret, ref oTable, CommandTypeEnum.StoredProcedure);

                    WithdrawalEntity user = new WithdrawalEntity();
                    if (oTable.Rows.Count > 0)
                    {
                        DataRow oRow = oTable.Rows[0];
                        user = SetData(oRow);

                    }

                    return user;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        private void PopulateFields(int id)
        {
            newEntity = new WithdrawalEntity();
            newEntity = newService.GetOne(id);

            this.txtDate.Text = newEntity.Date.ToString("yyyy-MM-dd");
            this.txtNotes.Text = newEntity.Notes;
            this.txtAmount.Text = newEntity.Amount.ToString();

            //ddlInvestor.Enabled = false;
            //txtDate.Enabled = false;
            //this.txtAmount.Enabled = false;
        }
コード例 #6
0
        private void Update()
        {
            newEntity = new WithdrawalEntity();

            newEntity.ID = id;
            newEntity.Notes = this.txtNotes.Text.Trim();
            newEntity.Date = Convert.ToDateTime(txtDate.Text);
            newService.Save(ActionType.Update, newEntity);

            Response.Redirect("ManageExpenses.aspx");
        }
コード例 #7
0
        private void Create()
        {
            newEntity = new WithdrawalEntity();

            newEntity.Amount = Convert.ToDecimal(this.txtAmount.Text.Trim());
            newEntity.Date = Convert.ToDateTime(this.txtDate.Text.Trim());
            newEntity.Userid = Convert.ToInt32(ddlInvestor.SelectedValue);
            newEntity.Notes = this.txtNotes.Text.Trim();
            newEntity.Status = 1;

            newService.Save(ActionType.Create, newEntity,0);

            Response.Redirect("ManageWithdrawals.aspx");
        }