public static async Task <HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Function, "put", Route = "users/{id}")]
HttpRequestMessage req,
string id,
[Table(TableNames.User, Connection = "AzureWebJobsStorage")]
CloudTable outTable,
TraceWriter log)
{
var json = await req.Content.ReadAsStringAsync();
var model = JsonConvert.DeserializeObject <UserModel>(json);
var user = new UserEnity()
{
PartitionKey = id,
RowKey = id,
Name = model.Name,
AccessToken = model.AccessToken,
RefreshToken = model.RefreshToken,
TokenExpiry = model.TokenExpiry
};
var updateOperation = TableOperation.InsertOrReplace(user);
var result = outTable.Execute(updateOperation);
return(new HttpResponseMessage((HttpStatusCode)result.HttpStatusCode));
}
public Status Login1(UserEnity user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spUserLogin.ToString(), parameter, true);
string success = string.Empty;
switch (RES)
{
case 1:
success = AppConstant.SuccessMsg;
break;
case 2:
success = "User Removed";
break;
case 8:
success = "User Locked";
break;
case 9:
success = "Not activation";
break;
}
return(new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Login Login(UserEnity user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input),
};
DataHelper helper = null;
SqlDataReader sqlReader = null;
Login objLogin = new Login();
try
{
helper = new DataHelper(CommonFunctions.GetConnectionString());
var drUserDetails = helper.ExecuteDataSet(spUser.spUserLogin.ToString(), parameter);
if (drUserDetails.Tables.Count > 0)
{
foreach (DataRow dr in drUserDetails.Tables[0].Rows)
{
string success = string.Empty;
switch (Convert.ToInt32(dr["LOGINSTATUS"]))
{
case 1:
success = AppConstant.SuccessMsg;
break;
case 2:
success = "User Removed";
break;
case 8:
success = "User Locked";
break;
case 9:
success = "Not activation";
break;
}
objLogin.status = new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
};
}
if (drUserDetails.Tables.Count == 2)
{
foreach (DataRow dr in drUserDetails.Tables[1].Rows)
{
objLogin.user = new UserEnity();
objLogin.user.UserType = (Convert.ToInt32(dr[dbUserEnity.Type.ToString()]) == 1)?"user":"******";
objLogin.user.CreatedUser = UtilCipher.Encrypt(dr[dbUserEnity.CustomerID.ToString()].ToString());
objLogin.user.Email = dr[dbUserEnity.Email.ToString()].ToString();
objLogin.user.FirstName = dr[dbUserEnity.FirstName.ToString()].ToString();
objLogin.user.LastName = dr[dbUserEnity.LastName.ToString()].ToString();
objLogin.user.LastLogin = Convert.ToDateTime(dr[dbUserEnity.LastLogin.ToString()].ToString());
}
}
}
}
catch (Exception e)
{
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
sqlReader.Dispose();
}
}
return(objLogin);
}
