/// <summary>
/// Description: This method calls a method in DAL layer to insert user's rating on food order
/// </summary>
/// <param name="iUserOrderRatingDBO">UserOrderRating object with data</param>
/// <returns>If successfully inserted, returns a unique rating id. Otherwise, 0</returns>
public int CreateUserOrderRating(UserOrderRatingDBO iUserOrderRatingDBO)
{
// Instantiate UserDAL object
UserDAL lUserDAL = new UserDAL();
// get IDPK as return value
int lRatingIDPK = lUserDAL.CreateUserOrderRating(iUserOrderRatingDBO);
return(lRatingIDPK);
}
/// <summary>
/// Description: This method maps UserOrderRating Model object to UserOrderRating database object
/// </summary>
/// <param name="iUserOrderRating">UserOrderRating Model to be mapped</param>
/// <returns>UserOrderRating database object</returns>
public UserOrderRatingDBO MapOrderRatingModelToOrderRatingDBO(UserOrderRating iUserOrderRating)
{
UserOrderRatingDBO lOrderRatingDBO = new UserOrderRatingDBO();
// set values
lOrderRatingDBO.UserOrderIDFK = iUserOrderRating.UserOrderIDFK;
lOrderRatingDBO.Score = iUserOrderRating.Score;
lOrderRatingDBO.Content = iUserOrderRating.Content;
return(lOrderRatingDBO);
}
/// <summary>
/// Description: This method inserts user's rating on food order
/// </summary>
/// <param name="iUserOrderRatingDBO">UserOrderRating object with data</param>
/// <returns>If successfully inserted, returns a unique rating id. Otherwise, 0</returns>
public int CreateUserOrderRating(UserOrderRatingDBO iUserOrderRatingDBO)
{
// return value
int lResult = 0;
try
{
// establish connection
using (SqlConnection lConn = new SqlConnection(lConnectionString))
{
// use stored procedure
using (SqlCommand lComm = new SqlCommand("sp_CreateUserOrderRating", lConn))
{
lComm.CommandType = CommandType.StoredProcedure;
lComm.CommandTimeout = 10;
// set parameters for stored procedure
lComm.Parameters.AddWithValue("@parm_user_order_id_FK", SqlDbType.Int).Value = iUserOrderRatingDBO.UserOrderIDFK;
lComm.Parameters.AddWithValue("@parm_score", SqlDbType.Float).Value = iUserOrderRatingDBO.Score;
// check null value
if (string.IsNullOrEmpty(iUserOrderRatingDBO.Content))
{
lComm.Parameters.AddWithValue("@parm_content", SqlDbType.VarChar).Value = DBNull.Value;
}
else
{
lComm.Parameters.AddWithValue("@parm_content", SqlDbType.VarChar).Value = iUserOrderRatingDBO.Content;
}
// open connection
lConn.Open();
lResult = Convert.ToInt32(lComm.ExecuteScalar());
}
}
}
catch (Exception ex)
{
// handle exception
ExceptionDAL lExceptionDAL = new ExceptionDAL();
lExceptionDAL.CreateExceptionLog(ex);
}
return(lResult);
}
public ActionResult UserOrderRating(UserOrderRating iUserRating)
{
// Instantiate Objects
UserBLL lUserBLL = new UserBLL();
UserMapper lUserMapper = new UserMapper();
// Mapp Model to DB object
UserOrderRatingDBO lUserOrderRatingDBO = lUserMapper.MapOrderRatingModelToOrderRatingDBO(iUserRating);
// Create user rating
int lRatingIDPK = lUserBLL.CreateUserOrderRating(lUserOrderRatingDBO);
// success
if (lRatingIDPK > 0)
{
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
