//// 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); } } }
//// POST: api/Collection //public void Post([FromBody]string value) //{ //} // PUT: api/Collection/5 public void Put(int id) { if (id == 1) { //New Collection DBManage MyDBManager = new DBManage(); SqlCommand Command = null; System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; string userID_AGORASTH = string.Empty; string userID_PWLHTH = string.Empty; string SXOLIO_PWLHTH = string.Empty; string HMEROMHNIA_EKT = string.Empty; string Peridikotita = string.Empty; string POSO = string.Empty; string DOSEIS = string.Empty; int Transaction_ID = 0; int STATUS = 1; //ΕΚΚΡΕΜΕΙ int Days = 0; DateTime CalcDate; if (headers.Contains("userID_AGORASTH")) { userID_AGORASTH = headers.GetValues("userID_AGORASTH").First(); } if (headers.Contains("userID_PWLHTH")) { userID_PWLHTH = headers.GetValues("userID_PWLHTH").First(); } if (headers.Contains("SXOLIO_PWLHTH")) { SXOLIO_PWLHTH = headers.GetValues("SXOLIO_PWLHTH").First(); } if (headers.Contains("POSO")) { POSO = headers.GetValues("POSO").First(); } if (headers.Contains("DOSEIS")) { DOSEIS = headers.GetValues("DOSEIS").First(); } if (headers.Contains("HMEROMHNIA_EKT")) { HMEROMHNIA_EKT = headers.GetValues("HMEROMHNIA_EKT").First(); } if (headers.Contains("Peridikotita")) { Peridikotita = headers.GetValues("Peridikotita").First(); } string SqlString = string.Empty; int RecsAff = 0; SqlString = "i_tefteri_sp_New_Collection"; MyDBManager.CommandTimeOut = 30; MyDBManager.ConStr = Constr(); try { switch (Peridikotita) { case "κάθε μήνα": Days = 30; break; case "κάθε δυο μήνες": Days = 60; break; case "κάθε τρεις μήνες": Days = 90; break; case "κάθε τέσσερις μήνες": Days = 120; break; case "κάθε εξάμηνο": Days = 180; break; case "κάθε έτος": Days = 365; break; } MyDBManager.ConOpen(); Command = new SqlCommand(); Command.CommandText = SqlString; Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.Add("@userID_AGORASTH", SqlDbType.Int); Command.Parameters.Add("@userID_PWLHTH", SqlDbType.Int); Command.Parameters.Add("@SXOLIO_PWLHTH", SqlDbType.NVarChar); Command.Parameters.Add("@POSO", SqlDbType.Money); Command.Parameters.Add("@DOSEIS", SqlDbType.Int); Command.Parameters.Add("@STATUS", SqlDbType.Int); Command.Parameters.Add("@Transaction_id", SqlDbType.BigInt); Command.Parameters["@Transaction_id"].Direction = ParameterDirection.Output; Command.Parameters["@userID_AGORASTH"].Value = userID_AGORASTH; Command.Parameters["@userID_PWLHTH"].Value = userID_PWLHTH; Command.Parameters["@SXOLIO_PWLHTH"].Value = SXOLIO_PWLHTH; Command.Parameters["@POSO"].Value = Convert.ToDouble(POSO); Command.Parameters["@DOSEIS"].Value = DOSEIS; Command.Parameters["@STATUS"].Value = STATUS; RecsAff = MyDBManager.ExecuteCommand(Command); Transaction_ID = Convert.ToInt32(Command.Parameters["@Transaction_id"].Value.ToString()); SqlString = "i_tefteri_sp_New_Collection_DOSH"; CalcDate = DateTime.Parse(HMEROMHNIA_EKT); System.TimeSpan duration = new System.TimeSpan(Days, 0, 0, 0); for (int i = 1; i <= Convert.ToInt32(DOSEIS); i++) { Command = null; Command = new SqlCommand(); Command.CommandText = SqlString; Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.Add("@TransactionID", SqlDbType.BigInt); Command.Parameters.Add("@HMEROMHNIA_EKT", SqlDbType.Date); Command.Parameters.Add("@POSO", SqlDbType.Money); Command.Parameters["@TransactionID"].Value = Transaction_ID; Command.Parameters["@HMEROMHNIA_EKT"].Value = CalcDate; Command.Parameters["@POSO"].Value = Math.Round(Convert.ToDouble(POSO) / Convert.ToInt32(DOSEIS), 2); RecsAff = MyDBManager.ExecuteCommand(Command); CalcDate = CalcDate.Add(duration); } Write2LogFile(MyDBManager, "Controller=Collection, " + "New_Collection", 2); } catch (Exception ex) { RecsAff = Write2LogFile(MyDBManager, "Controller=Collection, " + "Error: " + ex.Message, 2); MyDBManager.ConClose(); MyDBManager = null; } } else if (id == 2) //Update Collection { DBManage MyDBManager = new DBManage(); SqlCommand Command = null; System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; string Transaction_id = String.Empty; string SXOLIO_AGORASTH = string.Empty; int STATUS = 2; //ΕΓΚΡΙΘΗΚΕ ΑΠΟ ΑΓΟΡΑΣΤΗ int Days = 0; DateTime CalcDate; if (headers.Contains("Transaction_id")) { Transaction_id = headers.GetValues("Transaction_id").First(); } if (headers.Contains("SXOLIO_AGORASTH")) { SXOLIO_AGORASTH = headers.GetValues("SXOLIO_AGORASTH").First(); } string SqlString = string.Empty; int RecsAff = 0; SqlString = "i_tefteri_sp_Update_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("@Transaction_id", SqlDbType.BigInt); Command.Parameters.Add("@SXOLIO_AGORASTH", SqlDbType.NVarChar); Command.Parameters["@Transaction_id"].Value = Transaction_id; Command.Parameters["@SXOLIO_AGORASTH"].Value = SXOLIO_AGORASTH; RecsAff = MyDBManager.ExecuteCommand(Command); Write2LogFile(MyDBManager, "Controller=Collection, " + "Update_Collection", 2); } catch (Exception ex) { RecsAff = Write2LogFile(MyDBManager, "Controller=Collection, " + "Error: " + ex.Message, 2); MyDBManager.ConClose(); MyDBManager = null; } } }