Showing
327 changed files
Too many changes.
To preserve performance only 100 of 327 files are displayed.
400-SOURCECODE/AIAHTML5.ADMIN.API/AIAHTML5.ADMIN.API.csproj
... | ... | @@ -11,8 +11,8 @@ |
11 | 11 | <ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids> |
12 | 12 | <OutputType>Library</OutputType> |
13 | 13 | <AppDesignerFolder>Properties</AppDesignerFolder> |
14 | - <RootNamespace>AIAHTML5.ADMIN.API</RootNamespace> | |
15 | - <AssemblyName>AIAHTML5.ADMIN.API</AssemblyName> | |
14 | + <RootNamespace>ADAM.AIAHTML5.ADMIN.API</RootNamespace> | |
15 | + <AssemblyName>ADAM.AIAHTML5.ADMIN.API</AssemblyName> | |
16 | 16 | <TargetFrameworkVersion>v4.5</TargetFrameworkVersion> |
17 | 17 | <MvcBuildViews>false</MvcBuildViews> |
18 | 18 | <UseIISExpress>true</UseIISExpress> |
... | ... | @@ -825,6 +825,12 @@ |
825 | 825 | <Compile Include="Entity\usp_GetUsageReport_Result.cs"> |
826 | 826 | <DependentUpon>AIADBEntity.tt</DependentUpon> |
827 | 827 | </Compile> |
828 | + <Compile Include="Entity\usp_GetUserList_Result.cs"> | |
829 | + <DependentUpon>AIADBEntity.tt</DependentUpon> | |
830 | + </Compile> | |
831 | + <Compile Include="Entity\usp_GetUsersList_Result.cs"> | |
832 | + <DependentUpon>AIADBEntity.tt</DependentUpon> | |
833 | + </Compile> | |
828 | 834 | <Compile Include="Entity\usp_GetUserTyeByAccountNumber_Result.cs"> |
829 | 835 | <DependentUpon>AIADBEntity.tt</DependentUpon> |
830 | 836 | </Compile> | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/App_Start/BundleConfig.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/App_Start/FilterConfig.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/App_Start/RouteConfig.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/App_Start/WebApiConfig.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/AccountController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("Account")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/CommonController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | |
20 | 20 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/DiscountCodeController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | |
20 | 20 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/EditionController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("Edition")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/LicenseController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("License")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/ReportController.cs
... | ... | @@ -6,14 +6,14 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
16 | -namespace AIAHTML5.ADMIN.API.Controllers | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
17 | 17 | { |
18 | 18 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
19 | 19 | [RoutePrefix("Report")] |
... | ... | @@ -57,7 +57,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
57 | 57 | public IHttpActionResult GetSubscriptionReport(string sFromDate, string sToDate, decimal icStartPrice, decimal icEndPrice, int iLicenseTypeId, int iAccountTypeId, string sZip, int iStateId, int iCountryId, int pageNo, int pageLength) |
58 | 58 | { |
59 | 59 | var spRecordCount = new System.Data.Objects.ObjectParameter("recordCount", 0); |
60 | - var lstExpiringSubscriptionReport = dbContext.GetSubscribedLicenses(sFromDate, sToDate, icStartPrice, icEndPrice, (byte)iLicenseTypeId, (byte)iAccountTypeId, sZip, iStateId, iCountryId, pageNo, pageLength, spRecordCount).ToList(); | |
60 | + var lstExpiringSubscriptionReport = dbContext.usp_GetSubscribedLicenses(sFromDate, sToDate, icStartPrice, icEndPrice, (byte)iLicenseTypeId, (byte)iAccountTypeId, sZip, iStateId, iCountryId, pageNo, pageLength, spRecordCount).ToList(); | |
61 | 61 | return Ok(new { Subscription = lstExpiringSubscriptionReport, RecordCount = spRecordCount.Value }); |
62 | 62 | } |
63 | 63 | [Route("GetSubscriptionCancellationReport")] |
... | ... | @@ -93,7 +93,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
93 | 93 | try |
94 | 94 | { |
95 | 95 | var spRecordCount = new System.Data.Objects.ObjectParameter("recordCount", 0); |
96 | - var lstSiteLicenseUsageReport = dbContext.usp_GetSiteLicenseUsageReport(sFromDate, sToDate, sAccountNumber, (byte)iEdition, pageNo, pageLength, spRecordCount).ToList(); | |
96 | + var lstSiteLicenseUsageReport = dbContext.usp_GetSiteLicenseUsageReports(sFromDate, sToDate, sAccountNumber, (byte)iEdition, pageNo, pageLength, spRecordCount).ToList(); | |
97 | 97 | return Ok(new { SiteLicenseUsageList = lstSiteLicenseUsageReport, RecordCount = spRecordCount.Value }); |
98 | 98 | } |
99 | 99 | catch (Exception ex) | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/SiteController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("Site")] |
... | ... | @@ -60,7 +60,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
60 | 60 | [HttpPost] |
61 | 61 | public HttpResponseMessage InsertUpdateSiteAccount(JObject jsonData) |
62 | 62 | { |
63 | - bool Status = false; | |
63 | + int Status = 0; | |
64 | 64 | SiteModel SiteEntity = new SiteModel(); |
65 | 65 | SiteEntity.LicenseId = jsonData["licenseId"].Value<int>(); |
66 | 66 | SiteEntity.Id = jsonData["siteId"].Value<int>(); |
... | ... | @@ -86,13 +86,14 @@ namespace AIAHTML5.ADMIN.API.Controllers |
86 | 86 | try |
87 | 87 | { |
88 | 88 | Status = SiteModel.InsertUpdateSiteAccount(dbContext, SiteEntity); |
89 | - if (Status) | |
89 | + if (Status > 0) | |
90 | 90 | { |
91 | 91 | return Request.CreateResponse(HttpStatusCode.OK, Status.ToString()); |
92 | 92 | } |
93 | 93 | else |
94 | 94 | { |
95 | 95 | return Request.CreateErrorResponse(HttpStatusCode.BadRequest, Status.ToString()); |
96 | + | |
96 | 97 | } |
97 | 98 | } |
98 | 99 | catch (Exception ex) | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/SubscriptionPriceController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | |
20 | 20 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
... | ... | @@ -109,7 +109,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
109 | 109 | } |
110 | 110 | |
111 | 111 | [Route("DeleteSubscriptionPrice")] |
112 | - [HttpPost] | |
112 | + [HttpGet] | |
113 | 113 | public HttpResponseMessage DeleteSubscriptionPrice(int subscriptionPriceId) |
114 | 114 | { |
115 | 115 | bool Status = false; | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/UserController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | // [EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("User")] |
... | ... | @@ -143,7 +143,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
143 | 143 | [Route("Users")] |
144 | 144 | [HttpGet] |
145 | 145 | public IHttpActionResult UserList(string firstname, string lastname, string emailid, string accountnumber, string usertypeid, string accounttypeid, |
146 | - int pageNo, int pageLength) | |
146 | + int pageNo, int pageLength, int iLoginUserType) | |
147 | 147 | { |
148 | 148 | try |
149 | 149 | { |
... | ... | @@ -154,7 +154,7 @@ namespace AIAHTML5.ADMIN.API.Controllers |
154 | 154 | //var spStatus = new System.Data.Objects.ObjectParameter("Status", 0); |
155 | 155 | var spRecordCount = new System.Data.Objects.ObjectParameter("recordCount", 0); |
156 | 156 | //recordCount = (int)spRecordCount.Value; |
157 | - List<usp_GetSearchUsers_Result> Users = dbContext.usp_GetSearchUsers(firstname, lastname, emailid, accountnumber, UserTypeId, AccountTypeId, 1, pageNo, pageLength, spRecordCount).ToList(); | |
157 | + List<usp_GetUsersList_Result> Users = dbContext.usp_GetUsersList(firstname, lastname, emailid, accountnumber, UserTypeId, AccountTypeId, iLoginUserType, pageNo, pageLength, spRecordCount).ToList(); | |
158 | 158 | return Ok(new { UserList = Users, RecordCount = spRecordCount.Value }); |
159 | 159 | } |
160 | 160 | catch(Exception ex) |
... | ... | @@ -408,7 +408,27 @@ namespace AIAHTML5.ADMIN.API.Controllers |
408 | 408 | |
409 | 409 | #endregion |
410 | 410 | |
411 | - | |
411 | + #region MenuBindForGeneralAdmin | |
412 | + [Route("ManageMenu")] | |
413 | + [HttpGet] | |
414 | + public IHttpActionResult ManageMenu(int UserId, string UserType) | |
415 | + { | |
416 | + dbContext.Configuration.ProxyCreationEnabled = false; | |
417 | + try | |
418 | + { | |
419 | + List<usp_GetManageRights_Result> UserRights = dbContext.usp_GetManageRights(UserId, UserType).Where(s=>s.MenuStatus=="1").ToList(); | |
420 | + return Ok(UserRights); | |
421 | + } | |
422 | + catch (Exception ex) | |
423 | + { | |
424 | + var message = new HttpResponseMessage(HttpStatusCode.BadRequest) | |
425 | + { | |
426 | + Content = new StringContent("We have encountered a technical error and same has been notified to our technical team.") | |
427 | + }; | |
428 | + throw new HttpResponseException(message); | |
429 | + } | |
430 | + } | |
431 | + #endregion | |
412 | 432 | protected HttpResponseMessage ToJson(dynamic obj) |
413 | 433 | { |
414 | 434 | var response = Request.CreateResponse(HttpStatusCode.OK); | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Controllers/UserGroupController.cs
... | ... | @@ -6,15 +6,15 @@ using System.Net.Http; |
6 | 6 | using System.Web.Http; |
7 | 7 | using Newtonsoft.Json; |
8 | 8 | using Newtonsoft.Json.Linq; |
9 | -using AIAHTML5.ADMIN.API.Models; | |
9 | +using ADAM.AIAHTML5.ADMIN.API.Models; | |
10 | 10 | using System.Web.Http.Cors; |
11 | 11 | using System.Web.Cors; |
12 | 12 | using AIAHTML5.Server.Constants; |
13 | 13 | using log4net; |
14 | 14 | using System.Text; |
15 | -using AIAHTML5.ADMIN.API.Entity; | |
15 | +using ADAM.AIAHTML5.ADMIN.API.Entity; | |
16 | 16 | |
17 | -namespace AIAHTML5.ADMIN.API.Controllers | |
17 | +namespace ADAM.AIAHTML5.ADMIN.API.Controllers | |
18 | 18 | { |
19 | 19 | //[EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")] |
20 | 20 | [RoutePrefix("UserGroup")] | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AIADBEntity.Context.cs
... | ... | @@ -7,7 +7,7 @@ |
7 | 7 | // </auto-generated> |
8 | 8 | //------------------------------------------------------------------------------ |
9 | 9 | |
10 | -namespace AIAHTML5.ADMIN.API.Entity | |
10 | +namespace ADAM.AIAHTML5.ADMIN.API.Entity | |
11 | 11 | { |
12 | 12 | using System; |
13 | 13 | using System.Data.Entity; |
... | ... | @@ -4961,5 +4961,169 @@ namespace AIAHTML5.ADMIN.API.Entity |
4961 | 4961 | |
4962 | 4962 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetBlockedUserByAccNoAndType_Result>("usp_GetBlockedUserByAccNoAndType", iUserTypeIdParameter, iLicenseIdParameter); |
4963 | 4963 | } |
4964 | + | |
4965 | + public virtual ObjectResult<string> usp_GetSearchUser(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount) | |
4966 | + { | |
4967 | + var sFirstNameParameter = sFirstName != null ? | |
4968 | + new ObjectParameter("sFirstName", sFirstName) : | |
4969 | + new ObjectParameter("sFirstName", typeof(string)); | |
4970 | + | |
4971 | + var sLastNameParameter = sLastName != null ? | |
4972 | + new ObjectParameter("sLastName", sLastName) : | |
4973 | + new ObjectParameter("sLastName", typeof(string)); | |
4974 | + | |
4975 | + var sEmailIdParameter = sEmailId != null ? | |
4976 | + new ObjectParameter("sEmailId", sEmailId) : | |
4977 | + new ObjectParameter("sEmailId", typeof(string)); | |
4978 | + | |
4979 | + var sAccoutNumberParameter = sAccoutNumber != null ? | |
4980 | + new ObjectParameter("sAccoutNumber", sAccoutNumber) : | |
4981 | + new ObjectParameter("sAccoutNumber", typeof(string)); | |
4982 | + | |
4983 | + var iUserTypeIdParameter = iUserTypeId.HasValue ? | |
4984 | + new ObjectParameter("iUserTypeId", iUserTypeId) : | |
4985 | + new ObjectParameter("iUserTypeId", typeof(int)); | |
4986 | + | |
4987 | + var iAccountTypeIdParameter = iAccountTypeId.HasValue ? | |
4988 | + new ObjectParameter("iAccountTypeId", iAccountTypeId) : | |
4989 | + new ObjectParameter("iAccountTypeId", typeof(int)); | |
4990 | + | |
4991 | + var iLoginUserTypeParameter = iLoginUserType.HasValue ? | |
4992 | + new ObjectParameter("iLoginUserType", iLoginUserType) : | |
4993 | + new ObjectParameter("iLoginUserType", typeof(int)); | |
4994 | + | |
4995 | + var pageNoParameter = pageNo.HasValue ? | |
4996 | + new ObjectParameter("pageNo", pageNo) : | |
4997 | + new ObjectParameter("pageNo", typeof(int)); | |
4998 | + | |
4999 | + var pageLengthParameter = pageLength.HasValue ? | |
5000 | + new ObjectParameter("pageLength", pageLength) : | |
5001 | + new ObjectParameter("pageLength", typeof(int)); | |
5002 | + | |
5003 | + return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_GetSearchUser", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount); | |
5004 | + } | |
5005 | + | |
5006 | + public virtual ObjectResult<string> usp_GetSearchUsers1(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount) | |
5007 | + { | |
5008 | + var sFirstNameParameter = sFirstName != null ? | |
5009 | + new ObjectParameter("sFirstName", sFirstName) : | |
5010 | + new ObjectParameter("sFirstName", typeof(string)); | |
5011 | + | |
5012 | + var sLastNameParameter = sLastName != null ? | |
5013 | + new ObjectParameter("sLastName", sLastName) : | |
5014 | + new ObjectParameter("sLastName", typeof(string)); | |
5015 | + | |
5016 | + var sEmailIdParameter = sEmailId != null ? | |
5017 | + new ObjectParameter("sEmailId", sEmailId) : | |
5018 | + new ObjectParameter("sEmailId", typeof(string)); | |
5019 | + | |
5020 | + var sAccoutNumberParameter = sAccoutNumber != null ? | |
5021 | + new ObjectParameter("sAccoutNumber", sAccoutNumber) : | |
5022 | + new ObjectParameter("sAccoutNumber", typeof(string)); | |
5023 | + | |
5024 | + var iUserTypeIdParameter = iUserTypeId.HasValue ? | |
5025 | + new ObjectParameter("iUserTypeId", iUserTypeId) : | |
5026 | + new ObjectParameter("iUserTypeId", typeof(int)); | |
5027 | + | |
5028 | + var iAccountTypeIdParameter = iAccountTypeId.HasValue ? | |
5029 | + new ObjectParameter("iAccountTypeId", iAccountTypeId) : | |
5030 | + new ObjectParameter("iAccountTypeId", typeof(int)); | |
5031 | + | |
5032 | + var iLoginUserTypeParameter = iLoginUserType.HasValue ? | |
5033 | + new ObjectParameter("iLoginUserType", iLoginUserType) : | |
5034 | + new ObjectParameter("iLoginUserType", typeof(int)); | |
5035 | + | |
5036 | + var pageNoParameter = pageNo.HasValue ? | |
5037 | + new ObjectParameter("pageNo", pageNo) : | |
5038 | + new ObjectParameter("pageNo", typeof(int)); | |
5039 | + | |
5040 | + var pageLengthParameter = pageLength.HasValue ? | |
5041 | + new ObjectParameter("pageLength", pageLength) : | |
5042 | + new ObjectParameter("pageLength", typeof(int)); | |
5043 | + | |
5044 | + return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_GetSearchUsers1", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount); | |
5045 | + } | |
5046 | + | |
5047 | + public virtual ObjectResult<usp_GetUserList_Result> usp_GetUserList(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount) | |
5048 | + { | |
5049 | + var sFirstNameParameter = sFirstName != null ? | |
5050 | + new ObjectParameter("sFirstName", sFirstName) : | |
5051 | + new ObjectParameter("sFirstName", typeof(string)); | |
5052 | + | |
5053 | + var sLastNameParameter = sLastName != null ? | |
5054 | + new ObjectParameter("sLastName", sLastName) : | |
5055 | + new ObjectParameter("sLastName", typeof(string)); | |
5056 | + | |
5057 | + var sEmailIdParameter = sEmailId != null ? | |
5058 | + new ObjectParameter("sEmailId", sEmailId) : | |
5059 | + new ObjectParameter("sEmailId", typeof(string)); | |
5060 | + | |
5061 | + var sAccoutNumberParameter = sAccoutNumber != null ? | |
5062 | + new ObjectParameter("sAccoutNumber", sAccoutNumber) : | |
5063 | + new ObjectParameter("sAccoutNumber", typeof(string)); | |
5064 | + | |
5065 | + var iUserTypeIdParameter = iUserTypeId.HasValue ? | |
5066 | + new ObjectParameter("iUserTypeId", iUserTypeId) : | |
5067 | + new ObjectParameter("iUserTypeId", typeof(int)); | |
5068 | + | |
5069 | + var iAccountTypeIdParameter = iAccountTypeId.HasValue ? | |
5070 | + new ObjectParameter("iAccountTypeId", iAccountTypeId) : | |
5071 | + new ObjectParameter("iAccountTypeId", typeof(int)); | |
5072 | + | |
5073 | + var iLoginUserTypeParameter = iLoginUserType.HasValue ? | |
5074 | + new ObjectParameter("iLoginUserType", iLoginUserType) : | |
5075 | + new ObjectParameter("iLoginUserType", typeof(int)); | |
5076 | + | |
5077 | + var pageNoParameter = pageNo.HasValue ? | |
5078 | + new ObjectParameter("pageNo", pageNo) : | |
5079 | + new ObjectParameter("pageNo", typeof(int)); | |
5080 | + | |
5081 | + var pageLengthParameter = pageLength.HasValue ? | |
5082 | + new ObjectParameter("pageLength", pageLength) : | |
5083 | + new ObjectParameter("pageLength", typeof(int)); | |
5084 | + | |
5085 | + return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUserList_Result>("usp_GetUserList", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount); | |
5086 | + } | |
5087 | + | |
5088 | + public virtual ObjectResult<usp_GetUsersList_Result> usp_GetUsersList(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount) | |
5089 | + { | |
5090 | + var sFirstNameParameter = sFirstName != null ? | |
5091 | + new ObjectParameter("sFirstName", sFirstName) : | |
5092 | + new ObjectParameter("sFirstName", typeof(string)); | |
5093 | + | |
5094 | + var sLastNameParameter = sLastName != null ? | |
5095 | + new ObjectParameter("sLastName", sLastName) : | |
5096 | + new ObjectParameter("sLastName", typeof(string)); | |
5097 | + | |
5098 | + var sEmailIdParameter = sEmailId != null ? | |
5099 | + new ObjectParameter("sEmailId", sEmailId) : | |
5100 | + new ObjectParameter("sEmailId", typeof(string)); | |
5101 | + | |
5102 | + var sAccoutNumberParameter = sAccoutNumber != null ? | |
5103 | + new ObjectParameter("sAccoutNumber", sAccoutNumber) : | |
5104 | + new ObjectParameter("sAccoutNumber", typeof(string)); | |
5105 | + | |
5106 | + var iUserTypeIdParameter = iUserTypeId.HasValue ? | |
5107 | + new ObjectParameter("iUserTypeId", iUserTypeId) : | |
5108 | + new ObjectParameter("iUserTypeId", typeof(int)); | |
5109 | + | |
5110 | + var iAccountTypeIdParameter = iAccountTypeId.HasValue ? | |
5111 | + new ObjectParameter("iAccountTypeId", iAccountTypeId) : | |
5112 | + new ObjectParameter("iAccountTypeId", typeof(int)); | |
5113 | + | |
5114 | + var iLoginUserTypeParameter = iLoginUserType.HasValue ? | |
5115 | + new ObjectParameter("iLoginUserType", iLoginUserType) : | |
5116 | + new ObjectParameter("iLoginUserType", typeof(int)); | |
5117 | + | |
5118 | + var pageNoParameter = pageNo.HasValue ? | |
5119 | + new ObjectParameter("pageNo", pageNo) : | |
5120 | + new ObjectParameter("pageNo", typeof(int)); | |
5121 | + | |
5122 | + var pageLengthParameter = pageLength.HasValue ? | |
5123 | + new ObjectParameter("pageLength", pageLength) : | |
5124 | + new ObjectParameter("pageLength", typeof(int)); | |
5125 | + | |
5126 | + return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUsersList_Result>("usp_GetUsersList", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount); | |
5127 | + } | |
4964 | 5128 | } |
4965 | 5129 | } | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AIADBEntity.edmx
... | ... | @@ -2831,7 +2831,7 @@ warning 6002: The table/view 'AIADatabaseV5.dbo.VocabTermNumberToSystemMap' does |
2831 | 2831 | <Function Name="usp_GetProductEditionByLicense" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> |
2832 | 2832 | <Parameter Name="iLicenseId" Type="int" Mode="In" /> |
2833 | 2833 | </Function> |
2834 | - <Function Name="usp_GetSearchUsers" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> | |
2834 | + <Function Name="usp_GetSearchUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> | |
2835 | 2835 | <Parameter Name="sFirstName" Type="varchar" Mode="In" /> |
2836 | 2836 | <Parameter Name="sLastName" Type="varchar" Mode="In" /> |
2837 | 2837 | <Parameter Name="sEmailId" Type="varchar" Mode="In" /> |
... | ... | @@ -2914,6 +2914,30 @@ warning 6002: The table/view 'AIADatabaseV5.dbo.VocabTermNumberToSystemMap' does |
2914 | 2914 | <Parameter Name="pageLength" Type="int" Mode="In" /> |
2915 | 2915 | <Parameter Name="recordCount" Type="int" Mode="InOut" /> |
2916 | 2916 | </Function> |
2917 | + <Function Name="usp_GetUserList" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> | |
2918 | + <Parameter Name="sFirstName" Type="varchar" Mode="In" /> | |
2919 | + <Parameter Name="sLastName" Type="varchar" Mode="In" /> | |
2920 | + <Parameter Name="sEmailId" Type="varchar" Mode="In" /> | |
2921 | + <Parameter Name="sAccoutNumber" Type="varchar" Mode="In" /> | |
2922 | + <Parameter Name="iUserTypeId" Type="int" Mode="In" /> | |
2923 | + <Parameter Name="iAccountTypeId" Type="int" Mode="In" /> | |
2924 | + <Parameter Name="iLoginUserType" Type="int" Mode="In" /> | |
2925 | + <Parameter Name="pageNo" Type="int" Mode="In" /> | |
2926 | + <Parameter Name="pageLength" Type="int" Mode="In" /> | |
2927 | + <Parameter Name="recordCount" Type="int" Mode="InOut" /> | |
2928 | + </Function> | |
2929 | + <Function Name="usp_GetUsersList" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> | |
2930 | + <Parameter Name="sFirstName" Type="varchar" Mode="In" /> | |
2931 | + <Parameter Name="sLastName" Type="varchar" Mode="In" /> | |
2932 | + <Parameter Name="sEmailId" Type="varchar" Mode="In" /> | |
2933 | + <Parameter Name="sAccoutNumber" Type="varchar" Mode="In" /> | |
2934 | + <Parameter Name="iUserTypeId" Type="int" Mode="In" /> | |
2935 | + <Parameter Name="iAccountTypeId" Type="int" Mode="In" /> | |
2936 | + <Parameter Name="iLoginUserType" Type="int" Mode="In" /> | |
2937 | + <Parameter Name="pageNo" Type="int" Mode="In" /> | |
2938 | + <Parameter Name="pageLength" Type="int" Mode="In" /> | |
2939 | + <Parameter Name="recordCount" Type="int" Mode="InOut" /> | |
2940 | + </Function> | |
2917 | 2941 | <Function Name="usp_GetUserTyeByAccountNumber" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> |
2918 | 2942 | <Parameter Name="iUserTypeId" Type="tinyint" Mode="In" /> |
2919 | 2943 | <Parameter Name="iLicenseId" Type="int" Mode="In" /> |
... | ... | @@ -3083,7 +3107,7 @@ warning 6002: The table/view 'AIADatabaseV5.dbo.VocabTermNumberToSystemMap' does |
3083 | 3107 | <Parameter Name="sSiteIPTo" Type="varchar" Mode="In" /> |
3084 | 3108 | <Parameter Name="LicenseId" Type="int" Mode="In" /> |
3085 | 3109 | <Parameter Name="SiteEditionIds" Type="varchar" Mode="In" /> |
3086 | - <Parameter Name="Status" Type="bit" Mode="InOut" /> | |
3110 | + <Parameter Name="Status" Type="int" Mode="InOut" /> | |
3087 | 3111 | </Function> |
3088 | 3112 | <Function Name="usp_UpdateAIAUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> |
3089 | 3113 | <Parameter Name="sLoginId" Type="varchar" Mode="In" /> |
... | ... | @@ -6787,7 +6811,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
6787 | 6811 | <Parameter Name="sSiteIPTo" Mode="In" Type="String" /> |
6788 | 6812 | <Parameter Name="LicenseId" Mode="In" Type="Int32" /> |
6789 | 6813 | <Parameter Name="SiteEditionIds" Mode="In" Type="String" /> |
6790 | - <Parameter Name="Status" Mode="InOut" Type="Boolean" /> | |
6814 | + <Parameter Name="Status" Mode="InOut" Type="Int32" /> | |
6791 | 6815 | </FunctionImport> |
6792 | 6816 | <FunctionImport Name="usp_UpdateLicenseBasicSettings"> |
6793 | 6817 | <Parameter Name="iLicenseId" Mode="In" Type="Int32" /> |
... | ... | @@ -7239,6 +7263,54 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
7239 | 7263 | <Parameter Name="iUserTypeId" Mode="In" Type="Byte" /> |
7240 | 7264 | <Parameter Name="iLicenseId" Mode="In" Type="Int32" /> |
7241 | 7265 | </FunctionImport> |
7266 | + <FunctionImport Name="usp_GetSearchUser" ReturnType="Collection(String)"> | |
7267 | + <Parameter Name="sFirstName" Mode="In" Type="String" /> | |
7268 | + <Parameter Name="sLastName" Mode="In" Type="String" /> | |
7269 | + <Parameter Name="sEmailId" Mode="In" Type="String" /> | |
7270 | + <Parameter Name="sAccoutNumber" Mode="In" Type="String" /> | |
7271 | + <Parameter Name="iUserTypeId" Mode="In" Type="Int32" /> | |
7272 | + <Parameter Name="iAccountTypeId" Mode="In" Type="Int32" /> | |
7273 | + <Parameter Name="iLoginUserType" Mode="In" Type="Int32" /> | |
7274 | + <Parameter Name="pageNo" Mode="In" Type="Int32" /> | |
7275 | + <Parameter Name="pageLength" Mode="In" Type="Int32" /> | |
7276 | + <Parameter Name="recordCount" Mode="InOut" Type="Int32" /> | |
7277 | + </FunctionImport> | |
7278 | + <FunctionImport Name="usp_GetSearchUsers1" ReturnType="Collection(String)"> | |
7279 | + <Parameter Name="sFirstName" Mode="In" Type="String" /> | |
7280 | + <Parameter Name="sLastName" Mode="In" Type="String" /> | |
7281 | + <Parameter Name="sEmailId" Mode="In" Type="String" /> | |
7282 | + <Parameter Name="sAccoutNumber" Mode="In" Type="String" /> | |
7283 | + <Parameter Name="iUserTypeId" Mode="In" Type="Int32" /> | |
7284 | + <Parameter Name="iAccountTypeId" Mode="In" Type="Int32" /> | |
7285 | + <Parameter Name="iLoginUserType" Mode="In" Type="Int32" /> | |
7286 | + <Parameter Name="pageNo" Mode="In" Type="Int32" /> | |
7287 | + <Parameter Name="pageLength" Mode="In" Type="Int32" /> | |
7288 | + <Parameter Name="recordCount" Mode="InOut" Type="Int32" /> | |
7289 | + </FunctionImport> | |
7290 | + <FunctionImport Name="usp_GetUserList" ReturnType="Collection(AIADatabaseV5Model.usp_GetUserList_Result)"> | |
7291 | + <Parameter Name="sFirstName" Mode="In" Type="String" /> | |
7292 | + <Parameter Name="sLastName" Mode="In" Type="String" /> | |
7293 | + <Parameter Name="sEmailId" Mode="In" Type="String" /> | |
7294 | + <Parameter Name="sAccoutNumber" Mode="In" Type="String" /> | |
7295 | + <Parameter Name="iUserTypeId" Mode="In" Type="Int32" /> | |
7296 | + <Parameter Name="iAccountTypeId" Mode="In" Type="Int32" /> | |
7297 | + <Parameter Name="iLoginUserType" Mode="In" Type="Int32" /> | |
7298 | + <Parameter Name="pageNo" Mode="In" Type="Int32" /> | |
7299 | + <Parameter Name="pageLength" Mode="In" Type="Int32" /> | |
7300 | + <Parameter Name="recordCount" Mode="InOut" Type="Int32" /> | |
7301 | + </FunctionImport> | |
7302 | + <FunctionImport Name="usp_GetUsersList" ReturnType="Collection(AIADatabaseV5Model.usp_GetUsersList_Result)"> | |
7303 | + <Parameter Name="sFirstName" Mode="In" Type="String" /> | |
7304 | + <Parameter Name="sLastName" Mode="In" Type="String" /> | |
7305 | + <Parameter Name="sEmailId" Mode="In" Type="String" /> | |
7306 | + <Parameter Name="sAccoutNumber" Mode="In" Type="String" /> | |
7307 | + <Parameter Name="iUserTypeId" Mode="In" Type="Int32" /> | |
7308 | + <Parameter Name="iAccountTypeId" Mode="In" Type="Int32" /> | |
7309 | + <Parameter Name="iLoginUserType" Mode="In" Type="Int32" /> | |
7310 | + <Parameter Name="pageNo" Mode="In" Type="Int32" /> | |
7311 | + <Parameter Name="pageLength" Mode="In" Type="Int32" /> | |
7312 | + <Parameter Name="recordCount" Mode="InOut" Type="Int32" /> | |
7313 | + </FunctionImport> | |
7242 | 7314 | </EntityContainer> |
7243 | 7315 | <ComplexType Name="DA_GetBaseLayer_Result"> |
7244 | 7316 | <Property Type="Int32" Name="Id" Nullable="false" /> |
... | ... | @@ -8333,7 +8405,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8333 | 8405 | <Property Type="String" Name="Title" Nullable="false" MaxLength="100" /> |
8334 | 8406 | </ComplexType> |
8335 | 8407 | <ComplexType Name="usp_GetCancelledLicenses_Result"> |
8336 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8337 | 8408 | <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> |
8338 | 8409 | <Property Type="String" Name="LicenseeName" Nullable="true" MaxLength="100" /> |
8339 | 8410 | <Property Type="String" Name="LicenseType" Nullable="true" MaxLength="50" /> |
... | ... | @@ -8345,9 +8416,9 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8345 | 8416 | <Property Type="String" Name="LicenseCreationDate" Nullable="true" MaxLength="30" /> |
8346 | 8417 | <Property Type="Decimal" Name="SubscriptionPrice" Nullable="true" Precision="14" Scale="2" /> |
8347 | 8418 | <Property Type="Int32" Name="CardNumber" Nullable="true" /> |
8419 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8348 | 8420 | </ComplexType> |
8349 | 8421 | <ComplexType Name="usp_GetCustomerSummary_Result"> |
8350 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8351 | 8422 | <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> |
8352 | 8423 | <Property Type="String" Name="LicenseeName" Nullable="true" MaxLength="100" /> |
8353 | 8424 | <Property Type="String" Name="LicenseType" Nullable="true" MaxLength="50" /> |
... | ... | @@ -8363,7 +8434,8 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8363 | 8434 | <Property Type="String" Name="LicenseCountry" Nullable="true" MaxLength="50" /> |
8364 | 8435 | <Property Type="String" Name="InstitutionName" Nullable="true" MaxLength="100" /> |
8365 | 8436 | <Property Type="String" Name="LicenseCreationDate" Nullable="true" MaxLength="30" /> |
8366 | - <Property Type="Int32" Name="CardNumber" Nullable="true" /> | |
8437 | + <Property Type="Int32" Name="CardNumber" Nullable="false" /> | |
8438 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8367 | 8439 | </ComplexType> |
8368 | 8440 | <ComplexType Name="usp_GetDiscountReport_Result"> |
8369 | 8441 | <Property Type="Int64" Name="RowNum" Nullable="true" /> |
... | ... | @@ -8375,7 +8447,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8375 | 8447 | <Property Type="Int32" Name="TotalLicenses" Nullable="true" /> |
8376 | 8448 | </ComplexType> |
8377 | 8449 | <ComplexType Name="usp_GetExpiringLicenses_Result"> |
8378 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8379 | 8450 | <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> |
8380 | 8451 | <Property Type="String" Name="LicenseeName" Nullable="true" MaxLength="100" /> |
8381 | 8452 | <Property Type="String" Name="LicenseType" Nullable="true" MaxLength="50" /> |
... | ... | @@ -8388,22 +8459,22 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8388 | 8459 | <Property Type="String" Name="AccountType" Nullable="true" MaxLength="50" /> |
8389 | 8460 | <Property Type="Int32" Name="DaysRemaining" Nullable="true" /> |
8390 | 8461 | <Property Type="Int32" Name="CardNumber" Nullable="true" /> |
8462 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8391 | 8463 | </ComplexType> |
8392 | 8464 | <ComplexType Name="usp_GetExportedImageDetails_Result"> |
8393 | 8465 | <Property Type="Int64" Name="RowNum" Nullable="true" /> |
8394 | 8466 | <Property Type="Int32" Name="LicenseId" Nullable="false" /> |
8395 | - <Property Type="DateTime" Name="ExportedDate" Nullable="false" Precision="23" /> | |
8467 | + <Property Type="String" Name="ExportedDate" Nullable="true" MaxLength="30" /> | |
8396 | 8468 | <Property Type="String" Name="ImageName" Nullable="false" MaxLength="2000" /> |
8397 | - <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="16" /> | |
8469 | + <Property Type="String" Name="AccountNumber" Nullable="false" MaxLength="16" /> | |
8398 | 8470 | <Property Type="String" Name="OriginalFileName" Nullable="true" MaxLength="1000" /> |
8399 | 8471 | <Property Type="String" Name="Title" Nullable="true" MaxLength="1000" /> |
8400 | 8472 | <Property Type="String" Name="ModuleName" Nullable="true" MaxLength="1000" /> |
8401 | - <Property Type="Int32" Name="ExportLimit" Nullable="true" /> | |
8473 | + <Property Type="Int32" Name="ExportLimit" Nullable="false" /> | |
8402 | 8474 | <Property Type="String" Name="UserName" Nullable="true" MaxLength="201" /> |
8403 | 8475 | <Property Type="Int32" Name="imageCount" Nullable="true" /> |
8404 | 8476 | </ComplexType> |
8405 | 8477 | <ComplexType Name="usp_GetNetAdSummaryReport_Result"> |
8406 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8407 | 8478 | <Property Type="String" Name="LicenseType" Nullable="true" MaxLength="50" /> |
8408 | 8479 | <Property Type="String" Name="AccountType" Nullable="true" MaxLength="50" /> |
8409 | 8480 | <Property Type="String" Name="InstitutionName" Nullable="true" MaxLength="100" /> |
... | ... | @@ -8412,6 +8483,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8412 | 8483 | <Property Type="Int32" Name="RenewSubscription" Nullable="true" /> |
8413 | 8484 | <Property Type="Int32" Name="InActiveSubscription" Nullable="true" /> |
8414 | 8485 | <Property Type="Int32" Name="NetAdSubscription" Nullable="true" /> |
8486 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8415 | 8487 | </ComplexType> |
8416 | 8488 | <ComplexType Name="usp_GetSiteLicenseUsageReport_Result"> |
8417 | 8489 | <Property Type="Int64" Name="RowNum" Nullable="true" /> |
... | ... | @@ -8424,12 +8496,11 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8424 | 8496 | <Property Type="String" Name="LastLogin" Nullable="true" MaxLength="30" /> |
8425 | 8497 | </ComplexType> |
8426 | 8498 | <ComplexType Name="usp_GetUsageReport_Result"> |
8427 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8428 | 8499 | <Property Type="String" Name="LoginId" Nullable="true" MaxLength="50" /> |
8429 | 8500 | <Property Type="String" Name="FirstName" Nullable="true" MaxLength="100" /> |
8430 | 8501 | <Property Type="String" Name="LastName" Nullable="true" MaxLength="100" /> |
8431 | - <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> | |
8432 | - <Property Type="Int32" Name="CardNumber" Nullable="true" /> | |
8502 | + <Property Type="String" Name="AccountNumber" Nullable="false" MaxLength="50" /> | |
8503 | + <Property Type="Int32" Name="CardNumber" Nullable="false" /> | |
8433 | 8504 | <Property Type="String" Name="UserType" Nullable="true" MaxLength="50" /> |
8434 | 8505 | <Property Type="String" Name="LicenseCreationDate" Nullable="true" MaxLength="30" /> |
8435 | 8506 | <Property Type="String" Name="LicenseZip" Nullable="true" MaxLength="20" /> |
... | ... | @@ -8438,27 +8509,12 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8438 | 8509 | <Property Type="String" Name="InstitutionName" Nullable="true" MaxLength="100" /> |
8439 | 8510 | <Property Type="Int32" Name="TotalLogins" Nullable="true" /> |
8440 | 8511 | <Property Type="String" Name="LastLogin" Nullable="true" MaxLength="30" /> |
8512 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8441 | 8513 | </ComplexType> |
8442 | 8514 | <ComplexType Name="usp_GetSearchUsers_Result"> |
8443 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8444 | - <Property Type="Int32" Name="Id" Nullable="true" /> | |
8445 | - <Property Type="String" Name="FirstName" Nullable="true" MaxLength="100" /> | |
8446 | - <Property Type="String" Name="LastName" Nullable="true" MaxLength="100" /> | |
8447 | - <Property Type="String" Name="LoginId" Nullable="true" MaxLength="50" /> | |
8448 | - <Property Type="String" Name="EmailId" Nullable="true" MaxLength="50" /> | |
8449 | - <Property Type="String" Name="UserTypeTitle" Nullable="true" MaxLength="50" /> | |
8450 | - <Property Type="String" Name="Password" Nullable="true" MaxLength="50" /> | |
8451 | - <Property Type="DateTime" Name="CreationDate" Nullable="true" Precision="23" /> | |
8452 | - <Property Type="DateTime" Name="ModifiedDate" Nullable="true" Precision="23" /> | |
8453 | - <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> | |
8454 | - <Property Type="String" Name="AccountTypeTitle" Nullable="true" MaxLength="50" /> | |
8455 | - <Property Type="String" Name="EditionType" Nullable="true" MaxLength="50" /> | |
8456 | - <Property Type="String" Name="UserStatus" Nullable="true" MaxLength="8" /> | |
8457 | - <Property Type="Int32" Name="UserTypeId" Nullable="true" /> | |
8458 | - <Property Type="Int32" Name="EditionTypeId" Nullable="true" /> | |
8515 | + <Property Type="String" Name="Column1" Nullable="true" MaxLength="50" /> | |
8459 | 8516 | </ComplexType> |
8460 | 8517 | <ComplexType Name="usp_GetSiteLicenseUsageReports_Result"> |
8461 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8462 | 8518 | <Property Type="String" Name="AccountNumber" Nullable="false" MaxLength="50" /> |
8463 | 8519 | <Property Type="String" Name="EditionTitle" Nullable="false" MaxLength="50" /> |
8464 | 8520 | <Property Type="String" Name="ReferalUrl" Nullable="true" MaxLength="100" /> |
... | ... | @@ -8466,13 +8522,13 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8466 | 8522 | <Property Type="String" Name="LicenseCreationDate" Nullable="true" MaxLength="30" /> |
8467 | 8523 | <Property Type="Int32" Name="TotalLogins" Nullable="true" /> |
8468 | 8524 | <Property Type="String" Name="LastLogin" Nullable="true" MaxLength="30" /> |
8525 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8469 | 8526 | </ComplexType> |
8470 | 8527 | <ComplexType Name="usp_GetUserTyeByAccountNumber_Result"> |
8471 | 8528 | <Property Type="Byte" Name="Id" Nullable="true" /> |
8472 | 8529 | <Property Type="String" Name="Title" Nullable="true" MaxLength="50" /> |
8473 | 8530 | </ComplexType> |
8474 | 8531 | <ComplexType Name="usp_GetSubscribedLicenses_Result"> |
8475 | - <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8476 | 8532 | <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> |
8477 | 8533 | <Property Type="String" Name="LicenseeName" Nullable="true" MaxLength="100" /> |
8478 | 8534 | <Property Type="String" Name="LicenseType" Nullable="true" MaxLength="50" /> |
... | ... | @@ -8483,7 +8539,8 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8483 | 8539 | <Property Type="String" Name="EndDate" Nullable="true" MaxLength="30" /> |
8484 | 8540 | <Property Type="String" Name="LicenseCreationDate" Nullable="true" MaxLength="30" /> |
8485 | 8541 | <Property Type="Decimal" Name="SubscriptionPrice" Nullable="true" Precision="14" Scale="2" /> |
8486 | - <Property Type="Int32" Name="CardNumber" Nullable="true" /> | |
8542 | + <Property Type="Int32" Name="CardNumber" Nullable="false" /> | |
8543 | + <Property Type="Int64" Name="Serial_No" Nullable="true" /> | |
8487 | 8544 | </ComplexType> |
8488 | 8545 | <ComplexType Name="usp_GetBlockedUserByAccNoAndType_Result"> |
8489 | 8546 | <Property Type="Int32" Name="Id" Nullable="false" /> |
... | ... | @@ -8495,6 +8552,27 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
8495 | 8552 | <Property Type="String" Name="AccountNumber" Nullable="false" MaxLength="16" /> |
8496 | 8553 | <Property Type="DateTime" Name="LoginTime" Nullable="true" Precision="23" /> |
8497 | 8554 | </ComplexType> |
8555 | + <ComplexType Name="usp_GetUserList_Result"> | |
8556 | + <Property Type="String" Name="Column1" Nullable="true" MaxLength="50" /> | |
8557 | + </ComplexType> | |
8558 | + <ComplexType Name="usp_GetUsersList_Result"> | |
8559 | + <Property Type="Int64" Name="RowNum" Nullable="true" /> | |
8560 | + <Property Type="Int32" Name="Id" Nullable="true" /> | |
8561 | + <Property Type="String" Name="FirstName" Nullable="true" MaxLength="100" /> | |
8562 | + <Property Type="String" Name="LastName" Nullable="true" MaxLength="100" /> | |
8563 | + <Property Type="String" Name="LoginId" Nullable="true" MaxLength="50" /> | |
8564 | + <Property Type="String" Name="EmailId" Nullable="true" MaxLength="50" /> | |
8565 | + <Property Type="String" Name="UserTypeTitle" Nullable="true" MaxLength="50" /> | |
8566 | + <Property Type="String" Name="Password" Nullable="true" MaxLength="50" /> | |
8567 | + <Property Type="DateTime" Name="CreationDate" Nullable="true" Precision="23" /> | |
8568 | + <Property Type="DateTime" Name="ModifiedDate" Nullable="true" Precision="23" /> | |
8569 | + <Property Type="String" Name="AccountNumber" Nullable="true" MaxLength="50" /> | |
8570 | + <Property Type="String" Name="AccountTypeTitle" Nullable="true" MaxLength="50" /> | |
8571 | + <Property Type="String" Name="EditionType" Nullable="true" MaxLength="50" /> | |
8572 | + <Property Type="String" Name="UserStatus" Nullable="true" MaxLength="8" /> | |
8573 | + <Property Type="Int32" Name="UserTypeId" Nullable="true" /> | |
8574 | + <Property Type="Int32" Name="EditionTypeId" Nullable="true" /> | |
8575 | + </ComplexType> | |
8498 | 8576 | </Schema> |
8499 | 8577 | </edmx:ConceptualModels> |
8500 | 8578 | <!-- C-S mapping content --> |
... | ... | @@ -11170,7 +11248,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11170 | 11248 | <FunctionImportMapping FunctionImportName="usp_GetCancelledLicenses" FunctionName="AIADatabaseV5Model.Store.usp_GetCancelledLicenses"> |
11171 | 11249 | <ResultMapping> |
11172 | 11250 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetCancelledLicenses_Result"> |
11173 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11174 | 11251 | <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> |
11175 | 11252 | <ScalarProperty Name="LicenseeName" ColumnName="LicenseeName" /> |
11176 | 11253 | <ScalarProperty Name="LicenseType" ColumnName="LicenseType" /> |
... | ... | @@ -11182,13 +11259,13 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11182 | 11259 | <ScalarProperty Name="LicenseCreationDate" ColumnName="LicenseCreationDate" /> |
11183 | 11260 | <ScalarProperty Name="SubscriptionPrice" ColumnName="SubscriptionPrice" /> |
11184 | 11261 | <ScalarProperty Name="CardNumber" ColumnName="CardNumber" /> |
11262 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11185 | 11263 | </ComplexTypeMapping> |
11186 | 11264 | </ResultMapping> |
11187 | 11265 | </FunctionImportMapping> |
11188 | 11266 | <FunctionImportMapping FunctionImportName="usp_GetCustomerSummary" FunctionName="AIADatabaseV5Model.Store.usp_GetCustomerSummary"> |
11189 | 11267 | <ResultMapping> |
11190 | 11268 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetCustomerSummary_Result"> |
11191 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11192 | 11269 | <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> |
11193 | 11270 | <ScalarProperty Name="LicenseeName" ColumnName="LicenseeName" /> |
11194 | 11271 | <ScalarProperty Name="LicenseType" ColumnName="LicenseType" /> |
... | ... | @@ -11205,6 +11282,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11205 | 11282 | <ScalarProperty Name="InstitutionName" ColumnName="InstitutionName" /> |
11206 | 11283 | <ScalarProperty Name="LicenseCreationDate" ColumnName="LicenseCreationDate" /> |
11207 | 11284 | <ScalarProperty Name="CardNumber" ColumnName="CardNumber" /> |
11285 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11208 | 11286 | </ComplexTypeMapping> |
11209 | 11287 | </ResultMapping> |
11210 | 11288 | </FunctionImportMapping> |
... | ... | @@ -11224,7 +11302,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11224 | 11302 | <FunctionImportMapping FunctionImportName="usp_GetExpiringLicenses" FunctionName="AIADatabaseV5Model.Store.usp_GetExpiringLicenses"> |
11225 | 11303 | <ResultMapping> |
11226 | 11304 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetExpiringLicenses_Result"> |
11227 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11228 | 11305 | <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> |
11229 | 11306 | <ScalarProperty Name="LicenseeName" ColumnName="LicenseeName" /> |
11230 | 11307 | <ScalarProperty Name="LicenseType" ColumnName="LicenseType" /> |
... | ... | @@ -11237,6 +11314,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11237 | 11314 | <ScalarProperty Name="AccountType" ColumnName="AccountType" /> |
11238 | 11315 | <ScalarProperty Name="DaysRemaining" ColumnName="DaysRemaining" /> |
11239 | 11316 | <ScalarProperty Name="CardNumber" ColumnName="CardNumber" /> |
11317 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11240 | 11318 | </ComplexTypeMapping> |
11241 | 11319 | </ResultMapping> |
11242 | 11320 | </FunctionImportMapping> |
... | ... | @@ -11260,7 +11338,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11260 | 11338 | <FunctionImportMapping FunctionImportName="usp_GetNetAdSummaryReport" FunctionName="AIADatabaseV5Model.Store.usp_GetNetAdSummaryReport"> |
11261 | 11339 | <ResultMapping> |
11262 | 11340 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetNetAdSummaryReport_Result"> |
11263 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11264 | 11341 | <ScalarProperty Name="LicenseType" ColumnName="LicenseType" /> |
11265 | 11342 | <ScalarProperty Name="AccountType" ColumnName="AccountType" /> |
11266 | 11343 | <ScalarProperty Name="InstitutionName" ColumnName="InstitutionName" /> |
... | ... | @@ -11269,6 +11346,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11269 | 11346 | <ScalarProperty Name="RenewSubscription" ColumnName="RenewSubscription" /> |
11270 | 11347 | <ScalarProperty Name="InActiveSubscription" ColumnName="InActiveSubscription" /> |
11271 | 11348 | <ScalarProperty Name="NetAdSubscription" ColumnName="NetAdSubscription" /> |
11349 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11272 | 11350 | </ComplexTypeMapping> |
11273 | 11351 | </ResultMapping> |
11274 | 11352 | </FunctionImportMapping> |
... | ... | @@ -11289,7 +11367,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11289 | 11367 | <FunctionImportMapping FunctionImportName="usp_GetUsageReport" FunctionName="AIADatabaseV5Model.Store.usp_GetUsageReport"> |
11290 | 11368 | <ResultMapping> |
11291 | 11369 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetUsageReport_Result"> |
11292 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11293 | 11370 | <ScalarProperty Name="LoginId" ColumnName="LoginId" /> |
11294 | 11371 | <ScalarProperty Name="FirstName" ColumnName="FirstName" /> |
11295 | 11372 | <ScalarProperty Name="LastName" ColumnName="LastName" /> |
... | ... | @@ -11303,35 +11380,13 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11303 | 11380 | <ScalarProperty Name="InstitutionName" ColumnName="InstitutionName" /> |
11304 | 11381 | <ScalarProperty Name="TotalLogins" ColumnName="TotalLogins" /> |
11305 | 11382 | <ScalarProperty Name="LastLogin" ColumnName="LastLogin" /> |
11306 | - </ComplexTypeMapping> | |
11307 | - </ResultMapping> | |
11308 | - </FunctionImportMapping> | |
11309 | - <FunctionImportMapping FunctionImportName="usp_GetSearchUsers" FunctionName="AIADatabaseV5Model.Store.usp_GetSearchUsers"> | |
11310 | - <ResultMapping> | |
11311 | - <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetSearchUsers_Result"> | |
11312 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11313 | - <ScalarProperty Name="Id" ColumnName="Id" /> | |
11314 | - <ScalarProperty Name="FirstName" ColumnName="FirstName" /> | |
11315 | - <ScalarProperty Name="LastName" ColumnName="LastName" /> | |
11316 | - <ScalarProperty Name="LoginId" ColumnName="LoginId" /> | |
11317 | - <ScalarProperty Name="EmailId" ColumnName="EmailId" /> | |
11318 | - <ScalarProperty Name="UserTypeTitle" ColumnName="UserTypeTitle" /> | |
11319 | - <ScalarProperty Name="Password" ColumnName="Password" /> | |
11320 | - <ScalarProperty Name="CreationDate" ColumnName="CreationDate" /> | |
11321 | - <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" /> | |
11322 | - <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> | |
11323 | - <ScalarProperty Name="AccountTypeTitle" ColumnName="AccountTypeTitle" /> | |
11324 | - <ScalarProperty Name="EditionType" ColumnName="EditionType" /> | |
11325 | - <ScalarProperty Name="UserStatus" ColumnName="UserStatus" /> | |
11326 | - <ScalarProperty Name="UserTypeId" ColumnName="UserTypeId" /> | |
11327 | - <ScalarProperty Name="EditionTypeId" ColumnName="EditionTypeId" /> | |
11383 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11328 | 11384 | </ComplexTypeMapping> |
11329 | 11385 | </ResultMapping> |
11330 | 11386 | </FunctionImportMapping> |
11331 | 11387 | <FunctionImportMapping FunctionImportName="usp_GetSiteLicenseUsageReports" FunctionName="AIADatabaseV5Model.Store.usp_GetSiteLicenseUsageReports"> |
11332 | 11388 | <ResultMapping> |
11333 | 11389 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetSiteLicenseUsageReports_Result"> |
11334 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11335 | 11390 | <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> |
11336 | 11391 | <ScalarProperty Name="EditionTitle" ColumnName="EditionTitle" /> |
11337 | 11392 | <ScalarProperty Name="ReferalUrl" ColumnName="ReferalUrl" /> |
... | ... | @@ -11339,6 +11394,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11339 | 11394 | <ScalarProperty Name="LicenseCreationDate" ColumnName="LicenseCreationDate" /> |
11340 | 11395 | <ScalarProperty Name="TotalLogins" ColumnName="TotalLogins" /> |
11341 | 11396 | <ScalarProperty Name="LastLogin" ColumnName="LastLogin" /> |
11397 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11342 | 11398 | </ComplexTypeMapping> |
11343 | 11399 | </ResultMapping> |
11344 | 11400 | </FunctionImportMapping> |
... | ... | @@ -11353,7 +11409,6 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11353 | 11409 | <FunctionImportMapping FunctionImportName="usp_GetSubscribedLicenses" FunctionName="AIADatabaseV5Model.Store.usp_GetSubscribedLicenses"> |
11354 | 11410 | <ResultMapping> |
11355 | 11411 | <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetSubscribedLicenses_Result"> |
11356 | - <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11357 | 11412 | <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> |
11358 | 11413 | <ScalarProperty Name="LicenseeName" ColumnName="LicenseeName" /> |
11359 | 11414 | <ScalarProperty Name="LicenseType" ColumnName="LicenseType" /> |
... | ... | @@ -11365,6 +11420,7 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11365 | 11420 | <ScalarProperty Name="LicenseCreationDate" ColumnName="LicenseCreationDate" /> |
11366 | 11421 | <ScalarProperty Name="SubscriptionPrice" ColumnName="SubscriptionPrice" /> |
11367 | 11422 | <ScalarProperty Name="CardNumber" ColumnName="CardNumber" /> |
11423 | + <ScalarProperty Name="Serial_No" ColumnName="Serial_No" /> | |
11368 | 11424 | </ComplexTypeMapping> |
11369 | 11425 | </ResultMapping> |
11370 | 11426 | </FunctionImportMapping> |
... | ... | @@ -11382,6 +11438,36 @@ FROM [dbo].[VocabTermNumberToSystemMap] AS [VocabTermNumberToSystemMap]</Definin |
11382 | 11438 | </ComplexTypeMapping> |
11383 | 11439 | </ResultMapping> |
11384 | 11440 | </FunctionImportMapping> |
11441 | + <FunctionImportMapping FunctionImportName="usp_GetSearchUser" FunctionName="AIADatabaseV5Model.Store.usp_GetSearchUser" /> | |
11442 | + <FunctionImportMapping FunctionImportName="usp_GetUserList" FunctionName="AIADatabaseV5Model.Store.usp_GetUserList" > | |
11443 | + <ResultMapping> | |
11444 | + <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetUserList_Result"> | |
11445 | + <ScalarProperty Name="Column1" ColumnName="Column1" /> | |
11446 | + </ComplexTypeMapping> | |
11447 | + </ResultMapping> | |
11448 | + </FunctionImportMapping> | |
11449 | + <FunctionImportMapping FunctionImportName="usp_GetUsersList" FunctionName="AIADatabaseV5Model.Store.usp_GetUsersList"> | |
11450 | + <ResultMapping> | |
11451 | + <ComplexTypeMapping TypeName="AIADatabaseV5Model.usp_GetUsersList_Result"> | |
11452 | + <ScalarProperty Name="RowNum" ColumnName="RowNum" /> | |
11453 | + <ScalarProperty Name="Id" ColumnName="Id" /> | |
11454 | + <ScalarProperty Name="FirstName" ColumnName="FirstName" /> | |
11455 | + <ScalarProperty Name="LastName" ColumnName="LastName" /> | |
11456 | + <ScalarProperty Name="LoginId" ColumnName="LoginId" /> | |
11457 | + <ScalarProperty Name="EmailId" ColumnName="EmailId" /> | |
11458 | + <ScalarProperty Name="UserTypeTitle" ColumnName="UserTypeTitle" /> | |
11459 | + <ScalarProperty Name="Password" ColumnName="Password" /> | |
11460 | + <ScalarProperty Name="CreationDate" ColumnName="CreationDate" /> | |
11461 | + <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" /> | |
11462 | + <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" /> | |
11463 | + <ScalarProperty Name="AccountTypeTitle" ColumnName="AccountTypeTitle" /> | |
11464 | + <ScalarProperty Name="EditionType" ColumnName="EditionType" /> | |
11465 | + <ScalarProperty Name="UserStatus" ColumnName="UserStatus" /> | |
11466 | + <ScalarProperty Name="UserTypeId" ColumnName="UserTypeId" /> | |
11467 | + <ScalarProperty Name="EditionTypeId" ColumnName="EditionTypeId" /> | |
11468 | + </ComplexTypeMapping> | |
11469 | + </ResultMapping> | |
11470 | + </FunctionImportMapping> | |
11385 | 11471 | </EntityContainerMapping> |
11386 | 11472 | </Mapping> |
11387 | 11473 | </edmx:Mappings> | ... | ... |
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AIARequired.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AIAUser.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AIAUserActivity.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AccountType.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/Activity.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AdamImageContent.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AnnotationPin.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/AtlasOrientImage.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/CAMMetadata.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/CAMWeightage.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/Content.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentAttribute.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentAttributeType.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentDescriptor.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentDescriptorToPhraseMap.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentMimeType.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentType.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/ContentTypeToAttributeTypeMap.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/Country.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/CourseConduct.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetBaseLayer_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetBitmask_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetBodyRegionView_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetBodyRegion_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetDissectibleContent_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetLayerModel_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetNavigatorModel_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetOverLayLayerList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetPLRModel_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetPolygonForId_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetStructureGroupId_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetTermList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetViewOrientation_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DA_GetVocabTermModal_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/Discount.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DiscountToLicense.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleBitmask.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleBodyView.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleBodyViewBackgroundArt.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleContent.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleLayer.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleNavigatorImage.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectiblePolygon.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectiblePolygonVertice.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleRegion.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleRegionLayerArt.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleRegionLayerBaseMapArt.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleRegionLayerMapping.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleRegionView.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleStructure.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/DissectibleStructureGroup.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetAccountTypeList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetCountryList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetCourseConductedList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetInstitutionList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetInternetProductList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetMultimediaProductList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetProductRequiredList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetReferList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetSecurityQuestionList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetStateList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetSubscriptionPlanInfo_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EC_GetSubscriptionPlan_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/Edition.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EditionToProductFeature.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EditionToSubscriptionPlan.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EncyclopediaMetadata.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/EncyclopediaWeightage.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAIALicenseDetails_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAccountModule_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAllEditionForLicense_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAllLoginFailureCauses_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAllModuleStatusWithSlug_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAllModuleStatus_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAllUserWithGroup_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetAttributeTypeList_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetBlockedUserByAccNoAndType_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetBlockedUserByUserId_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetBlockedUserByUserType_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetCAMSearch_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetCancelledLicenses_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetCustomerSummary_Result.cs
400-SOURCECODE/AIAHTML5.ADMIN.API/Entity/GetDiscountCodeDetails_Result.cs