public static List <AudioTierRating> GetRatings() { ISession session = SessionManager.GetSession(); List <AudioTierRating> list = new List <AudioTierRating>(); if (session == null) { return(null); } var ratings = session.Execute("select * from \"AudioTierRating\""); foreach (var data in ratings) { AudioTierRating rate = new AudioTierRating(); rate.description = data["description"] != null ? data["description"].ToString() : string.Empty; rate.evaluation = (double)(data["evaluation"] != null ? data["evaluation"] : 0); rate.customer_name = data["customer_name"] != null ? data["customer_name"].ToString() : string.Empty; rate.customer_surname = data["customer_surname"] != null ? data["customer_surname"].ToString() : string.Empty; rate.customer_email = data["customer_email"] != null ? data["customer_email"].ToString() : string.Empty; rate.platform = data["platform"] != null ? data["platform"].ToString() : string.Empty; list.Add(rate); } return(list); }
public static void AddRate(AudioTierRating rate) { ISession session = SessionManager.GetSession(); if (session == null) { return; } RowSet data = session.Execute("insert into \"AudioTierRating\" (description,evaluation,customer_name,customer_surname,customer_email,platform) values ('" + rate.description + "'," + rate.evaluation + ",'" + rate.customer_name + "','" + rate.customer_surname + "','" + rate.customer_email + "','" + rate.platform + "')"); }
private void btnSubmit_Click_1(object sender, EventArgs e) { AudioTierRating atr = new AudioTierRating(); atr.description = tbDescription.Text; atr.evaluation = Double.Parse(tbEvaluation.Text); atr.platform = audioPlatform; atr.customer_email = customer.email; atr.customer_name = customer.name; atr.customer_surname = customer.surname; DataProvider.AddRate(atr); this.Hide(); }
public static AudioTierRating GetAudioTierRating(string desc, string email) { ISession session = SessionManager.GetSession(); AudioTierRating rate = new AudioTierRating(); if (session == null) { return(null); } Row data = session.Execute("select * from \"AudioTierRaiting\" where description='" + desc + "' and customer_email='" + email + "'").FirstOrDefault(); if (data != null) { rate.description = data["description"] != null ? data["description"].ToString() : string.Empty; rate.evaluation = (double)(data["evaluation"] != null ? data["evaluation"] :0); rate.customer_name = data["customer_name"] != null ? data["customer_name"].ToString() : string.Empty; rate.customer_surname = data["customer_surname"] != null ? data["customer_surname"].ToString() : string.Empty; rate.customer_email = data["customer_email"] != null ? data["customer_email"].ToString() : string.Empty; rate.platform = data["platform"] != null ? data["platform"].ToString() : string.Empty; } return(rate); }