private void StoreProjectMembers()
{
if (MemberList.Count > 0)
{
var sql = "delete from ProjectMembers where ProjectKey = '<ProjectKey>'";
sql = sql.Replace("<ProjectKey>", ProjectKey);
DBUtility.ExeLocalSqlNoRes(sql);
}
foreach (var item in MemberList)
{
var sql = "insert into ProjectMembers(ProjectKey,Name,Role) values('<ProjectKey>','<Name>','<Role>')";
sql = sql.Replace("<ProjectKey>", ProjectKey).Replace("<Name>", item.Name).Replace("<Role>", item.Role);
DBUtility.ExeLocalSqlNoRes(sql);
UserViewModels.UpdateUserProject(item.Name.ToUpper(), ProjectKey);
}
}
