//// GET: api/Collection //public IEnumerable<string> Get() //{ // return new string[] { "value1", "value2" }; //} // GET: api/Collection/5 public List <Collection> Get(int id) { DBManage MyDBManager = new DBManage(); SqlCommand Command = null; SqlDataReader Reader = null; List <Collection> User_Collection = new List <Collection>(); string SqlString = string.Empty; int RecsAff = 0; SqlString = "i_tefteri_sp_Get_Collection"; MyDBManager.CommandTimeOut = 30; MyDBManager.ConStr = Constr(); try { MyDBManager.ConOpen(); Command = new SqlCommand(); Command.CommandText = SqlString; Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.Add("@UserID", SqlDbType.Int); Command.Parameters["@UserID"].Value = id; Reader = MyDBManager.ExecuteReader(Command); while (Reader.Read()) { Collection MyCollection = new Collection(); MyCollection.PersonID = Reader["UserID"].ToString(); MyCollection.PersonName = Reader["iBankuserID"].ToString(); MyCollection.TransDate = Reader["HMEROMHNIA"].ToString(); MyCollection.ActualDate = Reader["HMEROMHNIA_EKT"].ToString(); String.Format(MyCollection.TransAmount = Reader["POSO"].ToString(), "#,##0.00"); MyCollection.DOSEIS = Reader["DOSEIS"].ToString(); MyCollection.TransactionID = Reader["TransactionID"].ToString(); User_Collection.Add(MyCollection); MyCollection = null; } Reader.Close(); Reader = null; Command = null; Write2LogFile(MyDBManager, "Controller=Collection, " + "Get Users Collection", 1); MyDBManager.ConClose(); MyDBManager = null; return(User_Collection); } catch { return(User_Collection); } }
//// GET: api/Users //public IEnumerable<string> Get() //{ // return new string[] { "value1", "value2" }; //} // GET: api/Users/5 public List <Person> Get(int id) { System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; DBManage MyDBManager = new DBManage(); SqlCommand Command = null; SqlDataReader Reader = null; List <Person> Person = new List <Person>(); string SqlString = string.Empty; int RecsAff = 0; SqlString = "i_tefteri_sp_Get_Active_Users"; MyDBManager.CommandTimeOut = 30; MyDBManager.ConStr = Constr(); if (id == -1) { try { if (headers.Contains("Currentuser")) { string user = headers.GetValues("Currentuser").First(); } MyDBManager.ConOpen(); Command = new SqlCommand(); Command.CommandText = SqlString; Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.Add("@What2Do", SqlDbType.VarChar, 50); //Command.Parameters.Add("@Mobile_Num", SqlDbType.VarChar, 12); Command.Parameters["@What2Do"].Value = "All Person"; //Command.Parameters["@Mobile_Num"].Value = id; Reader = MyDBManager.ExecuteReader(Command); while (Reader.Read()) { Person MyPerson = new Person(); MyPerson.UserID = Convert.ToInt32(Reader["UserID"]); MyPerson.iBankuserID = Reader["iBankuserID"].ToString(); MyPerson.BASIKOS_LOGAR = Reader["BASIKOS_LOGAR"].ToString(); Person.Add(MyPerson); MyPerson = null; } Reader.Close(); Reader = null; Command = null; Write2LogFile(MyDBManager, "Controller=Users, " + "Get ALL Active Users", 1); MyDBManager.ConClose(); MyDBManager = null; //var jsonSerialiser = new JavaScriptSerializer(); //var json = jsonSerialiser.Serialize(Person); return(Person);//JsonConvert.SerializeObject(Person); } catch (Exception ex) { Person MyPerson = new Person(); RecsAff = Write2LogFile(MyDBManager, "Controller=Users, " + "Error: " + ex.Message, 1); MyDBManager.ConClose(); MyDBManager = null; MyPerson.iBankuserID = "Error"; Person.Add(MyPerson); return(Person); } } else { try { string Currentuser = string.Empty; if (headers.Contains("Currentuser")) { Currentuser = headers.GetValues("Currentuser").First(); } MyDBManager.ConOpen(); Command = new SqlCommand(); Command.CommandText = SqlString; Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.Add("@What2Do", SqlDbType.VarChar, 50); //Command.Parameters.Add("@Mobile_Num", SqlDbType.VarChar, 12); Command.Parameters["@What2Do"].Value = Currentuser; //Command.Parameters["@Mobile_Num"].Value = id; Reader = MyDBManager.ExecuteReader(Command); while (Reader.Read()) { Person MyPerson = new Person(); MyPerson.UserID = Convert.ToInt32(Reader["UserID"]); MyPerson.iBankuserID = Reader["iBankuserID"].ToString(); MyPerson.BASIKOS_LOGAR = Reader["BASIKOS_LOGAR"].ToString(); Person.Add(MyPerson); MyPerson = null; } Reader.Close(); Reader = null; Command = null; Write2LogFile(MyDBManager, "Controller=Users, " + "Get 1 Active Users", 1); MyDBManager.ConClose(); MyDBManager = null; //var jsonSerialiser = new JavaScriptSerializer(); //var json = jsonSerialiser.Serialize(Person); return(Person);//JsonConvert.SerializeObject(Person); } catch (Exception ex) { Person MyPerson = new Person(); RecsAff = Write2LogFile(MyDBManager, "Controller=Users, " + "Error: " + ex.Message, 1); MyDBManager.ConClose(); MyDBManager = null; MyPerson.iBankuserID = "Error"; Person.Add(MyPerson); return(Person); } } }