Users.cs
9.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MongoDB.Driver;
using MongoDB.Bson;
using AIAHTML5.API.Properties;
using AIAHTML5.API.Constants;
using log4net;
using AIAHTML5.API.Models;
using Newtonsoft.Json;
using System.Collections;
namespace AIAHTML5.API.Models
{
public class Users
{
internal static dynamic GetUserDetailsForAuthenticatedUser(Newtonsoft.Json.Linq.JObject credentials)
{
ILog logger = log4net.LogManager.GetLogger((System.Reflection.MethodBase.GetCurrentMethod().DeclaringType));
logger.Debug("inside AuthenticateUser for loginId =" + credentials["username"].ToString() + " and password= " + credentials["password"].ToString());
dynamic userDetails = null;
try
{
//var client = new MongoClient();
//var db = client.GetDatabase(Settings.Default.database);
//var collection = db.GetCollection<dynamic>("Users");
//FilterDefinition<dynamic>[] filterCondition = { Builders<dynamic>.Filter.Eq("loginId", credentials["username"].ToString()),
// Builders<dynamic>.Filter.Eq("password", credentials["password"].ToString())};
//dynamic userDetails = collection.Find(Builders<dynamic>.Filter.And(filterCondition)).SingleOrDefault();
//if (userDetails != null)
//{
// logger.Debug("userDetails.loginId= " + userDetails.loginId);
// return userDetails;
//}
//else
//{
// return AIAConstants.USER_NOT_FOUND;
//}
User user = DBModel.GetUserDetailsByLoginIdAndPassword(credentials["username"].ToString(), credentials["password"].ToString());
//string userDetails = DBModel.GetUserDetailsByLoginId2(credentials["username"].ToString());
if (user != null)
{
logger.Debug("userDetails.loginId= " + user.LoginId); // .loginId);
userDetails = JsonConvert.SerializeObject(user);
}
else
{
userDetails = AIAConstants.USER_NOT_FOUND;
}
}
catch (Exception e)
{
logger.Fatal("Exception in AuthenticateUser for loginId =" + credentials["username"].ToString() + " and password= " + credentials["password"].ToString() + "Exception= " + e.Message + ", STACKTRACE: " + e.StackTrace);
//string errorMessage = AIAConstants.ERROR_IN_FECTHING_DETAILS;
//string error = "Message: " + e.Message + ", STACKTRACE: " + e.StackTrace;
//userDetails = errorMessage;
ArrayList supportMailList = UserUtility.GetSupportMailList();
string mailSubject = "SQL Exception intimation mail";
string mailBody = "MESSAGE: " + e.Message + ", STACKTRACE: " + e.StackTrace;
UserUtility.SendEmail(credentials, supportMailList, "", mailSubject, mailBody);
userDetails = AIAConstants.SQL_CONNECTION_ERROR;
}
return userDetails;
}
internal static dynamic GetUserByEmail(Newtonsoft.Json.Linq.JObject userInfo)
{
ILog logger = log4net.LogManager.GetLogger((System.Reflection.MethodBase.GetCurrentMethod().DeclaringType));
logger.Debug(" inside GetUserByEmail for emailId = " + userInfo["emailId"]);
//var client = new MongoClient();
//try
//{
// var db = client.GetDatabase(Settings.Default.database);
// var collection = db.GetCollection<dynamic>("Users");
// FilterDefinition<dynamic> filterCondition = Builders<dynamic>.Filter.Eq("emailId", userInfo["emailId"].ToString().ToLower());
// dynamic userDetails = collection.Find(Builders<dynamic>.Filter.And(filterCondition)).SingleOrDefault();
// if (userDetails != null)
// {
// logger.Debug("userDetails= " + userDetails.loginId);
// return userDetails;
// }
// else
// {
// logger.Debug("user not found");
// return AIAConstants.USER_NOT_FOUND;
// }
//}
//catch (Exception e)
//{
// logger.Fatal("Exception= " + e.Message+", stacktrace = "+e.StackTrace);
// return AIAConstants.ERROR_IN_FECTHING_DETAILS;
//}
try
{
User objUser = DBModel.GetUserDetailsByEmailId(userInfo["emailId"].ToString());
//dynamic userDetails;
if (objUser != null)
{
logger.Debug("userDetails.loginId= " + objUser.LoginId);
//return userDetails = JsonConvert.SerializeObject(objUser);
return objUser;
}
else
{
return AIAConstants.USER_NOT_FOUND;
}
}
catch (Exception ex)
{
logger.Fatal("Exception in Gettting UserDetailsByEmailId for EmailId =" + userInfo["emailId"].ToString() + " Exception= " + ex.Message + ", STACKTRACE: " + ex.StackTrace);
//string errorMessage = AIAConstants.ERROR_IN_FECTHING_DETAILS;
//return errorMessage;
ArrayList supportMailList = UserUtility.GetSupportMailList();
string mailSubject = "SQL Exception intimation mail";
string mailBody = "MESSAGE: " + ex.Message + ", STACKTRACE: " + ex.StackTrace;
UserUtility.SendEmail(userInfo, supportMailList, "", mailSubject, mailBody);
return AIAConstants.SQL_CONNECTION_ERROR;
}
}
internal static dynamic UpdatePassword(Newtonsoft.Json.Linq.JObject userInfo, string sLoginId, string sEmailId)
{
ILog logger = log4net.LogManager.GetLogger((System.Reflection.MethodBase.GetCurrentMethod().DeclaringType));
//var client = new MongoClient();
try
{
//var db = client.GetDatabase(Settings.Default.database);
//var collection = db.GetCollection<BsonDocument>("Users");
//var filter = Builders<BsonDocument>.Filter.Eq("emailId", userInfo["emailId"].ToString());
//var update = Builders<BsonDocument>.Update.Set("password", userInfo["newPassword"].ToString()).CurrentDate("modifiedDate");
//var result = collection.UpdateOne(filter, update);
int result = DBModel.UpdateUserPassword(userInfo, sLoginId, sEmailId);
if (result > 0)
return result;
else
return AIAConstants.USER_NOT_FOUND;
}
catch (Exception e)
{
logger.Fatal("Exception in UdatePassword with user details = " + userInfo + ", LoginId:" + sLoginId + ", EmailId: "+ sEmailId + "<br/>MESSAGE: " + e.Message + ", STACKTRACE: " + e.StackTrace);
//return AIAConstants.ERROR_IN_FECTHING_DETAILS;
ArrayList supportMailList = UserUtility.GetSupportMailList();
string mailSubject = "SQL Exception intimation mail";
string mailBody = "MESSAGE: " + e.Message + ", STACKTRACE: " + e.StackTrace;
UserUtility.SendEmail(userInfo, supportMailList, "", mailSubject, mailBody);
return AIAConstants.SQL_CONNECTION_ERROR;
}
}
internal static dynamic UpdateLicenseTerm(string accNumber)
{
ILog logger = log4net.LogManager.GetLogger((System.Reflection.MethodBase.GetCurrentMethod().DeclaringType));
logger.Debug(" inside UpdateLicenseTerm for AccountNumber = " + accNumber);
Newtonsoft.Json.Linq.JObject userInfo = new Newtonsoft.Json.Linq.JObject();
userInfo.Add("accountNumber", accNumber);
dynamic result;
try
{
result = DBModel.UpdateLicenseTermStatus(accNumber);
}
catch (Exception ex)
{
logger.Fatal("Exception in UpdateLicenseTerm for AccountNumber =" + accNumber + " Exception= " + ex.Message + ", STACKTRACE: " + ex.StackTrace);
ArrayList supportMailList = UserUtility.GetSupportMailList();
string mailSubject = "SQL Exception intimation mail";
string mailBody = "MESSAGE: " + ex.Message + ", STACKTRACE: " + ex.StackTrace;
UserUtility.SendEmail(userInfo, supportMailList, "", mailSubject, mailBody);
result = AIAConstants.SQL_CONNECTION_ERROR;
}
return result;
}
}
}