/// <summary>
/// This method is used to add new user data in the system
/// </summary>
/// <param name="uData"></param>
/// <returns></returns>
private bool AddUserData(UserProfileData uData)
{
bool status = false;
if (_isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Request came in for AddUserData at {0}", DateTime.Now.ToString("MM/dd/yyy H:mm:ss zzz")));
}
//return as no Sql tables & procs are defined.
return(false);
if (uData == null)
{
if (_isDebugEnabled)
{
LogInformation.LogInfor("User data come as null obj");
}
return(false);
}
try
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
string procName = "Add_User_Profile";//Assuming proc is already in db
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.CommandText = procName;
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.Parameters.Clear();
//only working on FirstName, Lastname, Email...
sqlCommand.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = uData.FirstName;
sqlCommand.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = uData.LastName;
sqlCommand.Parameters.Add("@EmailAddress", SqlDbType.NVarChar).Value = uData.EmailAddress;
sqlConnection.Open();
var reader = sqlCommand.ExecuteNonQuery();
if (reader > 0 && _isDebugEnabled)
{
LogInformation.LogInfor("User data added succefully in the system");
status = true;
}
}
}
}
catch (Exception ex)
{
LogInformation.LogError(string.Format("{0}:{1}", ex.Message, ex.StackTrace));
status = false;
}
return(status);
}
public static void Main(string[] args)
{
if (_isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Sample Console app started at {0}", DateTime.Now.ToString("MM/dd/yyy H:mm:ss zzz")));
}
if (_isWriteToDbEnabled)
{
if (_isDebugEnabled)
{
LogInformation.LogInfor("Process Db Write Request");
}
ProcessDbWriteRequest();
}
else
{
if (_isDebugEnabled)
{
LogInformation.LogInfor("Process Console App Request");
}
ProcessAppRequest();
}
Console.WriteLine("Hello World...");
Console.WriteLine("Console app processing Completed!!!");
Console.ReadKey();
if (_isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Sample Console app Completed at {0}", DateTime.Now.ToString("MM/dd/yyy H:mm:ss zzz")));
}
}
/// <summary>
/// Helper method to Get All existing Users in the Database
/// </summary>
/// <returns>generic list of user profile obj</returns>
private UserProfileData[] GetAllUserProfiles()
{
if (_isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Request came in for GetAllUserProfiles at {0}", DateTime.Now.ToString("MM/dd/yyy H:mm:ss zzz")));
}
List <UserProfileData> profileList = null;
//return as no Sql tables & procs are defined.
return(null);
try
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
string procName = "Get_All_Users_List";//assuming their is a proc already defined
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.CommandText = procName;
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlConnection.Open();
var reader = sqlCommand.ExecuteReader();
profileList = new List <UserProfileData>();
if (reader.HasRows && _isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Data found for the Request GetAllUserProfiles"));
}
while (reader.Read())
{
//only working on FirstName, Lastname, Email...
var u = new UserProfileData()
{
FirstName = reader["FirstName"] is DBNull ? null : reader["FirstName"].ToString(),
LastName = reader["LastName"] is DBNull ? null : reader["LastName"].ToString(),
EmailAddress = reader["EmailAddress"] is DBNull ? null : reader["EmailAddress"].ToString()
};
profileList.Add(u);
}
}
}
}
catch (Exception ex)
{
LogInformation.LogError(string.Format("{0}:{1}", ex.Message, ex.StackTrace));
return(null);
}
if (_isDebugEnabled)
{
LogInformation.LogInfor(string.Format("Request completed for GetAllUserProfiles at {0}", DateTime.Now.ToString("MM/dd/yyy H:mm:ss zzz")));
}
if (profileList != null)
{
return(profileList.ToArray());
}
return(null);
}
