//================ methods to call starts IncomeNewDetails ==========================================
        public IEnumerable <IncomeAccountsTreeAccountTEMP> IncomeAccountsTreeAccountTEMP(string status)
        {
            List <IncomeAccountsTreeAccountTEMP> obuList = new List <IncomeAccountsTreeAccountTEMP>();

            using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
            {
                var cmd = new System.Data.SqlClient.SqlCommand("", con);

                //cmd.CommandText = "select * from Names where Id=@Id";
                //cmd.Parameters.AddWithValue("@Id", id);

                con.Open();
                cmd.CommandText = "select top 1000 * from Income_AccountsTree_Accounts_TEMP where ApprovalStatus=@STATUS";
                //cmd.CommandText = "select top 500 Id, accountnumber, mis, AccountOfficer_Code, ApprovalStatus from Income_accountMIS_Override_TEMP where ApprovalStatus=@STATUS";
                cmd.Parameters.AddWithValue("@STATUS", status);
                System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    var obu = new IncomeAccountsTreeAccountTEMP();

                    obu.ID               = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
                    obu.AccountNumber    = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : "";
                    obu.ShareReason      = reader["ShareReason"] != DBNull.Value ? reader["ShareReason"].ToString() : "";
                    obu.ExpirationPeriod = reader["ExpirationPeriod"] != DBNull.Value ? Int32.Parse(reader["ExpirationPeriod"].ToString()) : 0;
                    obu.ExpirationYear   = reader["ExpirationYear"] != DBNull.Value ? Convert.ToInt32(reader["ExpirationYear"].ToString()) : 0;

                    obuList.Add(obu);
                }
                con.Close();
            }
            return(obuList);
        }
Пример #2
0
        public HttpResponseMessage GetIncomeAccountsTreeAccount(HttpRequestMessage request, int ID)
        {
            return(GetHttpResponse(request, () =>
            {
                HttpResponseMessage response = null;

                IncomeAccountsTreeAccountTEMP incomeAccountsTreeAccount = _MPRCoreService.GetIncomeAccountsTreeAccountTEMP(ID);

                // notice no need to create a seperate model object since CaptionMapping entity will do just fine
                response = request.CreateResponse <IncomeAccountsTreeAccountTEMP>(HttpStatusCode.OK, incomeAccountsTreeAccount);

                return response;
            }));
        }
Пример #3
0
        public HttpResponseMessage DeleteIncomeAccountsTreeAccountTEMP(HttpRequestMessage request, [FromBody] int ID)
        {
            return(GetHttpResponse(request, () =>
            {
                HttpResponseMessage response = null;

                // not that calling the WCF service here will authenticate access to the data
                IncomeAccountsTreeAccountTEMP incomeAccountsTreeAccount = _MPRCoreService.GetIncomeAccountsTreeAccountTEMP(ID);

                if (incomeAccountsTreeAccount != null)
                {
                    _MPRCoreService.DeleteIncomeAccountsTreeAccountTEMP(ID);

                    response = request.CreateResponse(HttpStatusCode.OK);
                }
                else
                {
                    response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No IncomeAccountsTreeAccountTemp found under that ID.");
                }

                return response;
            }));
        }
Пример #4
0
        public HttpResponseMessage UpdateIncomeAccountsTreeAccountTEMP(HttpRequestMessage request, [FromBody] IncomeAccountsTreeAccountTEMP incomeAccountsTreeAccountModel)
        {
            return(GetHttpResponse(request, () =>
            {
                var incomeAccountsTreeAccount = _MPRCoreService.UpdateIncomeAccountsTreeAccountTEMP(incomeAccountsTreeAccountModel);

                return request.CreateResponse <IncomeAccountsTreeAccountTEMP>(HttpStatusCode.OK, incomeAccountsTreeAccount);
            }));
        }