Пример #1
0
        public int PrcUpdateEarnings(ExpenseModel bExpenseModel)
        {
            Command = new SqlCommand(Query, Connection);
            Connection.Open();
            Query = "Update tblExpense set Amount='" + bExpenseModel.Amount + "',Comments='" + bExpenseModel.Comment + "',ExpenseType='" + bExpenseModel.ExpenseType + "'," +
                    "ExpenseName='" + bExpenseModel.ExpenseName + "',DtExpense='" + bExpenseModel.DtExpense + "' where Id='" + bExpenseModel.ExpenseId + "'";
            Command = new SqlCommand(Query, Connection);
            int rowAffected = Command.ExecuteNonQuery();

            Connection.Close();
            return(rowAffected);
        }
Пример #2
0
        public List <ExpenseModel> PrcGetExpenseTypes()
        {
            List <ExpenseModel> expenseTypeList = new List <ExpenseModel>();

            Query   = "Select varName from tblCat_Variable where varType='Expense'";
            Command = new SqlCommand(Query, Connection);
            Connection.Open();
            Reader = Command.ExecuteReader();
            while (Reader.Read())
            {
                ExpenseModel aExpenseModel = new ExpenseModel();
                aExpenseModel.ExpenseType = Reader["varName"].ToString();
                expenseTypeList.Add(aExpenseModel);
            }
            Reader.Close();
            Connection.Close();
            return(expenseTypeList);
        }
Пример #3
0
        public int PrcSaveExpense(ExpenseModel aExpenseModel)
        {
            int newId = 0;

            Query   = "Select IsNull(max(Id),0)+1 as Id from tblExpense";
            Command = new SqlCommand(Query, Connection);
            Connection.Open();
            Reader = Command.ExecuteReader();
            while (Reader.Read())
            {
                newId = Convert.ToInt32(Reader["Id"]);
            }
            Reader.Close();
            Query = "Insert into tblExpense Values('" + newId + "','" + aExpenseModel.ExpenseName + "','" + aExpenseModel.DtExpense + "','" + aExpenseModel.ExpenseType + "'" +
                    ",'" + aExpenseModel.Comment + "','" + aExpenseModel.Amount + "')";
            Command = new SqlCommand(Query, Connection);
            int rowAffected = Command.ExecuteNonQuery();

            Connection.Close();
            return(rowAffected);
        }
Пример #4
0
        public List <ExpenseModel> PrcGetExpenseList(string date)
        {
            List <ExpenseModel> expenseList = new List <ExpenseModel>();

            Query   = "Exec prcGetExpenseDetails '" + date + "'";
            Command = new SqlCommand(Query, Connection);
            Connection.Open();
            Reader = Command.ExecuteReader();
            while (Reader.Read())
            {
                ExpenseModel bExpenseModel = new ExpenseModel();
                bExpenseModel.ExpenseId   = Convert.ToInt32(Reader["Id"]);
                bExpenseModel.ExpenseType = Reader["ExpenseType"].ToString();
                bExpenseModel.ExpenseName = Reader["ExpenseName"].ToString();
                bExpenseModel.Amount      = Convert.ToInt32(Reader["Amount"]);
                bExpenseModel.DtExpense   = Reader["DtExpense"].ToString();
                bExpenseModel.Comment     = Reader["Comments"].ToString();
                expenseList.Add(bExpenseModel);
            }
            Reader.Close();
            Connection.Close();
            return(expenseList);
        }