protected void btnlogin_Click(object sender, ImageClickEventArgs e) { string _u = txtusername.Text.ToSafeHtml(); string _p = txtpassword.Text.ToSafeHtml(); if (_u.Length == 0 || _p.Length == 0) { lblresult.Text = "You need to pin User and Password"; return; } else { using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Member where d.UserName == _u && d.Password == _p select d).FirstOrDefault(); if (lst != null) { lst.IPAddress = Request.UserHostAddress.ToString(); lst.LastLogin = persiandate.Miladi2Shamsi(DateTime.Now).ToString() + " " + DateTime.Now.ToShortTimeString(); CreateCookie(LoginManager.EncryptData(lst.UserName)); Response.Redirect("Default.aspx"); } else { lblresult.Text = " invalid User name or Password !"; } } } }
private void AttachFiles(byte[] _file, Int64 size, string contentype, string mimetype, string filename, int messageid) { using (IheariCrmEntities db = new IheariCrmEntities()) { AttachFiles obj = new AttachFiles(); obj.MessageID = messageid; obj.ContentType = contentype; obj.SizeFiles = size; obj.MimeType = mimetype; obj.FileName = filename; obj.Filebinary = _file; db.AttachFiles.Add(obj); db.SaveChanges(); } }
public static int MemberID(string Bname) { int mid = 0; HttpCookie cookie = HttpContext.Current.Request.Cookies[LoginManager.EncodeTo64("ihcrm").Substring(1, 7)]; if (cookie != null) { string _u = LoginManager.DecryptString(cookie.Value.ToSafeHtml()); using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Member where d.UserName == _u select new { d.ID }).FirstOrDefault();; mid = lst.ID; } } return(mid); }
protected void Page_Load(object sender, EventArgs e) { if (Request["m"] == "send") { if (Request["er"] == "1") { lblresult.Text = "Sending Error"; lblresult.ForeColor = Color.Red; } if (!IsPostBack) { setuserpath(); using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = db.MemberList(1).ToList(); RadTileList1.DataSource = lst; RadTileList1.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["fID"] != null) { string filename = ""; int id = Int32.Parse(Request.QueryString["fID"]); using (IheariCrmEntities db = new IheariCrmEntities()) { var picu = (from d in db.AttachFiles where d.ID == id select new { d.ID, d.FileName, d.Filebinary, d.ContentType }).ToList(); if (picu != null) { filename = picu[0].FileName.Replace(" ", "-"); Byte[] bytes = (Byte[])picu[0].Filebinary; Response.Buffer = true; Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); // Response.ContentType = "image/jpeg"; Response.ContentType = ContentType; Response.AddHeader("content-disposition", "attachment;filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } } }
public static string DeleteRow(string rowid, string mod) { try { string ssss = string.Empty; using (IheariCrmEntities db = new IheariCrmEntities()) { if (mod == "0") { db.DeleteMes(rowid, false); } else { db.DeleteMes(rowid, true); } } return("ok#"); } catch { return("no#"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["ref"] == "res") { caption.Text = "Sender"; int memberid = LoginManager.MemberID("ihcrm"); Int64 rowid = Int64.Parse(Request["mesid"]); int mesid = 0; if (!IsPostBack) { using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Send_Recive where d.ID == rowid && d.Memeber_ReciveID == memberid select new { d.Visit, d.Message.Title, d.Message.ShomareName, d.MessegaeID, d.Message.TextBody, d.Message.DateCreate, d.Message.Member.DisplayName }).FirstOrDefault(); if (lst != null) { lblsubject.Text = lst.Title; ltr.Text = WebUtility.HtmlDecode(lst.TextBody); lbldate.Text = lst.DateCreate; lblmember.Text = lst.DisplayName; shomarename.Text = lst.ShomareName; mesid = lst.MessegaeID; if (lst.Visit == false) { var ff = (from d in db.Send_Recive where d.ID == rowid select d).FirstOrDefault(); ff.Visit = true; ff.DateView = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); ff.IPAddress = Request.UserHostAddress.ToString(); db.SaveChanges(); } var lst2 = (from d in db.AttachFiles where d.MessageID == mesid select new { d.ID, d.FileName, d.SizeFiles }).ToList(); if (lst2.Count > 0) { rpt.DataSource = lst2; rpt.DataBind(); } else { attachtr.Visible = false; } } else { Response.Redirect("Default.aspx?ref=er"); } } } } if (Request["ref"] == "send") { caption.Text = "Recivers:"; int memberid = LoginManager.MemberID("ihcrm"); Int64 rowid = Int64.Parse(Request["mesid"]); int mesid = 0; if (!IsPostBack) { using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Message where d.ID == rowid && d.MemberID == memberid select new { d.ID, d.Title, d.ShomareName, d.TextBody, d.DateCreate, d.Member.DisplayName }).FirstOrDefault(); if (lst != null) { lblsubject.Text = lst.Title; ltr.Text = WebUtility.HtmlDecode(lst.TextBody); lbldate.Text = lst.DateCreate; lblmember.Text = lst.DisplayName; shomarename.Text = lst.ShomareName; mesid = lst.ID; var memberlist = (from d in db.Send_Recive where d.MessegaeID == rowid select new { d.ID, d.Visit, d.Member.DisplayName, d.DateView }).ToList(); string _memberlist = ""; if (memberlist.Count > 0) { lblmember.Visible = false; foreach (var item in memberlist) { _memberlist = _memberlist + "<label title='" + item.DateView + "' class='memberResiver visit" + item.Visit + "'>(" + item.DisplayName + ")</label>" + " "; } ltrmemberlist.Text = _memberlist; } var lst2 = (from d in db.AttachFiles where d.MessageID == mesid select new { d.ID, d.FileName, d.SizeFiles }).ToList(); if (lst2.Count > 0) { rpt.DataSource = lst2; rpt.DataBind(); } else { attachtr.Visible = false; } } else { Response.Redirect("Default.aspx?ref=er"); } } } } }
protected void Page_Load(object sender, EventArgs e) { int memberid = LoginManager.MemberID("ihcrm"); if (Request["m"] == "inbox") { caption = "Sender"; using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Send_Recive orderby d.ID descending where d.Memeber_ReciveID == memberid && d.TrashBox == false select new { d.Message.ISattach, d.ID, d.Message.Member.DisplayName, d.Message.Title, d.Message.DateCreate, d.Visit, d.Message.SizeAttach, d.Message.AttachFiles, d.Message.ShomareName }).ToList(); rptresive.DataSource = lst; rptresive.DataBind(); rptsent.Visible = false; rptresive.Visible = true; } } else if (Request["m"] == "sent") { caption = "To"; using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Message orderby d.ID descending where d.MemberID == memberid && d.TrashBox == false select new { d.ISattach, d.ID, d.Title, d.DateCreate, d.SizeAttach, d.AttachFiles, d.ShomareName }).ToList(); rptsent.DataSource = lst; rptsent.DataBind(); rptsent.Visible = true; rptresive.Visible = false; } } else if (Request["m"] == "deletedSend") { caption = "TO"; using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Message orderby d.ID descending where d.MemberID == memberid && d.TrashBox == true select new { d.ISattach, d.ID, d.Title, d.DateCreate, d.SizeAttach, d.AttachFiles, d.ShomareName }).ToList(); rptsent.DataSource = lst; rptsent.DataBind(); rptsent.Visible = true; rptresive.Visible = false; } } else if (Request["m"] == "deletedResive") { caption = "Sender"; using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Send_Recive orderby d.ID descending where d.Memeber_ReciveID == memberid && d.TrashBox == true select new { d.Message.ISattach, d.ID, d.Message.Member.DisplayName, d.Message.Title, d.Message.DateCreate, d.Visit, d.Message.SizeAttach, d.Message.AttachFiles, d.Message.ShomareName }).ToList(); rptresive.DataSource = lst; rptresive.DataBind(); rptsent.Visible = false; rptresive.Visible = true; } } else { caption = "Sender"; using (IheariCrmEntities db = new IheariCrmEntities()) { var lst = (from d in db.Send_Recive orderby d.ID descending where d.Memeber_ReciveID == memberid select new { d.Message.ISattach, d.ID, d.Message.Member.DisplayName, d.Message.Title, d.Message.DateCreate, d.Message.SizeAttach, d.Visit, d.Message.AttachFiles, d.Message.ShomareName }).ToList(); rptresive.DataSource = lst; rptresive.DataBind(); rptsent.Visible = false; rptresive.Visible = true; } } }
protected void btnSend_Click(object sender, EventArgs e) { int memberid = LoginManager.MemberID("ihcrm"); string subject = WebUtility.HtmlEncode(txtsubject.Text); string shomarename = WebUtility.HtmlEncode(txtshomarename.Text); if (subject.Length == 0) { lblresult.Text = "Please Enter Subject"; lblresult.ForeColor = Color.Red; return; } string body = WebUtility.HtmlEncode(radeditor.Content); if (body.Length < 1) { lblresult.Text = "The Body Text is Very Short"; lblresult.ForeColor = Color.Red; return; } if (totalBytes > MaxTotalBytes) { lblresult.Text = "Maximum file Size is 10 MB"; lblresult.ForeColor = Color.Red; return; } int messageid; using (var context = new IheariCrmEntities()) { using (var db = context.Database.BeginTransaction()) { try { Message obj = new Message(); obj.MemberID = memberid; obj.DateCreate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); obj.Title = subject; obj.TextBody = body; obj.ShomareName = shomarename; obj.IPAddress = Request.UserHostAddress.ToString(); obj.TrashBox = false; if (totalBytes > 0) { obj.SizeAttach = totalBytes.ToString(); obj.ISattach = true; } else { obj.ISattach = false; } obj.ISattach = true; context.Message.Add(obj); messageid = obj.ID; IList <RadTreeNode> nodeCollection = RadTileList1.CheckedNodes; List <Send_Recive> Lst = new List <Send_Recive>(); int _c = 0; foreach (RadTreeNode node in nodeCollection) { if (node.Nodes.Count == 0) { _c = _c + 1; Lst.Add(new Send_Recive { MessegaeID = messageid, Memeber_ReciveID = int.Parse(node.Value), Visit = false, TrashBox = false }); } } if (_c == 0) { lblresult.Text = "You Must Select the Reciver"; lblresult.ForeColor = Color.Red; return; } context.Send_Recive.AddRange(Lst); foreach (UploadedFile file in RadAsyncUpload1.UploadedFiles) { UploadedFileInfo uploadedFileInfo = new UploadedFileInfo(file); UploadedFiles.Add(uploadedFileInfo); string fna = uploadedFileInfo.FileName; Stream fileStream = file.InputStream; byte[] attachmentBytes = new byte[fileStream.Length]; fileStream.Read(attachmentBytes, 0, Convert.ToInt32(fileStream.Length)); AttachFiles obj3 = new AttachFiles(); obj3.MessageID = messageid; obj3.ContentType = uploadedFileInfo.ContentType; obj3.SizeFiles = uploadedFileInfo.ContentLength; obj3.MimeType = null; obj3.FileName = uploadedFileInfo.FileName; obj3.Filebinary = attachmentBytes; context.AttachFiles.Add(obj3); } context.SaveChanges(); db.Commit(); Response.Redirect("Default.aspx?m=sent"); } catch (Exception ex) { db.Rollback(); Elmah.ErrorSignal.FromCurrentContext().Raise(ex); Response.Redirect("Default.aspx?m=send&er=1"); } } } }