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)); }