public JsonResult deleteMessage(string hmid)
{
int hmidInt = Convert.ToInt32(hmid);
HouseMessage hm = HouseMessageService.LoadEntities(h => h.hmid == hmidInt).FirstOrDefault();
bool res = HouseMessageService.DeleteEntity(hm);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult editMessage(string hmid, string message)
{
int hmidInt = Convert.ToInt32(hmid);
int mid = HouseMessageService.LoadEntities(h => h.hmid == hmidInt).FirstOrDefault().mid;
Message msg = MessageService.LoadEntities(m => m.mid == mid).FirstOrDefault();
msg.message1 = message;
bool res = MessageService.EditEntity(msg);
return(Json(res, JsonRequestBehavior.AllowGet));
}
/// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////
public ActionResult HouseInfo(string id, int flag = 0)
{
int idInt = Convert.ToInt32(id);
House h = HouseService.LoadEntities(t => t.hid == idInt).FirstOrDefault();
HousePicture hp = new HousePicture
{
hid = h.hid,
area = h.area,
price = h.price,
pay = h.pay,
unitType = h.unitType,
floor = h.floor,
community = h.community,
pubPerson = h.pubPerson,
time = h.time,
type = h.type,
isRecommend = h.isRecommend,
houseDesc = h.houseDesc,
region = h.region
};
hp.pics = PictureService.LoadEntities(p => p.hid == h.hid).ToList();
List <HouseMessage> hmList = HouseMessageService.LoadEntities(m => m.hid == h.hid).ToList();
List <HouseMessageEntity> entities = new List <HouseMessageEntity>();
foreach (HouseMessage item in hmList)
{
User user = UserService.LoadEntities(u => u.uid == item.uid).FirstOrDefault();
Message message = MessageService.LoadEntities(m => m.mid == item.mid).FirstOrDefault();
entities.Add(new HouseMessageEntity {
user = user,
message = message
});
}
ViewBag.detail = flag;
ViewBag.house = hp;
ViewBag.hm = entities;
return(View());
}
public JsonResult LeaveMessage(string hid, string msg)
{
int hidInt = Convert.ToInt32(hid);
User user = Session["user"] as My.RentingSystem.Model.User;
DateTime dt = DateTime.Now;
string date = dt.ToString();
Message message = MessageService.AddEntity(new Message {
message1 = msg,
time = date
});
HouseMessage hm = HouseMessageService.AddEntity(new HouseMessage {
hid = hidInt,
mid = message.mid,
uid = user.uid
});
return(Json("success", JsonRequestBehavior.AllowGet));
}
public JsonResult getMessage(string pageSize,
string community,
string page,
string message,
string username,
string time
)
{
List <HouseMessage> hmList = HouseMessageService.LoadEntities(m => true).ToList();
List <MessageEntity> entity = new List <MessageEntity>();
foreach (HouseMessage item in hmList)
{
User user = UserService.LoadEntities(u => u.uid == item.uid).FirstOrDefault();
Message msg = MessageService.LoadEntities(m => m.mid == item.mid).FirstOrDefault();
House house = HouseService.LoadEntities(h => h.hid == item.hid).FirstOrDefault();
entity.Add(new MessageEntity()
{
hmid = item.hmid,
username = user.username,
message = msg.message1,
time = msg.time,
community = house.community,
floor = house.floor,
area = house.area
});
}
int pageInt = Convert.ToInt32(page);
int pageSizeInt = Convert.ToInt32(pageSize);
if (!string.IsNullOrWhiteSpace(community))
{
entity = entity.Where(m => m.community.Contains(community)).Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
}
if (!string.IsNullOrWhiteSpace(username))
{
entity = entity.Where(m => m.username.Contains(username)).Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
}
if (!string.IsNullOrWhiteSpace(message))
{
entity = entity.Where(m => m.message.Contains(message)).Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
}
if (!string.IsNullOrWhiteSpace(time))
{
time = time.Substring(0, 10).Replace("-", "");
DateTime itemDate = DateTime.ParseExact(time, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
itemDate = itemDate.AddDays(1);
string formatDate = itemDate.ToString();
string formatDateSub = formatDate.Substring(0, 9);
entity = entity.Where(m => m.time.Contains(formatDateSub)).Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
}
entity = entity.Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
int total = entity.Count;
return(Json(new { entity = entity, total = total }, JsonRequestBehavior.AllowGet));
}
