public async Task <UserInfo> GetUserInfoAsync(string account, string channelName, string channelId)
{
using (var ctx = new UserInfoEntities(this.connectionString))
{
var entitiy = await ctx.UserInfos.SingleOrDefaultAsync(f => f.Account == account && f.ChannelId == channelId && f.ChannelName == channelName);
return(entitiy);
}
}
public async Task DeleteSocialLoginAccountDataAsync(string account)
{
using (var ctx = new UserInfoEntities(this.connectionString))
{
var entities = await ctx.UserInfos.Where(f => f.Account == account).ToListAsync();
if (entities == null || !entities.Any())
{
return;
}
ctx.UserInfos.RemoveRange(entities);
await ctx.SaveChangesAsync();
}
}
public async Task DeleteUserInfoAsync(string account, string channelName, string channelId)
{
using (var ctx = new UserInfoEntities(this.connectionString))
{
var entities = await ctx.UserInfos.Where(f => f.Account == account && f.ChannelId == channelId && f.ChannelName == channelName).ToListAsync();
if (entities == null || !entities.Any())
{
return;
}
// Remove profiles
ctx.UserInfos.RemoveRange(entities);
await ctx.SaveChangesAsync();
}
}
public ActionResult Login(Table usr)
{
if (ModelState.IsValid)
{
using (UserInfoEntities uie = new UserInfoEntities())
{
var v = uie.Tables.Where(a => a.Username.Equals(usr.Username) && a.Password.Equals(usr.Password)).FirstOrDefault();
if (v != null)
{
Session["LogedUserID"] = v.UserID.ToString();
Session["LogedUserFullname"] = v.Fullname.ToString();
return(RedirectToAction("AfterLogin"));
}
}
}
return(View(usr));
}
public List <UserInfoEntities> UpdateAccount(MRequest request)
{
UserInfoEntities users = null;
List <UserInfoEntities> accounts = new List <UserInfoEntities>();
try
{
using (var conn = DALHelper.GetConnection())
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = DBConstants.UserManagement.Update_Account;
cmd.Parameters.AddWithValue("@UserName", request.User.UserName);
cmd.Parameters.AddWithValue("@UserPassword", request.User.Password);
cmd.Parameters.AddWithValue("@MobileNumber", request.User.MobileNumber);
cmd.Parameters.AddWithValue("@Email", request.User.Email);
cmd.Parameters.AddWithValue("@Hospital", request.User.Hospital);
cmd.Parameters.AddWithValue("@UserId", request.User.UserId);
conn.Open();
// UserId = Convert.ToInt32(cmd.ExecuteScalar());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
users = new UserInfoEntities();
users.UserId = Convert.ToInt32(dr["UserId"]);
users.UserName = Convert.ToString(dr["UserName"]);
users.Password = Convert.ToString(dr["UserPassword"]);
users.MobileNumber = Convert.ToString(dr["MobileNumber"]);
users.Email = Convert.ToString(dr["Email"]);
users.Hospital = Convert.ToString(dr["Hospital"]);
accounts.Add(users);
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(accounts);
}
public async Task <UserInfoResult> CreateorUpdateUserInfoAsync(string account, string channelId, UserInfoRecordDescription description)
{
using (var ctx = new UserInfoEntities(this.connectionString))
{
UserInfoResult userInfoResult = new UserInfoResult();
byte[] serializedProfileDescription;
using (MemoryStream stream = new MemoryStream())
{
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, description);
serializedProfileDescription = stream.ToArray();
}
var profile = await ctx.UserInfos.SingleOrDefaultAsync(f => f.Account == account && f.ChannelId == channelId && f.ChannelName == description.Channel);
var startTime = DateTime.UtcNow;
if (profile == null)
{
profile = new UserInfo
{
Account = account,
ChannelName = description.Channel,
ChannelId = channelId,
ChannelProperties = serializedProfileDescription,
CreatedTime = startTime,
ModifiedTime = startTime
};
ctx.UserInfos.Add(profile);
userInfoResult.Action = ActionType.Create;
}
else
{
profile.ChannelProperties = serializedProfileDescription;
profile.ModifiedTime = startTime;
userInfoResult.Action = ActionType.Update;
}
await ctx.SaveChangesAsync();
userInfoResult.UserInfo = profile;
return(userInfoResult);
}
}
public List <UserInfoEntities> FetchAccounts(string hospital)
{
UserInfoEntities users = null;
List <UserInfoEntities> accounts = new List <UserInfoEntities>();
try
{
using (var conn = DALHelper.GetConnection())
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = DBConstants.UserManagement.Fetch_Users;
cmd.Parameters.AddWithValue("@Hospital", hospital);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
users = new UserInfoEntities();
users.UserId = Convert.ToInt32(dr["UserId"]);
users.UserName = Convert.ToString(dr["UserName"]);
users.Password = Convert.ToString(dr["UserPassword"]);
users.MobileNumber = Convert.ToString(dr["MobileNumber"]);
users.Email = Convert.ToString(dr["Email"]);
users.Hospital = Convert.ToString(dr["Hospital"]);
accounts.Add(users);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(accounts);
}