public void UploadFile(int columnDefId_, int recordId_, HttpPostedFileBase postedFile) { byte[] bytes; using (BinaryReader br = new BinaryReader(postedFile.InputStream)) { bytes = br.ReadBytes(postedFile.ContentLength); } using (SourceControlEntities Db = new SourceControlEntities()) { Db.FileAttachments.Add(new FileAttachment { ColumnDefId = columnDefId_, RecordId = recordId_, FileName = Path.GetFileName(postedFile.FileName), FileSize = postedFile.ContentLength, UploadDate = DateTime.Now, UploadBy = SessionService.UserId, ContentType = postedFile.ContentType, FileData = bytes }); Db.SaveChanges(); } }
public ActionResult Registration(UserRegistration objUr) { try { if (ModelState.IsValid) { tblRegistration objTr = new tblRegistration(); objTr.Createddate = DateTime.Now; objTr.IsActive = true; objTr.Email = objUr.Email; objTr.Username = objUr.UserName; objTr.Password = objUr.Password; db.tblRegistrations.Add(objTr); db.SaveChanges(); return(RedirectToAction("Login")); } else { return(View()); } } catch (Exception _Ex) { string msg = ""; return(RedirectToAction("Error", msg = _Ex.Message)); } }
public string UpdateAccess(int userId, string ids) { using (SourceControlEntities Db = new SourceControlEntities()) { Db.Database.ExecuteSqlCommand("DELETE FROM UserRole WHERE UserId = " + userId); Db.SaveChanges(); string[] roleIds = ids.Split(new char[] { ',' }); foreach (string roleId in roleIds) { Db.UserRoles.Add(new UserRole { RoleId = Convert.ToInt32(roleId), UserId = userId }); } Db.SaveChanges(); return("SUCCESS"); } }
public string SubmitRequestAccess(string menuIds) { using (SourceControlEntities Db = new SourceControlEntities()) { Db.Database.ExecuteSqlCommand("DELETE FROM UserMenuAccess WHERE IsRequest = 1 AND UserId = " + SessionService.UserId); Db.SaveChanges(); string[] ids = menuIds.Split(new char[] { ',' }); foreach (string id in ids) { Db.UserMenuAccesses.Add(new UserMenuAccess { MenuId = Convert.ToInt32(id), UserId = SessionService.UserId }); } Db.SaveChanges(); return("SUCCESS"); } }
public static string ClearError() { try { using (SourceControlEntities Db = new SourceControlEntities()) { Db.Database.ExecuteSqlCommand("TRUNCATE TABLE DebugLog"); Db.SaveChanges(); return(""); } } catch (Exception ex) { return(ex.StackTrace + ex.Message); } }
public ActionResult AddUser(AddUser objUser) { try { string filename = Path.GetFileNameWithoutExtension(objUser.ImageFile.FileName); string extension = Path.GetExtension(objUser.ImageFile.FileName); filename = filename + DateTime.Now.ToString("yymmssfff") + extension; var temp = filename; objUser.ProductImage = "~/UserImage/" + filename; filename = Path.Combine(Server.MapPath("~/UserImage/"), filename); objUser.ImageFile.SaveAs(filename); tblUserDetail objUd = new tblUserDetail(); objUd.Photo = temp; objUd.IsActive = true; string fname = objUser.FirstName; string mname = objUser.MiddleName; string lname = objUser.LastName; fname = fname.First().ToString().ToUpper() + fname.Substring(1); mname = mname.First().ToString().ToUpper() + mname.Substring(1); lname = lname.First().ToString().ToUpper() + lname.Substring(1); string name = fname + mname + lname; objUd.Name = name; objUd.Pincode = objUser.Pincode; objUd.State = objUser.State; objUd.Email = objUser.Email; objUd.CreditcardNumber = objUser.CreditCardNumber; objUd.Createddate = DateTime.Now; objUd.Country = objUser.Country; objUd.City = objUser.City; objUd.AddressLine2 = objUser.AdresLine2; objUd.AddressLine1 = objUser.AdressLine1; db.tblUserDetails.Add(objUd); if (db.SaveChanges() > 0) { TempData["msg"] = "Data Added Successfully!!!!!"; } return(RedirectToAction("Index")); } catch (Exception _Ex) { string message = _Ex.Message; return(RedirectToAction("Error", message)); } }
public string SaveNote(int pageTemplateId, int columnDefId, int recordId, string noteText) { using (SourceControlEntities Db = new SourceControlEntities()) { var note = new Note { ColumnDefId = columnDefId, InsertBy = SessionService.UserId, RecordId = recordId, NoteText = noteText, InsertDate = DateTime.Now }; Db.Notes.Add(note); Db.SaveChanges(); return(GetPartialNote(columnDefId, recordId)); } }
public static void LogError(string logContent) { //if (!SessionService.EnableDebugLog) return; try { using (SourceControlEntities Db = new SourceControlEntities()) { string hostName = System.Net.Dns.GetHostName(); DebugLog log = new DebugLog(); log.Source = hostName; log.LogContent = logContent; log.LogDate = DateTime.Now; Db.DebugLogs.Add(log); Db.SaveChanges(); } } catch (Exception ex) { var msg = ex.StackTrace + ex.Message; } }
public ActionResult Index() { //string html = System.IO.File.ReadAllText(@"D:\Kraken\SourceControl\App_Data\SampleEIDMHtml.txt"); //var pdfBytes = Pdf.From(html).WithGlobalSetting("orientation", "Landscape").Content(); //System.IO.File.WriteAllBytes("C:\\Temp\\Test2.pdf", pdfBytes); string username = User.Identity.Name.ToString(); //string username = "******"; //Helper.LogError("User tried to log in " + username + " at " + DateTime.Now); using (SourceControlEntities Db = new SourceControlEntities()) { var user = Db.AppUsers.Where(a => a.AdName == username).FirstOrDefault(); if (user == null) { //username = "******"; ///New user. Add to AppUser, set to inactive AppUser appUser = new AppUser { AdName = username, FirstName = "", LastName = "", Email = "", PrimaryPhone = "", IsActive = true, ProfileIsComplete = false, LogonCount = 0, Password = "", AddDate = DateTime.Now }; try { using (var context = new PrincipalContext(ContextType.Domain)) { var principal = UserPrincipal.FindByIdentity(context, User.Identity.Name); appUser.FirstName = Helper.ToSafeString(principal.GivenName); appUser.LastName = Helper.ToSafeString(principal.Surname); appUser.Email = Helper.ToSafeString(principal.EmailAddress); appUser.PrimaryPhone = Helper.ToSafeString(principal.VoiceTelephoneNumber); } } catch (Exception) { } Db.AppUsers.Add(appUser); Db.SaveChanges(); EmailService.SendEmail(SessionService.NetworkToolboxEmailAddress(), SessionService.NetworkToolboxEmailAddress(), "", "New user requesting access on Network Toolbox.", appUser.FirstName + " " + appUser.LastName + "<br>" + appUser.Email + "<br>" + username); user = Db.AppUsers.Where(a => a.AdName == username).FirstOrDefault(); } if (user == null) { return(RedirectToAction("Login", "Home")); } else { Session["sec.CurrentUser"] = user; } } var columnDefs = SessionService.ColumnDefs(2126); var pageTemplates = SessionService.PageTemplates(1); return(View()); }
public string SortGridColumn(string id, int fromColumnIndex, int toColumnIndex, int newOrder, int pageTemplateId = 0) { try { var gridColumnId = 0; var oldOrder = 0; using (SourceControlEntities Db = new SourceControlEntities()) { // set to available. Contains GridColumnId if (fromColumnIndex == 2 && toColumnIndex == 1 && id.Contains("GridColumnId")) { gridColumnId = Convert.ToInt32(id.Replace("GridColumnId", "")); var gridColumn = Db.GridColumns.Find(gridColumnId); pageTemplateId = gridColumn.PageTemplateId; newOrder = 10000; // force reorder of everything Db.Database.ExecuteSqlCommand("DELETE FROM GridColumn WHERE GridColumnId = " + gridColumnId); } // set to be in grid. Contains ColumnDefId if (fromColumnIndex == 1 && toColumnIndex == 2 && id.Contains("ColumnDefId")) { var columnDefId = Convert.ToInt32(id.Replace("ColumnDefId", "")); var columnDef = Db.ColumnDefs.Find(columnDefId); pageTemplateId = columnDef.PageTemplateId; oldOrder = 10000; // reorder records >= newOrder // add GridColumn var gridColumn = new GridColumn { ColumnDefId = columnDefId, PageTemplateId = pageTemplateId, SortOrder = newOrder }; Db.GridColumns.Add(gridColumn); Db.SaveChanges(); gridColumnId = gridColumn.GridColumnId; } // Reorder within grid. Contains GridColumnId if (fromColumnIndex == 2 && toColumnIndex == 2 && id.Contains("GridColumnId")) { gridColumnId = Convert.ToInt32(id.Replace("GridColumnId", "")); var gridColumn = Db.GridColumns.Find(gridColumnId); pageTemplateId = gridColumn.PageTemplateId; oldOrder = gridColumn.SortOrder; // update GridColumn.SortOrder gridColumn.SortOrder = newOrder; Db.Entry(gridColumn).State = EntityState.Modified; Db.SaveChanges(); } // Reorder GridColumn if (pageTemplateId > 0) { Db.Database.ExecuteSqlCommand("dbo.SortGridColumn @pageTemplateId, @gridColumnId, @oldOrder, @newOrder", new[] { new SqlParameter("@pageTemplateId", pageTemplateId), new SqlParameter("@gridColumnId", gridColumnId), new SqlParameter("@oldOrder", oldOrder), new SqlParameter("@newOrder", newOrder) }); } } return(""); } catch (Exception ex) { return(ex.Message); } }
public string GetPageTemplates(int dbEntityId) { using (SourceControlEntities Db = new SourceControlEntities()) { // initialize GridColumn table from PageTemplate.GridColumns var gridColumns_ = Db.GridColumns.ToList(); if (gridColumns_.Count == 0) { var sortOrder = 0; List <GridColumn> gridColumns = new List <GridColumn>(); var pageTemplates = Db.PageTemplates; foreach (var pageTemplate in pageTemplates.Where(w => w.GridColumns.Length > 1)) { sortOrder = 0; int[] ids = Array.ConvertAll(pageTemplate.GridColumns.Split(new char[] { ',' }), s => int.Parse(s)); for (int i = 0; i < ids.Length; i++) { sortOrder++; GridColumn gridColumn = new GridColumn { ColumnDefId = ids[i], PageTemplateId = pageTemplate.PageTemplateId, SortOrder = sortOrder }; gridColumns.Add(gridColumn); } } Db.GridColumns.AddRange(gridColumns); Db.SaveChanges(); } // initialize SortColumn table from PageTemplate.SortColumns var sortColumns_ = Db.SortColumns.ToList(); if (sortColumns_.Count == 0) { var sortOrder = 0; List <SortColumn> sortColumns = new List <SortColumn>(); var pageTemplates = Db.PageTemplates; foreach (var pageTemplate in pageTemplates.Where(w => w.SortColumns.Length > 1)) { sortOrder = 0; string[] ids = pageTemplate.SortColumns.Split(new char[] { ',' }); for (int i = 0; i < ids.Length; i++) { sortOrder++; var id_ = ids[i].Replace("ASC", "").Replace("DESC", "").Replace(" ", ""); SortColumn sortColumn = new SortColumn { ColumnDefId = Convert.ToInt32(id_), PageTemplateId = pageTemplate.PageTemplateId, SortOrder = sortOrder, SortDir = "ASC" }; sortColumns.Add(sortColumn); } } Db.SortColumns.AddRange(sortColumns); Db.SaveChanges(); } var recs = Db.PageTemplates.Where(w => w.DbEntityId == dbEntityId).OrderBy(o => o.TemplateName).Select(s => new { s.PageTemplateId, s.TemplateName }); var json = JsonConvert.SerializeObject(recs); return(json); } }