public List <DairyListItem> Select() { StoredProcedure storedProcedure = new StoredProcedure(); storedProcedure.Name = My.Resources.CreateSelectByNameSPList()[TableList.DiaryListItem].ToString(); storedProcedure.ParameterValueCollection = ParameterProvider.GetParameterListForInsertDairyDateItem(DateItem); return(dairyItemController.ExecuteSync(storedProcedure).ToList()); }
public int ComputeStatistic() { StoredProcedure storedProcedure = new StoredProcedure(); storedProcedure.Name = My.Resources.CreateInsertSPList()[TableList.DiaryDate].ToString(); storedProcedure.ParameterValueCollection = ParameterProvider.GetParameterListForInsertDairyDateItem(DateItem); return(dairyController.Execute(storedProcedure)); }
public void Insert() { ListItem.DateID = dairyController.Execute( ParameterProvider.GetParameterListForInsertDairyDateItem(DateItem), My.Resources.CreateInsertSPList()[TableList.DiaryDate].ToString()); dairyItemController.ExecuteAsync( ParameterProvider.GetParameterListForInsertDairyListItem(ListItem), My.Resources.CreateInsertSPList()[TableList.DiaryListItem].ToString()); }
public void Insert() { StoredProcedure firstStoredProcedure = new StoredProcedure(); firstStoredProcedure.Name = My.Resources.CreateInsertSPList()[TableList.DiaryDate].ToString(); firstStoredProcedure.ParameterValueCollection = ParameterProvider.GetParameterListForInsertDairyDateItem(DateItem); ListItem.DateID = dairyController.Execute(firstStoredProcedure); StoredProcedure secondStoredProcedure = new StoredProcedure(); secondStoredProcedure.Name = My.Resources.CreateInsertSPList()[TableList.DiaryListItem].ToString(); secondStoredProcedure.ParameterValueCollection = ParameterProvider.GetParameterListForInsertDairyListItem(ListItem); dairyItemController.ExecuteAsync(secondStoredProcedure); }
public List <DairyListItem> Select() { return(dairyItemController.ExecuteSync( ParameterProvider.GetParameterListForInsertDairyDateItem(DateItem), My.Resources.CreateSelectByNameSPList()[TableList.DiaryListItem].ToString()).ToList()); }