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)); }
}
