public String AddNewKeyData(string username, string gid, string new_key, string vn)
{
int group_id_int = int.Parse(gid);
int version_no_int = int.Parse(vn);
using (MlaDatabaseEntities context = new MlaDatabaseEntities()) {
try
{
Group_Key_Table new_data = new Group_Key_Table
{
username = username,
groupKey = new_key,
groupid = group_id_int,
version_num = version_no_int
};
context.Group_Key_Table.Add(new_data);
if (context.SaveChanges() > 0)
{
return("ok");
}
else
{
return("add failed");
}
}catch (Exception e)
{
return(e.ToString());
}
}
}
//public String PostUser(string username, string password, string emailid, string firstname, string lastname, string mobile)
public String PostUser(User user, string defaultGroupKey)
{
string query_status;
using (MlaDatabaseEntities context = new MlaDatabaseEntities())
{
try
{
context.Users.Add(user);
int?maxGroupID = (int?)context.Group_Status_Table.Max(g => (int?)g.groupid);
Group_Status_Table gst = new Group_Status_Table
{
groupid = (maxGroupID == null) ? 1 : (int)maxGroupID + 1,
groupname = user.username + "Friends",
status = 0
};
context.Group_Status_Table.Add(gst);
Group_Table gt = new Group_Table
{
username = user.username,
groupid = gst.groupid,
groupname = gst.groupname,
isFriend = "yes",
isOwner = "yes"
};
context.Group_Table.Add(gt);
Group_Key_Table gk = new Group_Key_Table {
username = user.username,
groupKey = defaultGroupKey,
groupid = gst.groupid,
version_num = 1
};
context.Group_Key_Table.Add(gk);
int x = context.SaveChanges();
if (x > 0)
{
query_status = "OK";
return(query_status);
}
else
{
query_status = "failed";
return(query_status);
}
}
catch (Exception e)
{
query_status = e.ToString();
return(query_status);
}
}
}
public string AcceptGroupRequest(Group_Key_Table group_key_table, string gname, string owner)
{
string query_result = "failed";
using (MlaDatabaseEntities context = new MlaDatabaseEntities())
{
string s = "";
try
{
context.Group_Key_Table.Add(group_key_table);
s += "group_key_added ";
Group_Table group_table = new Group_Table
{
username = group_key_table.username,
groupid = group_key_table.groupid,
groupname = gname,
isOwner = "no",
isFriend = "no"
};
context.Group_Table.Add(group_table);
s += "group_table_added ";
var rawToRemove = context.Group_Invitation_Table.Single(t => t.username_from == group_key_table.username &&
t.username_to == owner &&
t.groupid == group_key_table.groupid);
context.Group_Invitation_Table.Remove(rawToRemove);
s += "removed_raw ";
if (context.SaveChanges() > 0)
{
query_result = "ok";
return(query_result);
}
else
{
return(s + query_result);
}
}
catch (Exception e)
{
query_result = s + e.ToString();
return(query_result);
}
}
}
