public bool InsertFavourites(FavouritesDetails details)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@message", Value = details.Message, SqlDbType = SqlDbType.VarChar
},
new SqlParameter()
{
ParameterName = "@favouriteUserId", Value = details.FavouriteUserId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@isSender", Value = details.IsSender, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@senderRecieverId", Value = details.SenderRecieverId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@momentId", Value = details.MomentId, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "@addedDate", Value = details.AddedDate, SqlDbType = SqlDbType.VarChar
},
new SqlParameter()
{
ParameterName = "@localMessageId", Value = details.LocalMessageId, SqlDbType = SqlDbType.Int
},
};
object[] parameters = sp.ToArray();
var users = _favRepository.ExecuteStoredProcedureList <AuthUser>(PROC_INSERT_FAVOURITES, parameters);
if (users != null)
{
return(true);
}
else
{
return(false);
}
}
public IHttpActionResult InsertFavouriteDetails(FavouritesModel model)
{
try
{
if (!ModelState.IsValid)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.Forbidden, "Sender Id and Reciever Id are required.")));
}
FavouritesDetails details = new FavouritesDetails();
details.FavouriteUserId = model.FavouriteUserId;
details.IsSender = model.IsSender;
details.Message = model.Message;
details.MomentId = model.MomentId;
details.SenderRecieverId = model.SenderRecieverId;
details.LocalMessageId = model.LocalMessageId;
var dateTime = DateTime.UtcNow;
details.AddedDate = dateTime.ToString(@"yyyy/MM/dd hh:mm tt", new CultureInfo("en-US"));
_favService.InsertFavourites(details);
UserTransliterationDetails transliterationDetails = _transliterationService.GetTransliterationDetailsByUserId(details.FavouriteUserId);
//TransliterationDetails transDetails = new TransliterationDetails();
if (transliterationDetails != null)
{
transliterationDetails.FavouritesCount = transliterationDetails.FavouritesCount + 1;
ReturnMsg obj = _transliterationService.UpdateTransliterationByUserId(transliterationDetails);
}
else
{
transliterationDetails = new UserTransliterationDetails();
transliterationDetails.FavouritesCount = 1;
transliterationDetails.User_Id = model.FavouriteUserId;
_transliterationService.InsertTransliterationDetails(transliterationDetails);
}
//transDetails.IsFavourite = 1;
}
catch (Exception e)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message)));
}
return(Ok("Favourites details inserted successfully."));
}
