public static void AddService(Service service)
{
using (var wdc = new WebserviceDataContext())
{
wdc.Services.InsertOnSubmit(new DataModelLib.Service
{
ServiceURL = service.ServiceURL,
ServiceName = service.ServiceName,
UpdateUser = service.UpdateUser,
UpdateDateTime = DateTime.Now,
Description = service.Description
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void AddUserService(UserService userService)
{
using (var hdc = new WebserviceDataContext())
{
hdc.UserServices.InsertOnSubmit(new DataModelLib.UserService
{
ServiceId = userService.ServiceId,
UserId = userService.UserId,
UpdateUser = userService.UpdateUser,
UpdateDateTime = DateTime.Now,
Ips = userService.Ips,
Status = userService.Status
});
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void StoreError(string errMsg, string stacktrace, string Url)
{
try
{
using (var wdc = new WebserviceDataContext())
{
wdc.ErrorLogs.InsertOnSubmit(new ErrorLog()
{
ErrorDate = DateTime.Now,
ClientIp = HttpContext.Current.Request.UserHostAddress,
Detail = stacktrace,
Message = errMsg,
Url = Url
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void StoreError(string errMsg, string stacktrace, string Url)
{
try
{
using (var wdc = new WebserviceDataContext())
{
wdc.ErrorLogs.InsertOnSubmit(new ErrorLog()
{
ErrorDate = DateTime.Now,
ClientIp = HttpContext.Current.Request.UserHostAddress,
Detail = stacktrace,
Message = errMsg,
Url = Url
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateUserService(UserService userService)
{
using (var hdc = new WebserviceDataContext())
{
var getUserService = hdc.UserServices.Single(item => item.Id == userService.Id);
getUserService.ServiceId = userService.ServiceId;
getUserService.UserId = userService.UserId;
getUserService.UpdateUser = userService.UpdateUser;
getUserService.UpdateDateTime = DateTime.Now;
getUserService.Status = userService.Status;
getUserService.Ips = userService.Ips;
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static bool AuthorizeUserService(string username, string password, string ip, string url, string service)
{
var isAuthorized = false;
var userId = UserHelper.Authentication(username, password);
var serviceId = ServiceHelper.GetServiceFromUrl(url,service);
if (userId == 0 || serviceId == 0) return false;
using (var wdc = new WebserviceDataContext())
{
var count = wdc.UserServices.Count(item => item.UserId==userId && item.ServiceId==serviceId && item.Status==1);
if (count != 0)
{
var ips = wdc.UserServices.Single(item => item.UserId == userId && item.ServiceId == serviceId && item.Status==1).Ips;
if(ips.Contains(';'))
{
var strIp = ips.Split(';');
if (strIp.Any(s => s.Equals(ip)))
{
isAuthorized = true;
}
}
else
{
if (string.IsNullOrEmpty(ips))
{
return true;
}
if (ips.Equals(ip)) isAuthorized = true;
}
}
}
return isAuthorized;
}
public static string UserFuckService(int usId, string ip)
{
var wdc = new WebserviceDataContext();
var ips = wdc.UserServices.Single(item => item.Id == usId).Ips;
var str = ips;
if (ips.Contains(';'))
{
var strIp = ips.Split(';');
if (strIp.Any(s => s.Equals(ip)))
{
str += " true";
}
}
else
{
if (string.IsNullOrEmpty(ips))
{
return(str += " true");
}
if (ips.Equals(ip))
{
str += " true";
}
}
return(str);
}
public static void UpdateService(Service service)
{
using (var wdc = new WebserviceDataContext())
{
var s = wdc.Services.Single(item => item.ServiceId == service.ServiceId);
s.ServiceName = service.ServiceName;
s.ServiceURL = service.ServiceURL;
s.UpdateUser = service.UpdateUser;
s.UpdateDateTime = DateTime.Now;
s.Description = service.Description;
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void AddService(Service service)
{
using (var wdc = new WebserviceDataContext())
{
wdc.Services.InsertOnSubmit(new DataModelLib.Service
{
ServiceURL = service.ServiceURL,
ServiceName = service.ServiceName,
UpdateUser = service.UpdateUser,
UpdateDateTime = DateTime.Now,
Description = service.Description
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void UpdateUser(User user)
{
using (var hdc = new WebserviceDataContext())
{
var usr = hdc.Users.Single(item => item.UserId == user.UserId);
usr.Username = user.Username;
usr.Password = user.Password;
usr.Description = user.Description;
usr.UpdateUser = user.UpdateUser;
usr.UpdateDateTime = DateTime.Now;
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void UpdateService(Service service)
{
using (var wdc = new WebserviceDataContext())
{
var s = wdc.Services.Single(item => item.ServiceId == service.ServiceId);
s.ServiceName = service.ServiceName;
s.ServiceURL = service.ServiceURL;
s.UpdateUser = service.UpdateUser;
s.UpdateDateTime = DateTime.Now;
s.Description = service.Description;
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void AddUser(User user)
{
using (var hdc = new WebserviceDataContext())
{
hdc.Users.InsertOnSubmit(new User
{
Username = user.Username,
Password = user.Password,
Description = user.Description,
UpdateUser = user.UpdateUser,
UpdateDateTime = DateTime.Now
});
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void StoreConsumeService(string ip, string url, string username, string service)
{
try
{
using (var wdc = new WebserviceDataContext())
{
wdc.ConsumeLogs.InsertOnSubmit(new ConsumeLog()
{
Date = DateTime.Now,
ClientIp = ip,
Url = url,
Username = username,
Service = service
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void AddUserService(UserService userService)
{
using (var hdc = new WebserviceDataContext())
{
hdc.UserServices.InsertOnSubmit(new DataModelLib.UserService
{
ServiceId = userService.ServiceId,
UserId = userService.UserId,
UpdateUser = userService.UpdateUser,
UpdateDateTime = DateTime.Now,
Ips = userService.Ips,
Status = userService.Status
});
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void StoreConsumeService(string ip, string url, string username, string service)
{
try
{
using (var wdc = new WebserviceDataContext())
{
wdc.ConsumeLogs.InsertOnSubmit(new ConsumeLog()
{
Date = DateTime.Now,
ClientIp = ip,
Url = url,
Username = username,
Service = service
});
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool IsUserExist(string username)
{
var user = false;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Users.Count(item => item.Username == username);
if (count != 0)
{
user = true;
}
}
return(user);
}
public static int GetServiceFromUrl(string url, string service)
{
var serviceId = 0;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Services.Count(item => item.ServiceURL.ToLower().Equals(url.ToLower())&&item.ServiceName.ToLower().Equals(service.ToLower()));
if (count != 0)
{
var services = hdc.Services.Single(item => item.ServiceURL.Equals(url));
serviceId = services.ServiceId;
}
}
return serviceId;
}
public static int Authentication(string username, string password)
{
var userId = 0;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Users.Count(item => item.Username.Equals(username) && item.Password.Equals(password));
if (count != 0)
{
var user = hdc.Users.Single(item => item.Username.Equals(username) && item.Password.Equals(password));
userId = user.UserId;
}
}
return(userId);
}
public static int GetServiceFromUrl(string url, string service)
{
var serviceId = 0;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Services.Count(item => item.ServiceURL.ToLower().Equals(url.ToLower()) && item.ServiceName.ToLower().Equals(service.ToLower()));
if (count != 0)
{
var services = hdc.Services.Single(item => item.ServiceURL.Equals(url));
serviceId = services.ServiceId;
}
}
return(serviceId);
}
public static void DeleteUserService(int userServiceId)
{
using (var hdc = new WebserviceDataContext())
{
var userService = hdc.UserServices.Single(item => item.Id == userServiceId);
hdc.UserServices.DeleteOnSubmit(userService);
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void DeleteService(int serviceId)
{
using (var wdc = new WebserviceDataContext())
{
var service = wdc.Services.Single(item => item.ServiceId == serviceId);
wdc.Services.DeleteOnSubmit(service);
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void DeleteService(int serviceId)
{
using (var wdc = new WebserviceDataContext())
{
var service = wdc.Services.Single(item => item.ServiceId == serviceId);
wdc.Services.DeleteOnSubmit(service);
try
{
wdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void DeleteUserService(int userServiceId)
{
using (var hdc = new WebserviceDataContext())
{
var userService = hdc.UserServices.Single(item => item.Id ==userServiceId);
hdc.UserServices.DeleteOnSubmit(userService);
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static bool AuthorizeUserService(string username, string password, string ip, string url, string service)
{
var isAuthorized = false;
var userId = UserHelper.Authentication(username, password);
var serviceId = ServiceHelper.GetServiceFromUrl(url, service);
if (userId == 0 || serviceId == 0)
{
return(false);
}
using (var wdc = new WebserviceDataContext())
{
var count = wdc.UserServices.Count(item => item.UserId == userId && item.ServiceId == serviceId && item.Status == 1);
if (count != 0)
{
var ips = wdc.UserServices.Single(item => item.UserId == userId && item.ServiceId == serviceId && item.Status == 1).Ips;
if (ips.Contains(';'))
{
var strIp = ips.Split(';');
if (strIp.Any(s => s.Equals(ip)))
{
isAuthorized = true;
}
}
else
{
if (string.IsNullOrEmpty(ips))
{
return(true);
}
if (ips.Equals(ip))
{
isAuthorized = true;
}
}
}
}
return(isAuthorized);
}
public static List <DataModelLib.Helper.UserService> ListUserService()
{
var mdc = new WebserviceDataContext();
List <DataModelLib.Helper.UserService> listUserService = null;
listUserService = (from userService in mdc.UserServices
join service in mdc.Services on userService.ServiceId equals service.ServiceId
join user in mdc.Users on userService.UserId equals user.UserId
orderby user.Username, service.ServiceName
select new DataModelLib.Helper.UserService()
{
Id = userService.Id,
Username = user.Username,
ServiceName = service.ServiceName,
Description = service.Description,
ServiceUrl = service.ServiceURL,
Status = userService.Status,
Ips = userService.Ips
}).ToList();
return(listUserService);
}
public static List<Service> ListService()
{
var wdc = new WebserviceDataContext();
return wdc.Services.ToList();
}
public static List <User> ListUser()
{
var wdc = new WebserviceDataContext();
return(wdc.Users.ToList());
}
public static List <Service> ListService()
{
var wdc = new WebserviceDataContext();
return(wdc.Services.ToList());
}
public static int CountUserService(int userId, int serviceId)
{
var wdc = new WebserviceDataContext();
return wdc.UserServices.Single(item => item.UserId == userId && item.ServiceId == serviceId && item.Status == 1).Id;
}
public static int CountUserService(int userId, int serviceId)
{
var wdc = new WebserviceDataContext();
return(wdc.UserServices.Single(item => item.UserId == userId && item.ServiceId == serviceId && item.Status == 1).Id);
}
public static string UserFuckService(int usId, string ip)
{
var wdc = new WebserviceDataContext();
var ips = wdc.UserServices.Single(item => item.Id == usId).Ips;
var str = ips;
if (ips.Contains(';'))
{
var strIp = ips.Split(';');
if (strIp.Any(s => s.Equals(ip)))
{
str += " true";
}
}
else
{
if (string.IsNullOrEmpty(ips))
{
return str += " true";
}
if (ips.Equals(ip)) str += " true";
}
return str;
}
public static List<DataModelLib.Helper.UserService> ListUserService()
{
var mdc = new WebserviceDataContext();
List<DataModelLib.Helper.UserService> listUserService= null;
listUserService = (from userService in mdc.UserServices
join service in mdc.Services on userService.ServiceId equals service.ServiceId
join user in mdc.Users on userService.UserId equals user.UserId
orderby user.Username, service.ServiceName
select new DataModelLib.Helper.UserService()
{
Id = userService.Id,
Username = user.Username,
ServiceName = service.ServiceName,
Description = service.Description,
ServiceUrl = service.ServiceURL,
Status = userService.Status,
Ips = userService.Ips
}).ToList();
return listUserService;
}
public static void UpdateUserService(UserService userService)
{
using (var hdc = new WebserviceDataContext())
{
var getUserService = hdc.UserServices.Single(item => item.Id == userService.Id);
getUserService.ServiceId = userService.ServiceId;
getUserService.UserId = userService.UserId;
getUserService.UpdateUser = userService.UpdateUser;
getUserService.UpdateDateTime = DateTime.Now;
getUserService.Status = userService.Status;
getUserService.Ips = userService.Ips;
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
