public async Task <ProjectInfo> GetProject(ProjectInfo objInfo)
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@ProjectID", objInfo.ProjectID));
string strSpName = "usp_GetProject";
SQLHandlerAsync sqlHAsy = new SQLHandlerAsync();
//List<ProjectInfo> objList = await sqlHAsy.ExecuteAsListAsync<ProjectInfo>(strSpName, Param);
return(await sqlHAsy.ExecuteAsObjectAsync <ProjectInfo>(strSpName, Param));
}
public async Task <int> AddProject(ProjectInfo objInfo)
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@ProjectName", objInfo.ProjectName));
Param.Add(new KeyValuePair <string, object>("@ProjectCode", objInfo.ProjectCode));
string strSpName = "usp_AddProject";
SQLHandlerAsync sqlHAsy = new SQLHandlerAsync();
return(await sqlHAsy.ExecuteNonQueryAsync(strSpName, Param));
}
