protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
BindData();
if (Session["SenderID"] != null)
{
divMsg.Visible = false;
divMsgDetail.Visible = true;
var DC = new DataClassesDataContext();
tblMessage MsgData = DC.tblMessages.Single(ob => ob.MessegeID == Convert.ToInt32(Session["MsgID"]));
//Session["SenderID"] = MsgData.SenderID;
tblEmployee EmpData = DC.tblEmployees.Single(ob => ob.EmpID == Convert.ToInt32(Session["SenderID"]));
ltrEmpName.Text = EmpData.FirstName + " " + EmpData.LastName;
ltrSubject.Text = MsgData.Subject;
ltrDesc.Text = MsgData.Description;
if (EmpData.ProfilePic == null)
{
imgEmp.ImageUrl = "Admin/img/user-icon.png";
}
else
{
imgEmp.ImageUrl = "Admin/EmpUpload/" + EmpData.ProfilePic;
}
//MsgData.IsRead = true;
//DC.SubmitChanges();
btnClose.Visible = true;
}
if (Session["ReceiverID"] != null)
{
divMsg.Visible = false;
divMsgDetail.Visible = true;
var DC = new DataClassesDataContext();
//Session["ReceiverID"] = e.CommandArgument;
tblEmployee EmpData = DC.tblEmployees.Single(ob => ob.EmpID == Convert.ToInt32(Session["ReceiverID"]));
ltrEmpName.Text = EmpData.FirstName + " " + EmpData.LastName;
ltrSubject.Visible = false;
ltrDesc.Visible = false;
if (EmpData.ProfilePic == null)
{
imgEmp.ImageUrl = "Admin/img/user-icon.png";
}
else
{
imgEmp.ImageUrl = "Admin/EmpUpload/" + EmpData.ProfilePic;
}
btnClose.Visible = true;
}
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
}
}
protected void btnMsg_Click(object sender, EventArgs e)
{
try
{
var DC = new DataClassesDataContext();
tblMessage MsgData = new tblMessage();
MsgData.Subject = txtSubject.Text;
MsgData.Description = txtMSg.Text;
if (Session["SenderID"] != null)
{
MsgData.ReceiverID = Convert.ToInt32(Session["SenderID"]);
}
else
{
MsgData.ReceiverID = Convert.ToInt32(Session["ReceiverID"]);
}
MsgData.SenderID = Convert.ToInt32(Session["EmpID"]);
MsgData.CreatedOn = DateTime.Now;
DC.tblMessages.InsertOnSubmit(MsgData);
DC.SubmitChanges();
Session["ReceiverID"] = null;
Session["SenderID"] = null;
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
//ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public OperationStatus SubmitMessage(MessageCustomModel model)
{
OperationStatus status = OperationStatus.Error;
using (TransactionScope ts = new TransactionScope())
{
try
{
using (dbcontext = new ChatApplicationEntities())
{
if (model.Id == 0)
{
tblMessage _addMessage = new tblMessage
{
SenderId = model.SenderId,
Subject = model.Subject,
MessageBody = model.MessageBody,
ParentMessageId = model.ParentMessageId,
IsActive = true,
CreatedDate = DateTime.Now
};
dbcontext.tblMessages.Add(_addMessage);
dbcontext.SaveChanges();
int messageid = _addMessage.Id;
tblMessageRecipient _addMessageRecipient = new tblMessageRecipient
{
MessageId = messageid,
RecipientId = model.ReceiverId,
IsActive = true,
CreatedDate = DateTime.Now,
};
dbcontext.tblMessageRecipients.Add(_addMessageRecipient);
dbcontext.SaveChanges();
status = OperationStatus.Success;
ts.Complete();
}
else
{
status = OperationStatus.Duplicate;
//ts.Dispose();
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
ts.Dispose();
throw ex;
}
}
return(status);
}
public PartialViewResult _MessageUs(tblMessage tm)
{
if (ModelState.IsValid)
{
tm.Tag = "hostelnepal";
db.tblMessages.Add(tm);
db.SaveChanges();
}
return(PartialView("_MessageUs"));
}
public PartialViewResult _Message(tblMessage tm)
{
if (ModelState.IsValid)
{
tm.Subject = "To Warden";
tm.Tag = "warden";
db.tblMessages.Add(tm);
db.SaveChanges();
}
return(PartialView("_Message"));
}
public void InsertChatMessage(Chat msg)
{
var m = new tblMessage()
{
TBL_MSG_TEXT = msg.Message,
TBL_MSG_TIME = msg.Time,
};
dc.tblMessages.InsertOnSubmit(m);
dc.SubmitChanges();
}
public tblMessage AddMsg(string text, int ID)
{
tblMessage msg = new tblMessage
{
Message = text,
UserID = ID,
SendDate = DateTime.Now
};
_iMsgRepository.AddMessage(msg);
_iMsgRepository.SaveChanges();
return(msg);
}
// GET: /Message/Details/5
public ActionResult Details(int id = 0)
{
Dictionary <string, List <string> > dictionary = new Dictionary <string, List <string> >();
dictionary = FlowHelper.GetBtnAuthorityForPageList("系统设置", "个人消息");
tblMessage tblMessage = BusinessContext.tblMessage.GetModel(id);
if (tblMessage == null)
{
return(HttpNotFound());
}
ViewBag.MessageModel = tblMessage;
return(View(tblMessage));
}
public int Insert(Models.Message message)
{
tblMessage newMessage = new tblMessage {
Body = message.Body,
CritiqueId = message.CritiqueId,
DateTime = DateTime.Now,
Rating = message.Rating,
FromUserId = message.FromUserId,
ToUserId = message.ToUserId,
CollectionId = message.CollectionId,
X = message.X,
Y = message.Y
};
db.Messages.Add(newMessage);
db.SaveChanges();
return(newMessage.Id);
}
public ResponseMethod SaveMessage(tblMessage msg)
{
ResponseMethod responseMethod = new ResponseMethod();
try
{
if (msg != null)
{
messagecontext.tblMessages.Add(msg);
messagecontext.SaveChanges();
responseMethod.Success = "success";
responseMethod.Message = "record added successfully.";
}
}
catch (Exception ex)
{
Exception(responseMethod, ex);
responseMethod.Message = ex.Message;
}
return(responseMethod);
}
protected void rptMSg_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true);
//divMsg.Visible = false;
//divMsgDetail.Visible = true;
var DC = new DataClassesDataContext();
tblMessage MsgData = DC.tblMessages.Single(ob => ob.MessegeID == Convert.ToInt32(e.CommandArgument));
Session["MsgID"] = e.CommandArgument;
Session["SenderID"] = MsgData.SenderID;
tblEmployee EmpData = DC.tblEmployees.Single(ob => ob.EmpID == Convert.ToInt32(Session["SenderID"]));
ltrEmpName.Text = EmpData.FirstName + " " + EmpData.LastName;
ltrSubject.Text = MsgData.Subject;
ltrDesc.Text = MsgData.Description;
if (EmpData.ProfilePic == null)
{
imgEmp.ImageUrl = "Admin/img/user-icon.png";
}
else
{
imgEmp.ImageUrl = "Admin/EmpUpload/" + EmpData.ProfilePic;
}
MsgData.IsRead = true;
DC.SubmitChanges();
//btnClose.Visible = true;
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
//ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public tblMessage AddMessage(tblMessage Msg)
{
return(_context.tblMessages.Add(Msg));
}
public ActionResult AddWholeseller(string txtName, string txtCity, string txtAddress, string txtType, string txtNIC, string txtNTN, string txtMoblie, string txtContactNo, string txtReferredBy)
{
try
{
int assignedID = 0;
string mobile = txtMoblie.Replace("-", "");
mobile = mobile.Replace(" ", String.Empty);
using (linqDBContext db = new linqDBContext())
{
var q = (from us in db.tblRetails
where us.name == "Wholesellers"
select us.id).FirstOrDefault();
if (q > 0)
{
retailType = q;
}
var chk = (from us in db.tblUsers
where us.userName == mobile
select us).FirstOrDefault();
if (chk != null)
{
return(Json(new JsonResult()
{
Data = 0
}, JsonRequestBehavior.AllowGet));
}
else
{
Random rn = new Random();
string pwd = rn.Next(1000, 9999).ToString();
tblWholeseller it = new tblWholeseller();
it.Name = txtName;
it.City = txtCity;
it.Address = txtAddress;
it.Type = txtType;
it.NIC = txtNIC;
it.NTN = txtNTN;
it.Moblie = mobile;
it.ContactNo = txtContactNo;
it.ReferredBy = txtReferredBy;
db.tblWholesellers.Add(it);
db.SaveChanges();
assignedID = it.id;
tblUser u = new tblUser();
u.userName = mobile;
u.password = pwd;
u.status = "Pending";
u.localID = assignedID;
u.type = retailType;
tblMessage tm = new tblMessage();
tm.message = "New User Created with User Name " + mobile + " And Password +" + pwd + " ";
tm.sent_time = DateTime.Now;
tm.isSent = false;
db.tblMessages.Add(tm);
db.tblUsers.Add(u);
db.SaveChanges();
return(Json(new JsonResult()
{
Data = assignedID
}, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Add(string name, string fName, int supervisor, string mob, string nic, string address)
{
try
{
int assignedID = 0;
string mobile = mob.Replace("-", "");
mobile = mobile.Replace(" ", String.Empty);
using (linqDBContext db = new linqDBContext())
{
var q = (from us in db.tblRetails
where us.name == "Reseller"
select us.id).FirstOrDefault();
if (q > 0)
{
retailType = q;
}
var chk = (from us in db.tblUsers
where us.userName == mobile
select us).FirstOrDefault();
if (chk != null)
{
return(Json(new JsonResult()
{
Data = 0
}, JsonRequestBehavior.AllowGet));
}
Random rn = new Random();
string pwd = rn.Next(1000, 9999).ToString();
tblReseller it = new tblReseller();
it.name = name;
it.fatherName = fName;
it.supervisor = supervisor;
it.Mob = mobile;
it.NIC = nic;
it.address = address;
it.isActive = true;
it.isSupervisor = false;
it.DOA = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.tblResellers.Add(it);
db.SaveChanges();
assignedID = it.id;
//Save for Login
tblUser u = new tblUser();
u.userName = mobile;
u.password = pwd;
u.status = "Approved";
u.localID = assignedID;
u.type = retailType;
tblMessage tm = new tblMessage();
tm.message = "New User Created with User Name " + mobile + " And Password +" + pwd + " ";
tm.sent_time = DateTime.Now;
tm.isSent = false;
db.tblMessages.Add(tm);
db.tblUsers.Add(u);
db.SaveChanges();
return(Json(new JsonResult()
{
Data = assignedID
}, JsonRequestBehavior.AllowGet));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult saveEventMessages(SaveEventMessageModel eventMessageModel)
{
if (ModelState.IsValid)
{
tblUser user = (tblUser)Session["USER"];
tblMessage message = new tblMessage();
Guid messageId = Guid.NewGuid();
message.Id = messageId;
message.Content = eventMessageModel.message.Content;
message.CategoryId = (int)Enums.messageType.FindTeam;
message.UserId = user.GUID;
db.tblMessage.Add(message);
tblEventMessages eventMessage = new tblEventMessages();
eventMessage.EventId = eventMessageModel.relatedEvent.GUID;
eventMessage.MessageId = messageId;
db.tblEventMessages.Add(eventMessage);
db.SaveChanges();
return RedirectToAction("Home", "Event", new { id = eventMessage.EventId});
}
return View("Index", "Home");
}
public void RemoveMsg(tblMessage Msg)
{
_context.tblMessages.Remove(Msg);
}
public ActionResult AddOutlet(string OutletName, string Phone, string Moblie, string NTN, string Location, string OwnerName, string NIC, string OwnerAddress, string ContactNo, string UserName, string UserMoblieNo)
{
try
{
int assignedID = 0;
string mob = UserMoblieNo.Replace("-", "");
mob = mob.Replace(" ", String.Empty);
using (linqDBContext db = new linqDBContext())
{
var q = (from us in db.tblRetails
where us.name == "Outlets"
select us.id).FirstOrDefault();
if (q > 0)
{
retailType = q;
}
var chk = (from us in db.tblUsers
where us.userName == mob
select us).FirstOrDefault();
if (chk != null)
{
return(Json(new JsonResult()
{
Data = 0
}, JsonRequestBehavior.AllowGet));
}
else
{
Random rn = new Random();
string pwd = rn.Next(1000, 9999).ToString();
tblOutlet it = new tblOutlet();
it.OutletName = OutletName;
it.Phone = Phone;
it.Moblie = Moblie;
it.NTN = NTN;
it.Location = Location;
it.OwnerName = OwnerName;
it.NIC = NIC;
it.OwnerAddress = OwnerAddress;
it.ContactNo = ContactNo;
it.UserName = UserName;
it.UserMoblieNo = UserMoblieNo;
db.tblOutlets.Add(it);
db.SaveChanges();
assignedID = it.id;
tblUser u = new tblUser();
u.userName = mob;
u.password = pwd;
u.status = "Pending";
u.localID = assignedID;
u.type = retailType;
tblMessage tm = new tblMessage();
tm.message = "New User Created with User Name " + mob + " And Password +" + pwd + " ";
tm.sent_time = DateTime.Now;
tm.isSent = false;
//new user and message will be saved
db.tblUsers.Add(u);
db.tblMessages.Add(tm);
db.SaveChanges();
return(Json(new JsonResult()
{
Data = assignedID
}, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
