public string Init() { NewMembershipFee x = new NewMembershipFee(); x.id = null; x.memberId = null; x.mo = null; x.yr = null; x.feeDate = null; x.amount = 0; x.member = new Members.NewMember(); return(JsonConvert.SerializeObject(x, Formatting.None)); }
public string Save(NewMembershipFee x) { try { using (SqlConnection connection = new SqlConnection(G.connectionString)) { connection.Open(); string sql = null; if (x.id == null) { sql = string.Format(@"INSERT INTO MembershipFees (MemberId, Mo, Yr, FeeDate, Amount) VALUES ({0}, {1}, {2}, '{3}', '{4}')", x.memberId, x.mo, x.yr, x.feeDate, x.amount); } else { sql = string.Format(@"UPDATE MembershipFees SET MemberId = {1}, Mo = {2}, Yr = {3}, FeeDate = '{4}', Amount = '{5}' WHERE Id = {0}", x.id, x.memberId, x.mo, x.yr, x.feeDate, x.amount); } using (SqlCommand command = new SqlCommand(sql, connection)) { command.ExecuteNonQuery(); } connection.Close(); } return(JsonConvert.SerializeObject("Spremljeno", Formatting.None)); } catch (Exception e) { return("Greška: " + e); } }
public string Load(int mo, int yr, int group) { try { string sql = string.Format(@"SELECT Id, FirstName, LastName FROM Members WHERE groupId = {0}", group); List <Members.NewMember> xx = new List <Members.NewMember>(); using (SqlConnection connection = new SqlConnection(G.connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Members.NewMember x = new Members.NewMember(); x.id = G.ReadI(reader, 0); x.firstName = G.ReadS(reader, 1); x.lastName = G.ReadS(reader, 2); xx.Add(x); } } } connection.Close(); } List <NewMembershipFee> xxx = new List <NewMembershipFee>(); foreach (Members.NewMember m in xx) { NewMembershipFee mf = new NewMembershipFee(); IdAmount amount = CheckAmount(m.id, mo, yr); mf.id = amount.id; mf.memberId = m.id; mf.member = m; mf.amount = amount.amount; xxx.Add(mf); } return(JsonConvert.SerializeObject(xxx, Formatting.None)); } catch (Exception e) { return(JsonConvert.SerializeObject(e.Message, Formatting.None)); } }