public static int GetFriendsSubmittedStoriesCount(int userID, int hostID)
{
SubSonic.StoredProcedure sp = SPs.Kick_GetPagedFriendsSubmittedStoriesByUserIDAndHostIDCount(userID, hostID, null);
sp.Execute();
int recordCount = int.Parse(sp.OutputValues[0].ToString());
return(recordCount);
}
public static StoredProcedure GetIdDvHc(string datagroup , int? id)
{
try
{
using (new SharedDbConnectionScope(ConnectString))
{
var sp = new SubSonic.StoredProcedure("H_LayMaHanhChinhOut", DataService.GetInstance("ORM"), "dbo");
sp.Command.AddParameter("@DataGroup", datagroup, DbType.String, null, null);
sp.Command.AddParameter("@AdditionPara", id, DbType.Int16, 0, 10);
sp.Execute();
if (sp.OutputValues != null)
_CLSKetQuaId = Convert.ToInt16(sp.OutputValues[0]);
return sp;
}
}
catch (Exception ex)
{
throw;
}
}
