public static List <object> FetchProblemByIncedentAndHotelId(int hotelid, int userid)
{
SqlCommand cmd = new SqlCommand("spFetchSingleProblemByHotelandId");
cmd.Parameters.AddWithValue("@hotelid", hotelid);
cmd.Parameters.AddWithValue("@incedentId", userid);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
DataTable dt = DBOperations.FetchValues(cmd).Tables[0];
Incedent incedent = new Incedent();
User user = new User();
List <object> result = null;
if (dt.Rows.Count > 0)
{
incedent.IncedentID = dt.Rows[0]["Id"].ToString();
incedent.IncedentType = int.Parse(dt.Rows[0]["Type"].ToString());
incedent.IncedentDescription = dt.Rows[0]["Descrp"].ToString();
incedent.RoomNo = dt.Rows[0]["Room"].ToString();
incedent.IncedentTime = DateTime.Parse(dt.Rows[0]["Time"].ToString());
incedent.FeedbackValue = int.Parse(dt.Rows[0]["FeedbackValue"].ToString());
incedent.IsSolved = bool.Parse(dt.Rows[0]["IsResolved"].ToString());
user.Email = dt.Rows[0]["Email"].ToString();
user.LastName = dt.Rows[0]["name"].ToString();
user.Phone = dt.Rows[0]["Phone"].ToString();
result = new List <object>()
{
user, incedent
};
}
return(result);
}
public static int UpdateProblem(Incedent incedent)
{
SqlCommand cmd = new SqlCommand("spUpdateProblem");
cmd.Parameters.AddWithValue("@incedentId", incedent.IncedentIDNum);
cmd.Parameters.AddWithValue("@description", incedent.IncedentDescription);
cmd.Parameters.AddWithValue("@incedentType", incedent.IncedentType);
cmd.Parameters.AddWithValue("@feedbackValue", incedent.FeedbackValue);
cmd.Parameters.AddWithValue("@isSolved", incedent.IsSolved);
cmd.CommandType = CommandType.StoredProcedure;
return(DBOperations.UpdateOrInsert(cmd));
}
public static int ReportProblem(Incedent incedent)
{
SqlCommand cmd = new SqlCommand("spReportProblem");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IncedentType", incedent.IncedentType);
cmd.Parameters.AddWithValue("@IncedentDescription", incedent.IncedentDescription);
cmd.Parameters.AddWithValue("@RoomNo", incedent.RoomNo);
cmd.Parameters.AddWithValue("@HotelID", incedent.HotelID);
cmd.Parameters.AddWithValue("@IncedentTime", incedent.IncedentTime);
cmd.Parameters.AddWithValue("@UserID", incedent.UserID);
cmd.Parameters.AddWithValue("@FeedbackValue", incedent.FeedbackValue);
return(DBOperations.UpdateOrInsert(cmd));
}
