/// <summary>
/// Saves changes in database and close window.
/// </summary>
private void SaveAndCloseWindowButton(object sender, RoutedEventArgs e)
{
EditPolicy.InDatabaseChange(policyNumberTextField.Text, editDate.DisplayDate,
userComboboxField.SelectedValue.ToString(), brokerNameTextField.Text);
this.Close();
}
public EstablishmentEditPolicyEnvelope Initialise(EstablishmentModel establishment)
{
EditPolicy.Initialise(establishment);
return(this);
}
public RESTStatus EditPolicy(SQLLib sql, EditPolicy request, NetworkConnectionInfo ni, Int64 id)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
lock (ni.sqllock)
{
if (Policies.PolicyExsits(sql, id) == false)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
}
if (id != request.ID)
{
ni.Error = "Invalid data";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
if (request.DataOnly == false)
{
if (request.Name == null || request.Name.Trim() == "")
{
ni.Error = "Invalid name";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
request.Name = request.Name.Trim();
if (request.Grouping != null && request.MachineID != null)
{
ni.Error = "Either Grouping OR MachineID should be set";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
if (request.Grouping != null)
{
lock (ni.sqllock)
{
if (Groups.GroupExsits(sql, request.Grouping.Value) == false)
{
ni.Error = "Group does not exists";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
}
}
if (request.MachineID != null)
{
lock (ni.sqllock)
{
if (Computers.MachineExists(sql, request.MachineID) == false)
{
ni.Error = "MachineID does not exists";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
}
}
}
try
{
JsonConvert.DeserializeObject(request.Data);
}
catch
{
ni.Error = "JSON error";
ni.ErrorID = ErrorFlags.InvalidData;
return(RESTStatus.Fail);
}
try
{
if (request.DataOnly == false)
{
lock (ni.sqllock)
{
sql.ExecSQL("Update Policies SET Name=@n, Grouping=@g, MachineID=@m, DataBlob=@blob, DT=Getutcdate(), Version=Version+1 WHERE ID=@id",
new SQLParam("@id", request.ID),
new SQLParam("@n", request.Name),
new SQLParam("@g", request.Grouping),
new SQLParam("@m", request.MachineID),
new SQLParam("@blob", request.Data));
}
}
else
{
lock (ni.sqllock)
{
sql.ExecSQL("Update Policies SET DataBlob=@blob, DT=Getutcdate(), Version=Version+1 WHERE ID=@id",
new SQLParam("@id", request.ID),
new SQLParam("@blob", request.Data));
}
}
}
catch
{
ni.Error = "SQL Error";
ni.ErrorID = ErrorFlags.SQLError;
return(RESTStatus.ServerError);
}
return(RESTStatus.Success);
}
