public static void MapModuletoApplication(string listId, string attributename, int ordinalposition)
{
Mappedmodule Model = new Mappedmodule();
Guid id = Guid.NewGuid();
ModulesModel moduleobj = listModulesModel.Single(s => s.module_id == attributename);
Model.applicationmodulemapping_id = id.ToString();
Model.application_id = ApplicationId;
Model.module_id = attributename;
Model.displayname = moduleobj.modulename;
Model.isdefaultmodule = false;
if (listMappedmodules.Count == 0)
{
Model.displayorder = 1;
}
else
{
Model.displayorder = listMappedmodules.Max(x => x.displayorder.Value) + 1;
}
string results = APIservice.PostObject <Mappedmodule>(Model, "synapsenamespace=meta&synapseentityname=applicationmodulemapping");
listMappedmodules = APIservice.GetListById <Mappedmodule>(ApplicationId, "synapsenamespace=meta&synapseentityname=applicationmodulemapping&synapseattributename=application_id&attributevalue=").OrderBy(o => o.displayorder).ToList();;
}
private List <WardModel> GetWards()
{
string token = HttpContext.Session.GetString("access_token");
return(APIservice.GetList <WardModel>("synapsenamespace=meta&synapseentityname=ward", token).OrderBy(w => w.warddisplay).ToList());
}
private List <LocationType> GetLocationTypes()
{
string token = HttpContext.Session.GetString("access_token");
return(APIservice.GetList <LocationType>("synapsenamespace=meta&synapseentityname=locationtype", token).OrderBy(l => l.locationtypetext).ToList());
}
/// <summary>
/// Check Application Name
/// </summary>
/// <returns></returns>
private int GetApplication()
{
List <ApplicationModule> resultj = APIservice.GetList <ApplicationModule>("synapsenamespace=meta&synapseentityname=application");
return(resultj.Where(x => x.applicationname == txtApplication.Text.Trim()).Count());
}
public ActionResult AddEditWard(WardModel wardModel)
{
string token = HttpContext.Session.GetString("access_token");
string context = string.Empty;
string sql = string.Empty;
if (wardModel.ward_id is null)
{
List <WardModel> ward = APIservice.GetListById <WardModel>(wardModel.wardcode,
"synapsenamespace=meta&synapseentityname=ward&synapseattributename=wardcode&attributevalue=", token);
if (ward.Count > 0)
{
this.toastNotification.AddErrorToastMessage("Ward Code already exists for the ward.");
wardModel = null;
return(View("Edit", wardModel));
}
context = "ADD";
wardModel.ward_id = System.Guid.NewGuid().ToString();
}
else
{
context = "UPDATE";
}
string result = APIservice.PostObject <WardModel>(wardModel, "synapsenamespace=meta&synapseentityname=ward", token);
if (result == "OK")
{
if (context == "ADD")
{
sql = "INSERT INTO entitystorematerialised.meta_personacontext(personacontext_id, displayname, contextname, persona_id, displayorder) ";
sql += "SELECT ward_id, warddisplay, wardcode, '4', ROW_NUMBER() OVER(ORDER BY warddisplay) FROM entitystorematerialised.meta_ward ";
sql += "WHERE wardcode = @wardcode;";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("wardcode", wardModel.wardcode)
};
DataServices.executeSQLStatement(sql, paramList);
}
else
{
sql = "UPDATE entitystorematerialised.meta_personacontext SET displayname = @warddisplay WHERE contextname = @wardcode";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("warddisplay", wardModel.warddisplay),
new KeyValuePair <string, string>("wardcode", wardModel.wardcode)
};
DataServices.executeSQLStatement(sql, paramList);
}
this.toastNotification.AddSuccessToastMessage("Ward is successfully saved.");
}
else
{
this.toastNotification.AddErrorToastMessage("Error while saving ward details.");
}
return(View("Edit", wardModel));
}
private int GetModules()
{
List <ModulesModel> resultj = APIservice.GetList <ModulesModel>("synapsenamespace=meta&synapseentityname=module");
return(resultj.Where(x => x.modulename == txtmodulename.Text.Trim()).Count());
}
