public virtual ActionResult Delete(long?id)
{
IMDResponse res = new MDResponse();
new SaveService().Delete(id, ref res);
return(Redirect("/"));
}
public virtual ActionResult Save(TViewModel vm)
{
var res = MDResponse.New();
new SaveService().Save(vm, ref res);
return(Return <TViewModel>(ref res, vm, Redirect("/"), RedirectToAction("SetVM", vm)));
}
public override ActionResult Save(EmployeeVM vm)
{
var authService = new AuthService();
var res = MDResponse.New();
authService.EmployeeSet(vm, ref res);
return(Return(ref res, vm, Redirect("/"), this.SetVM));
}
public List<TEntity> Exec(string sql, params SqlParameter[] parameters)
{
try
{
return context.Database.SqlQuery<TEntity>(sql, parameters).ToList();
}
catch(Exception ex) { MDResponse.CallErrorHandlers(ex, sql); return null; }
}
public ActionResult RegisterSet(ClientVM model)
{
var authService = new AuthService();
var res = MDResponse.New();
authService.ClientSet(model, ref res);
return(Return <ClientVM>(ref res, model, Redirect("Index", "Home"), Redirect("Register")));
}
public override ActionResult Save(UserAccountVM vm)
{
var service = new AuthService();
var res = MDResponse.New();
service.UserAccountSet(vm, ref res);
return(Redirect("/", "Auth"));
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AutoMapperConfiguration.Configure();
Setup.Seed();
Setup.Config();
MDResponse.RegisterErrorHandler((ex, obj) => Elmah.ErrorSignal.FromCurrentContext().Raise(ex));
RulesSetup.Setup();
}
public static string ToCountryDateTime(DateTime utcDateTime)
{
string countryTimeZone = RailsToWindows(SessionHelper.CurrentCountryTimeZone);
if (!string.IsNullOrWhiteSpace(countryTimeZone))
{
try
{
var dateTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(utcDateTime, TimeZoneInfo.Utc.DisplayName, countryTimeZone);
return(DateTimeHelper.ToStringDD_MM_YYYY_TIME(dateTime));
}
catch (Exception ex)
{
MDResponse.CallErrorHandlers(ex, utcDateTime);
}
}
return(DateTimeHelper.ToStringDD_MM_YYYY_TIME(utcDateTime));
}
public static void Seed()
{
var uw = new UnitWork();
var res = MDResponse.New();
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 1, Name = "admin", DisplayName = "مدير النظام"
}, ref res);
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 2, Name = "super", DisplayName = "الادارة العليا"
}, ref res);
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 3, Name = "manager", DisplayName = "مدير"
}, ref res);
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 4, Name = "employee", DisplayName = "موظف"
}, ref res);
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 5, Name = "client", DisplayName = "مستثمر"
}, ref res);
uw.Command <Role>().AddOrUpdate(new Role()
{
Id = 6, Name = "hospital", DisplayName = "مستشفي"
}, ref res);
uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 1,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "Admin",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
uw.Command <Employee>().AddOrUpdate(new Employee()
{
Id = 1, ADUsername = "******", UserAccount_Id = 1
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 1, RoleId = 1, UserId = 1
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 2, RoleId = 2, UserId = 1
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 3, RoleId = 3, UserId = 1
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 4, RoleId = 4, UserId = 1
}, ref res);
uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 2,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "Super",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
uw.Command <Employee>().AddOrUpdate(new Employee()
{
Id = 2, ADUsername = "******", UserAccount_Id = 2
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 5, RoleId = 2, UserId = 2
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 6, RoleId = 3, UserId = 2
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 7, RoleId = 4, UserId = 2
}, ref res);
uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 3,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "Manager",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
uw.Command <Employee>().AddOrUpdate(new Employee()
{
Id = 3, ADUsername = "******", UserAccount_Id = 3
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 8, RoleId = 3, UserId = 3
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 9, RoleId = 4, UserId = 3
}, ref res);
uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 4,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "Employee",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
uw.Command <Employee>().AddOrUpdate(new Employee()
{
Id = 4, ADUsername = "******", UserAccount_Id = 4
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 10, RoleId = 4, UserId = 4
}, ref res);
var c1 = uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 5,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "SubAccount1",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
var c2 = uw.Command <UserAccount>().AddOrUpdate(
new UserAccount()
{
Id = 6,
UserName = "******",
PasswordHash = new PasswordHasher().HashPassword("123"),
Email = "*****@*****.**",
IsEnabled = 1,
FullName = "SubAccount2",
CountryCode = 1,
PhoneNumber = "123",
SSID = "123",
LockoutEnabled = true,
SecurityStamp = Guid.NewGuid().ToString("D")
}, ref res);
uw.Command <Client>().AddOrUpdate(new Client()
{
Id = 1,
UserAccounts = new List <UserAccount>()
{
c1, c2
},
Organization = "Alinma",
FullName = "Alinma",
SSID = "1233"
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 11, RoleId = 5, UserId = 5
}, ref res);
uw.Command <UserRoles>().AddOrUpdate(new UserRoles()
{
Id = 12, RoleId = 5, UserId = 6
}, ref res);
//----------------- lookups -----------------------//
uw.Command <Country>().AddOrUpdate(new Country()
{
Id = 1, Name = "المملكة العربية السعودية"
}, ref res);
uw.Command <Country>().AddOrUpdate(new Country()
{
Id = 2, Name = "جمهورية مصر العربية"
}, ref res);
uw.Command <City>().AddOrUpdate(new City()
{
Id = 1, Name = "الرياض", CountryID = 1
}, ref res);
uw.Command <City>().AddOrUpdate(new City()
{
Id = 2, Name = "الدمام", CountryID = 1
}, ref res);
uw.Command <City>().AddOrUpdate(new City()
{
Id = 3, Name = "جدة", CountryID = 1
}, ref res);
uw.Command <IndustrialCity>().AddOrUpdate(new IndustrialCity()
{
Id = 1, Name = "المدينة الصناعية الاولي بالرياض", City_Id = 1
}, ref res);
uw.Command <IndustrialCity>().AddOrUpdate(new IndustrialCity()
{
Id = 2, Name = "المدينة الصناعية الثانية بالرياض", City_Id = 1
}, ref res);
uw.Command <IndustrialCity>().AddOrUpdate(new IndustrialCity()
{
Id = 3, Name = "المدينة الصناعية الاولي بالدمام", City_Id = 2
}, ref res);
uw.Command <IndustrialCity>().AddOrUpdate(new IndustrialCity()
{
Id = 4, Name = "المدينة الصناعية الاولي بجدة", City_Id = 3
}, ref res);
uw.Command <IndustrialCity>().AddOrUpdate(new IndustrialCity()
{
Id = 5, Name = "المدينة الصناعية الثانية بجدة", City_Id = 3
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 1, Name = "مجمع 1 بالرياض", IndustrialCity_Id = 1
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 2, Name = "مجمع 2 بالرياض", IndustrialCity_Id = 1
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 3, Name = "مجمع 1 بالدمام", IndustrialCity_Id = 3
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 4, Name = "مجمع 2 بالدمام", IndustrialCity_Id = 3
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 5, Name = "مجمع 1 بجدة", IndustrialCity_Id = 4
}, ref res);
uw.Command <FacilitiesGroup>().AddOrUpdate(new FacilitiesGroup()
{
Id = 6, Name = "مجمع 2 بجدة", IndustrialCity_Id = 4
}, ref res);
uw.Command <MainActivity>().AddOrUpdate(new MainActivity()
{
Id = 1, Name = "مطاعم"
}, ref res);
uw.Command <MainActivity>().AddOrUpdate(new MainActivity()
{
Id = 2, Name = "مخابز"
}, ref res);
uw.Command <MainActivity>().AddOrUpdate(new MainActivity()
{
Id = 3, Name = "تموينات"
}, ref res);
uw.Command <MainActivity>().AddOrUpdate(new MainActivity()
{
Id = 4, Name = "محلات سباكة"
}, ref res);
uw.Command <MainActivity>().AddOrUpdate(new MainActivity()
{
Id = 5, Name = "عصائر"
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 1, Name = "مطعم مشويات", MainActivity_Id = 1
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 2, Name = "مطعم مندي", MainActivity_Id = 1
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 3, Name = "مطعم كبسة", MainActivity_Id = 1
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 4, Name = "مخبز عادي", MainActivity_Id = 2
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 5, Name = "مخبز كهربي", MainActivity_Id = 2
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 6, Name = "بقالة", MainActivity_Id = 3
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 7, Name = "سوبرماركت", MainActivity_Id = 3
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 8, Name = "ادوات منزلية", MainActivity_Id = 4
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 9, Name = "عصائر طبيعية", MainActivity_Id = 5
}, ref res);
uw.Command <SubActivity>().AddOrUpdate(new SubActivity()
{
Id = 10, Name = "عصائر صناعية", MainActivity_Id = 5
}, ref res);
uw.Save(ref res);
}
public static void Config()
{
MDResponse.RegisterErrorHandler(MDLog.Error);
}
