public ActionResult GetAllPhrases(int Id)
{
string sql = string.Format("exec GetPhrases '" + Id + "'");
try
{
using (ERPConfigurationContext dbContext = new ERPConfigurationContext())
{
var phrases = dbContext.Database.SqlQuery <Phrases>(sql).Select(x => x.Phrase).ToList();
if (phrases != null)
{
return(Json(phrases, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetNewFileIdforMoveToProcess(string FileNo)
{
//RBACUser rUser = new RBACUser(Session["UserName"].ToString());
//if (!rUser.HasPermission("Group_Edit"))
//{
// return Json("D", JsonRequestBehavior.AllowGet);
//}
try
{
FileMain FileMainAdd = new FileMain();
var data = _fileMainService.All().ToList().FirstOrDefault(x => x.FileNo == FileNo);
var MainID = _fileMainService.All().ToList().Where(x => x.FileNo == FileNo).Select(x => x.MainID).FirstOrDefault();
string sql = string.Format(" Select fd.AttachFileName as FileName from FileDetail as fd where MainID= '" + MainID + "' " +
" union select AttachFileName from FileTransDetail where FileTransID in " +
"(select FileTransID from FileTransMain where MainID = '" + MainID + "')");
List <ProcessActionVM> VchrList;
using (ERPConfigurationContext dbContext = new ERPConfigurationContext())
{
VchrList = dbContext.Database.SqlQuery <ProcessActionVM>(sql).ToList();
}
// ViewBag.Items = VchrList;
if (data != null)
{
FileMainAdd = data;
}
return(Json(new { FileMainAdd, VchrList }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public IEnumerable <TEntity> SqlQueary(string sql, params object[] parameters)
{
//using ()
//{
// a.Database.CommandTimeout = 1000;
var a = new ERPConfigurationContext();
return(a.Database.SqlQuery <TEntity>(sql, parameters));
//}
//Context.Database.CommandTimeout = 1000;
}
//public ActionResult FileProcessActionPdf(string sNo)
//{
// var markToId = _fileMainService.All().Where(x => x.FileNo == sNo).Select(x => x.UpdUserID).LastOrDefault();
// var MainId = _fileMainService.All().Where(x => x.FileNo == sNo).Select(x => x.MainID).LastOrDefault();
// string sql = string.Format("Select td.FileNo, td.FileRef as Reference, td.FileSub as Subject, td.FileText as Description,tm.AttachFileName as FileName,nc.FileTransNum as Note from FileMain as td " +
// " left join FileDetail as tm on td.MainID = tm.MainID " +
// "left join FileTransMain as nc on nc.MainID = td.MainID " +
// "where td.FileNo = '" + sNo + "' and td.UpdUserID='" + markToId + "'");
// List<ProcessActionPdfVM> VchrList;
// using (ERPConfigurationContext dbContext = new ERPConfigurationContext())
// {
// VchrList = dbContext.Database.SqlQuery<ProcessActionPdfVM>(sql).ToList();
// }
// return View("~/Views/Home/FileProcessActionPdf.cshtml", VchrList);
//}
public ActionResult FileProcessActionPdf(string sNo)
{
var MainId = _fileMainService.All().Where(x => x.FileNo == sNo).Select(x => x.MainID).LastOrDefault();
string sql = string.Format("rptFileTrans '" + MainId + "'");
IEnumerable <ProcessActionPreviewVM> VchrList;
using (ERPConfigurationContext dbContext = new ERPConfigurationContext())
{
VchrList = dbContext.Database.SqlQuery <ProcessActionPreviewVM>(sql).ToList();
}
return(View("~/Views/Home/FileProcessActionPdf.cshtml", VchrList));
}
//protected void Application_Start()
//{
// AreaRegistration.RegisterAllAreas();
// WebApiConfig.Register(GlobalConfiguration.Configuration);
// FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
// RouteConfig.RegisterRoutes(RouteTable.Routes);
// BundleConfig.RegisterBundles(BundleTable.Bundles);
// AuthConfig.RegisterAuth();
//}
protected void Application_Start()
{
//Database.SetInitializer(new MigrateDatabaseToLatestVersion<SCAppContext, System.Data.Entity.Migrations.DbMigrationsConfiguration<SCAppContext>>("DefaultConnection"));
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
using (var context = new ERPConfigurationContext())
{
if (!context.Database.Exists())
{
// Register the SimpleMembership database without Entity Framework migration schema
//((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
context.Database.Create();
}
context.Database.Initialize(true);
//context.Database.Delete();
//context.Database.Create();
}
string url = ""; //HttpContext.Current.Request.Url.AbsoluteUri;
//string url = HttpContext.Current.Request.Url.Authority;
//if (url == "ntcgarden.accline.com")
//{
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "Username", autoCreateTables: true);
//}
//else if (url == "ntctest.accline.com")
//{
// WebSecurity.InitializeDatabaseConnection("testConnection", "UserProfile", "UserId", "Username", autoCreateTables: true);
//}
//else
//{
// WebSecurity.InitializeDatabaseConnection("testConnection", "UserProfile", "UserId", "Username", autoCreateTables: true);
//}
}
private void GetDatabaseUserRolesPermissions()
{
using (ERPConfigurationContext _data = new ERPConfigurationContext())
{
SecUserInfo _user = _data.SecUserInfo.Where(u => u.UserName == this.UserName).FirstOrDefault();
if (_user != null)
{
this.UserID = _user.UserID;
foreach (SecUserInGroup _group in _user.SecUserInGroups)
{
SecUserGroup _uGroup = _data.SecUserGroup.Where(u => u.GroupID == _group.GroupID).FirstOrDefault();
UserRole _userRole = new UserRole {
Role_Id = _group.GroupID, RoleName = _uGroup.GroupName
};
List <SecFormRight> _fRightList = _data.SecFormRight.Where(u => u.GroupID == _group.GroupID).ToList();
foreach (SecFormRight _fRight in _fRightList)
{
SecFormProcess _fproc = _data.SecFormProcess.Where(u => u.FormProcessID == _fRight.FormProcessID).FirstOrDefault();
SecFormList _frmLst = _data.SecFormList.Where(u => u.FormID == _fproc.FormID).FirstOrDefault();
_userRole.Permissions.Add(new RolePermission {
FormName = _frmLst.FormName, PermissionName = _fproc.ProcessName
});
}
this.Roles.Add(_userRole);
//if (!this.IsSysAdmin)
// this.IsSysAdmin = _group.IsSysAdmin;
}
}
}
//}
}
public void Setvalues(TEntity entity, TEntity existingEntity)
{
var a = new ERPConfigurationContext();
_dbContext.Entry(entity).CurrentValues.SetValues(existingEntity);
}
