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);
}
}