public static void AddPrivateMessageinCache(string fromEmail, string chatToEmail, string userName, string message)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
// Save master
var master = dc.ChatPrivateMessageMaster.ToList().Where(a => a.EmailID.Equals(fromEmail)).ToList();
if (master.Count == 0)
{
var result = new ChatPrivateMessageMaster
{
EmailID = fromEmail,
UserName = userName
};
dc.ChatPrivateMessageMaster.Add(result);
dc.SaveChanges();
}
// Save details
var resultDetails = new ChatPrivateMessageDetails
{
MasterEmailID = fromEmail,
ChatToEmailID = chatToEmail,
Message = message
};
dc.ChatPrivateMessageDetails.Add(resultDetails);
dc.SaveChanges();
}
}
private void AddPrivateMessageinCache(string fromEmail, string chatToEmail, string userName, string message)
{
ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster> chmmr = new ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster>();
//using (Surajit_TestEntities dc = new Surajit_TestEntities())
//{
// Save master
var master = chmmr.GetList(new { EmailID = fromEmail }).ToList();//dc.ChatPrivateMessageMasters.ToList().Where(a => a.EmailID.Equals(fromEmail)).ToList();
if (master.Count == 0)
{
var result = new ChatPrivateMessageMaster
{
EmailID = fromEmail,
UserName = userName
};
chmmr.Insert(result);// dc.ChatPrivateMessageMasters.Add(result);
//dc.SaveChanges();
}
// Save details
var resultDetails = new ChatPrivateMessageDetails
{
MasterEmailID = fromEmail,
ChatToEmailID = chatToEmail,
Message = message
};
ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails> chpmd = new ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails>();
chpmd.Insert(resultDetails);// dc.ChatPrivateMessageDetails.Add(resultDetails);
// dc.SaveChanges();
// }
}
private void AddPrivateMessageinCache(string fromEmail, string chatToEmail, string userName, string message)
{
var uow = new XpoDAO().ProvideUnitOfWork();
var ChatPrivateMessageMasters = new XPCollection <ChatPrivateMessageMaster>(uow);
// Save master
var master = ChatPrivateMessageMasters.ToList().Where(a => a.EmailID.Equals(fromEmail)).ToList();
if (master.Count == 0)
{
var result = new ChatPrivateMessageMaster(uow)
{
EmailID = fromEmail,
UserName = userName
};
ChatPrivateMessageMasters.Add(result);
uow.CommitChanges();
}
// Save details
var ChatPrivateMessageDetails = new XPCollection <ChatPrivateMessageDetail>(uow);
var resultDetails = new ChatPrivateMessageDetail(uow)
{
MasterEmailID = fromEmail,
ChatToEmailID = chatToEmail,
Message = message
};
ChatPrivateMessageDetails.Add(resultDetails);
uow.CommitChanges();
}
private void AddPrivateMessageinCache(string chatToUser, string userName, string message)
{
using (Sdo_ChatEntities dc = new Sdo_ChatEntities())
{
// Save master
var master = dc.ChatPrivateMessageMasters.ToList().Where(a => a.UserName.Equals(userName)).ToList();
if (master.Count == 0)
{
var result = new ChatPrivateMessageMaster
{
UserName = userName
};
dc.ChatPrivateMessageMasters.Add(result);
dc.SaveChanges();
}
// Save details
var fldrone = new Sdo_ChatEntities();
var folderDetailone =
(from m in fldrone.UserProfiles
where m.UserName == userName
select new { m.FolderId }).FirstOrDefault();
if (folderDetailone != null)
{
var resultDetails = new ChatPrivateMessageDetail
{
MasterEmailID = userName,
ChatToEmailID = chatToUser,
Message = message,
FolderId = folderDetailone.FolderId,
MsgTime = Convert.ToString(DateTime.Now.ToString("HH:mm:ss")),
MsgDate = Convert.ToString(DateTime.Now)
};
dc.ChatPrivateMessageDetails.Add(resultDetails);
dc.SaveChanges();
}
}
}