public object GetEbulletinDetails(EbulletinDetails ebull)
{
dynamic TBEbulletinListResult;
List <object> EbulletinDetailResult = new List <object>();
try
{
var Result = Ebulletin.GetEbulletinDetails(ebull);
if (Result > 0)
{
TBEbulletinListResult = new { status = "0", message = "success", EbulletinDetailResult = EbulletinDetailResult };
}
else
{
TBEbulletinListResult = new { status = "0", message = "Record not found", EbulletinDetailResult = EbulletinDetailResult };
}
}
catch
{
TBEbulletinListResult = new { status = "1", message = "failed" };
}
return(new { TBEbulletinListResult });
}
public static int GetEbulletinDetails(EbulletinDetails ebull)
{
try
{
var EbullID = new MySqlParameter("?EbullID", ebull.ebulletinID);
var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);
var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetEbulletinDetails(EbulletinDetails ebull)
{
try
{
var EbullID = new MySqlParameter("?EbullID", ebull.ebulletinID);
var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
