public Generic2C()
{
Type t = typeof(Generic <T>);
dal = DataAccessGeneric <T> .CreateSession(t.FullName);
t = typeof(Generic <TDesc>);
dalDesc = DataAccessGeneric <TDesc> .CreateSession(t.FullName);
}
public UploadImageBLL()
{
Type t = typeof(Cb.SQLServerDAL.Generic <PNK_UploadImage>);
dal = DataAccessGeneric <PNK_UploadImage> .CreateSession(t.FullName);
switch (ConfigurationManager.AppSettings["Database"])
{
case "SQLServer":
prefixParam = "@";
break;
case "MySQL":
prefixParam = "v_";
break;
}
}
static async Task MainAsync(string[] args)
{
DataAccessGeneric checkHomeworks = new DataAccessGeneric(1);
List <Student> listOfStudents = await checkHomeworks.getListOfStudentsTask31();
//In case there are no results, print another message
if (listOfStudents.Count() == 0 || listOfStudents == null)
{
Console.WriteLine("There are no elements returned by the exercise");
Console.ReadLine();
}
else
{
//All documents will be displayed
foreach (var student in listOfStudents)
{
Console.WriteLine("Student ID: " + student.Id + ", Name: " + student.Name + ", Score Type: " + student.Grades[2].Type.ToString() + " / Score: " + student.Grades[2].Score);
}
//Displays answer
}
}
//UPDATE
public async Task <ProcessRevisionModel> LockRevision(PassBackProcessRevStepSeqModel aPassBackModel)
{
return(await DataAccessGeneric.HttpPostRequest <ProcessRevisionModel, PassBackProcessRevStepSeqModel>(Config["APIAddress"] + "api/processes/UpdateRevSaveAndLock/", aPassBackModel, _httpContextAccessor.HttpContext));
}
//DELETE
public async Task <string> DeleteProcessRevision(int aProcessId, int aProcessRevId) //This will return the response from the API in string format.
{
return(await DataAccessGeneric.HttpDeleteRequest(Config["APIAddress"] + "api/processes/DeleteProcessRevision/" + aProcessId + "/" + aProcessRevId, _httpContextAccessor.HttpContext));
}
public async Task <int> CreateNewHydratedSpec(SpecModel aSpecModel)
{
return(await DataAccessGeneric.HttpPostRequest <int, SpecModel>(Config["APIAddress"] + "api/spec/CreateNewSpec", aSpecModel, _httpContextAccessor.HttpContext));
}
public async Task <OrderHeadModel> GetOrderHeadById(int anOrderId)
{
var result = await DataAccessGeneric.HttpGetRequest <OrderHeadModel>(Config["APIAddress"] + "api/OrderHead/GetHydratedOrderHead/" + anOrderId, _httpContextAccessor.HttpContext);
return(result);
}
public async Task <IEnumerable <PartModel> > GetPartForCustId(int aCustId)
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <PartModel> >(Config["APIAddress"] + "api/Part/GetPartsForCustId/" + aCustId, _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <ShipToModel> > GetShipToByCustId(int aCustId)
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <ShipToModel> >(Config["APIAddress"] + "api/ShipTo/GetShipTosByCust/" + aCustId, _httpContextAccessor.HttpContext));
}
//Since each step seq model has the revisionId and processId already in it, there is no need to pass that information in.
public async Task <ProcessRevisionModel> SaveStepSeqToRevision(List <StepSeqModel> aProcessRevModel)
{
return(await DataAccessGeneric.HttpPostRequest <ProcessRevisionModel, List <StepSeqModel> >(Config["APIAddress"] + "api/processes/UpdateStepsForRev", aProcessRevModel, _httpContextAccessor.HttpContext));
}
//public Task<OrderHeadModel> GetHydratedOrderHeadById(int anOrderId)
//{
// return await DataAccessGeneric.HttpGetRequest<OrderHeadModel>(Config["APIAddress"] + "api/OrderHead/")
//}
public async Task <OrderHeadModel> PostOrderHead(OrderHeadModel anOrderHeadModel)
{
return(await DataAccessGeneric.HttpPostRequest <OrderHeadModel>(Config["APIAddress"] + "api/processes/postprocess", anOrderHeadModel, _httpContextAccessor.HttpContext));
}
//CREATE
public async Task <ProcessModel> PostNewProcess(ProcessModel aProcessModel)
{
return(await DataAccessGeneric.HttpPostRequest <ProcessModel>(Config["APIAddress"] + "api/processes/postprocess", aProcessModel, _httpContextAccessor.HttpContext));
}
public async Task <ProcessRevisionModel> RevUp(ProcessRevisionModel aProcessRevModel)
{
return(await DataAccessGeneric.HttpPostRequest <ProcessRevisionModel>(Config["APIAddress"] + "api/processes/PostNewRev", aProcessRevModel, _httpContextAccessor.HttpContext));
}
public async Task <bool> CheckIfCodeIsUnique(string aSpecCode)
{
return(await DataAccessGeneric.HttpGetRequest <bool>(Config["APIAddress"] + "api/spec/CheckIfCodeIsUnique/" + aSpecCode, _httpContextAccessor.HttpContext));
}
public async Task <int> RevUpSpec(SpecRevModel aSpecModel)
{
return(await DataAccessGeneric.HttpPostRequest <int, SpecRevModel>(Config["APIAddress"] + "api/Spec/RevUpSpec", aSpecModel, _httpContextAccessor.HttpContext));
}
public async Task <SpecModel> GetHydratedCurrentRevOfSpec(int aSpecId)
{
return(await DataAccessGeneric.HttpGetRequest <SpecModel>(Config["APIAddress"] + "api/spec/GetHydratedCurrentRevOfSpec/" + aSpecId, _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <OperationGroupModel> > GetAllOperationGroups()
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <OperationGroupModel> >(Config["APIAddress"] + "api/operation/GetAllOperationGroups", _httpContextAccessor.HttpContext));
}
public async Task <ProcessModel> CopyToNewProcessFromExisting(ProcessModel aProcessModel)
{
return(await DataAccessGeneric.HttpPostRequest <ProcessModel>(Config["APIAddress"] + "api/Processes/CopyNewProcessFromExisting", aProcessModel, _httpContextAccessor.HttpContext));
}
public async Task <OperationModel> UpdateOperation(OperationModel anOperationModel)
{
return(await DataAccessGeneric.HttpPutRequest <OperationModel>(Config["APIAddress"] + "api/operation/UpdateOperation", anOperationModel, _httpContextAccessor.HttpContext));
}
public async Task <ProcessModel> GetHydratedProcess(int id)
{
return(await DataAccessGeneric.HttpGetRequest <ProcessModel>(Config["APIAddress"] + "api/Processes/GetProcess/" + id, _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <PartModel> > GetAllPartsWithRack()
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <PartModel> >(Config["APIAddress"] + "api/Part/GetAllPartsWithRacks", _httpContextAccessor.HttpContext));
}
public async Task <bool> CheckIfDescriptionIsUnique(string anAlloyDescription)
{
return(await DataAccessGeneric.HttpGetRequest <bool>(Config["APIAddress"] + "api/MaterialAlloy/CheckIfDescriptionIsUnique/" + anAlloyDescription, _httpContextAccessor.HttpContext));
}
public async Task <PartModel> CreatePart(PartModel aPart)
{
return(await DataAccessGeneric.HttpPostRequest <PartModel>(Config["APIAddress"] + "api/Part/CreatePart", aPart, _httpContextAccessor.HttpContext));
}
public async Task <MaterialSeriesModel> CreateMaterialSeries(MaterialSeriesModel aMaterialSeriesModel)
{
return(await DataAccessGeneric.HttpPostRequest <MaterialSeriesModel>(Config["APIAddress"] + "api/MaterialSeries/CreateMaterialSeries", aMaterialSeriesModel, _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <ProcessModel> > GetHydratedProcessesWithCurrentAnyRev()
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <ProcessModel> >(Config["APIAddress"] + "api/Processes/GetHydratedProcessesWithCurrentAnyRev", _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <SpecModel> > GetAllHydratedSpecsWithOnlyCurrentRev()
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <SpecModel> >(Config["APIAddress"] + "api/spec/GetAllHydratedSpecsWithOnlyCurrentRev", _httpContextAccessor.HttpContext));
}
public async Task <IEnumerable <MaterialSeriesModel> > GetAllMaterialSeries()
{
return(await DataAccessGeneric.HttpGetRequest <IEnumerable <MaterialSeriesModel> >(Config["APIAddress"] + "api/MaterialSeries/GetAllMaterialSeries", _httpContextAccessor.HttpContext));
}
public async Task <ProcessRevisionModel> GetHydratedCurrentProcessRev(int aProcessId)
{
return(await DataAccessGeneric.HttpGetRequest <ProcessRevisionModel>(Config["APIAddress"] + "api/Processes/GetProcessCurrentHydratedRev/" + aProcessId, _httpContextAccessor.HttpContext));
}
public XMLConfigBLL()
{
Type t = typeof(Cb.SQLServerDAL.Generic <sd_XML>);
generic = DataAccessGeneric <sd_XML> .CreateSession(t.FullName);
}
public async Task <bool> CheckIfNameIsUnique(string aProcessName)
{
return(await DataAccessGeneric.HttpGetRequest <bool>(Config["APIAddress"] + "api/Processes/CheckIfNameIsUnique/" + aProcessName, _httpContextAccessor.HttpContext));
}
