public ActionResult AddUser(User_Model_BusinessLayer AddedUserData)
{
string mssgBack_User = string.Empty;
string mssgBack_Email = string.Empty;
AddUserBusinessLayer insertNewUser = new AddUserBusinessLayer();
if (ModelState.IsValid)
{
try
{
mssgBack_User = insertNewUser.storeUserData(AddedUserData);
mssgBack_Email = insertNewUser.storeUserEmailData(AddedUserData);
return(RedirectToAction("AddUser")); //Add User's interface is displayed again
}
catch (Exception err)
{
string errorMessg = "Error saving new user's data" + err;
mssgBack_User = "******" + err;
return(View());
// throw;
}
}
ViewBag.mssgBack_User = mssgBack_User;
ViewBag.mssgBack_Email = mssgBack_Email;
return(View());
}
public string submit_User_eMail_DataUpdate(User_Model_BusinessLayer user_Email_DataToUpdate, string mssgBackForEmail)
{
string mssg_Back, mssg_Back_eMail = string.Empty;
mssg_Back = submitUpdatedUserData(user_Email_DataToUpdate);
mssg_Back_eMail = submit_UpdatedUser_eMailData(user_Email_DataToUpdate);
mssgBackForEmail = mssg_Back_eMail;
return(mssg_Back);
}
public ActionResult AddUser()
{
User_Model_BusinessLayer userData_Model = new User_Model_BusinessLayer();
AddUserBusinessLayer userData_BusinessLayer = new AddUserBusinessLayer();
try
{
userData_Model = userData_BusinessLayer.User_Data_Get(null, null, false); //Retrieves user data from database
}
catch (Exception err)
{
string errMssg = "Error in database trying to use strk_read_api.sel_tbl_fp_roles or .sel_tbl_fp_contractor " + err.Message.ToString();
return(View());
//throw;
}
return(View(userData_Model));
}
public string submitUpdatedUserData(User_Model_BusinessLayer userDataToUpdate)
{
string mssgBack = "Data of user " + userDataToUpdate.FIRST_NAME + " " + userDataToUpdate.LAST_NAME + " was saved successfully";
string connectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
User_Model_BusinessLayer selectedUserData = new User_Model_BusinessLayer();
DataSet dataset = new DataSet();
using (OracleConnection con = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand("sp_users", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("last_name", OracleDbType.Varchar2).Value = (string)userDataToUpdate.LAST_NAME;
cmd.Parameters.Add("first_name", OracleDbType.Varchar2).Value = (string)userDataToUpdate.FIRST_NAME;
//cmd.Parameters.Add("V_OUTPUT", OracleDbType.RefCursor, ParameterDirection.Output);
try
{
con.Open();
OracleDataAdapter da = new OracleDataAdapter(cmd);
cmd.ExecuteNonQuery();
da.Fill(dataset);
}
catch (Exception err)
{
string errMssg = "Error reading contractors table: " + err.Message;
mssgBack = "Error in database: data of user " + userDataToUpdate.FIRST_NAME + " " + userDataToUpdate.LAST_NAME + " was not updated";
}
finally
{
con.Close();
}
}
return(mssgBack);
}
public ActionResult UpdateUser(User_Model_BusinessLayer userUIUpdatedData)
{
string mssg_back = string.Empty;
string messageBackEmail = string.Empty;
UpdateUser_BusinessLayer submitUser_update = new UpdateUser_BusinessLayer();
if (ModelState.IsValid)
{
try
{
mssg_back = submitUser_update.submit_User_eMail_DataUpdate(userUIUpdatedData, messageBackEmail);
}
catch (Exception err)
{
string errormssg = "Error while updating users data" + err.Message;
mssg_back = "Error in the connection to database while updating data of user" + userUIUpdatedData.FIRST_NAME.ToString() + " " + userUIUpdatedData.LAST_NAME.ToString() + "check connection and try again";
return(View());
}
}
ViewBag.mssgBack_User = mssg_back;
ViewBag.mssgBack_Email = messageBackEmail;
return(RedirectToAction("UserEdit"));
}
public ActionResult UpdateUser(string selecteduser_ID)
{
User_Model_BusinessLayer selectedUserRetrievedData = new User_Model_BusinessLayer();
EditUser_BusinessLayer getSelectedUserData = new EditUser_BusinessLayer(); // Will hold the personal data of the user to be edited
List <Junc_Email_Dest_Model_BusinessLayer> selectedUserRetrievedJuncEmailDataList = new List <Junc_Email_Dest_Model_BusinessLayer>();
EditUser_BusinessLayer getSelectedUserJuncEmailDataList = new EditUser_BusinessLayer(); // Will hold the email data of the user to be edited
User_Model_BusinessLayer modelWithSelectedUserProfile = new User_Model_BusinessLayer();
EditUser_BusinessLayer getDataForModelWithUserProfile = new EditUser_BusinessLayer(); // Will be the model used to build the Edit User interface
try
{
selectedUserRetrievedData = getSelectedUserData.Get_User_Data_Cursor(selecteduser_ID); // Will retrieve the personal data of the user to be edited
selectedUserRetrievedJuncEmailDataList = getSelectedUserJuncEmailDataList.Get_User_Email_Cursor(selecteduser_ID); // Will retrieve the email data of the user to be edited
if (!(selectedUserRetrievedJuncEmailDataList.Count == 0)) //There is email's data in the table
{
var emailCode_Dictionary = new Dictionary <string, string>();
string e_mailCondition = "N";
foreach (Junc_Email_Dest_Model_BusinessLayer emailItem in selectedUserRetrievedJuncEmailDataList)
{
if (emailItem.P_EMAIL == "Y")
{
e_mailCondition = "P";
}
else
{
e_mailCondition = "N";
}
emailCode_Dictionary.Add(emailItem.EMAIL_REASON_CODE, e_mailCondition);
}
ViewData["emailDict"] = emailCode_Dictionary;
}
else
{
Session["mssgCont"] = "No email records were found for user ID " + selecteduser_ID.ToString() + ". Information could be deleted or corrupted";
return(RedirectToAction("UserEdit"));
}
string userSelected_RoleID = selectedUserRetrievedData.ROLE_ID.ToString();
string userSelected_ContractorID = selectedUserRetrievedData.CONTRACTOR_ID.ToString();
modelWithSelectedUserProfile = getDataForModelWithUserProfile.editUserForUpdate_DataGet(userSelected_RoleID, userSelected_ContractorID); // Retrieves user's role and contractor as selected in the corresponding dropdownlist
modelWithSelectedUserProfile.USER_ID = selectedUserRetrievedData.USER_ID; //populates model for rendering user data
modelWithSelectedUserProfile.LAST_NAME = selectedUserRetrievedData.LAST_NAME;
return(View(modelWithSelectedUserProfile));
}
catch (Exception err)
{
string errMssg = "Error reading juncEmail table (using SP: sel_junc_email_dest) at UserMaintenanceController level: " + err.Message;
//return View("Error",)
ViewBag.mssgBack_Email = "Error reading data from the database, check connection is up and try again ";
return(RedirectToAction("UserEdit"));
// throw;
}
//return RedirectToAction("UserEdit");
}
public string submit_UpdatedUser_eMailData(User_Model_BusinessLayer userEmail_DataToUpdate)
{
{
string mssgBack = "The email data of user " + userEmail_DataToUpdate.FIRST_NAME + " " + userEmail_DataToUpdate.LAST_NAME + " was updated succesfully";
string EMAIL = "N"; string CC_EMAIL = "N";
string BC_EMAIL = "N"; string NO_EMAIL = "N";
/*
* DESCRIPTION
* The following assignments are establishing the EMAIL_REASON_CODE code for each EMAIL_REASON_CODE text. Example: code 41 is for DbError etc. - codes established in previous Classic ASP version -
*
* TABLE OF EMAIL_REASON_CODE values
*
* CODE DESCRIPTION | CODE DESCRIPTION | CODE DESCRIPTION
* 41 = DbError | 42 = InspDetermChange | 43 = InspDeleted
*
* The value stored in userEmail_Data.DbError (and the others like 'InspDetermChange', etc.) can be P, C, B or N */
string _userID = userEmail_DataToUpdate.USER_ID.ToString();
string[] emailUserID_Array = new string[] { _userID, _userID, _userID, _userID, _userID, _userID, _userID };
string[] emailReasonCode_Array = new string[] { "41", "42", "43" }; // NOTE: the length of this array is used to calculate cmd.ArrayBindCount used in the Oracle instruction below
string[] emailConditionSelected = new string[] { userEmail_DataToUpdate.DbError.ToString(), // Can have the values "P", "C" indicating DbError is going
userEmail_DataToUpdate.InspDetermChange.ToString(), userEmail_DataToUpdate.InspDeleted.ToString(), // to Primary Email ("P") or CCEmail ("C")... etc. Same for the
userEmail_DataToUpdate.TechSolutions.ToString(), userEmail_DataToUpdate.ContactUs.ToString() };
string[] emailConditions_Array = new string[] { "P", "C" }; // array used just to count amount of conditions for emaiCX matix
string[,] emailCX = new string[emailReasonCode_Array.Length, emailConditions_Array.Length];
for (int indexEmailReasonCode = 0; indexEmailReasonCode <= (int)emailReasonCode_Array.Length - 1; indexEmailReasonCode++)
{
EMAIL = "N"; CC_EMAIL = "N";
BC_EMAIL = "N"; NO_EMAIL = "N";
switch (emailConditionSelected[indexEmailReasonCode])
{
case "P": EMAIL = "Y"; break; // set the value "Y" or "N" for
case "C": CC_EMAIL = "Y"; break;
}
emailCX[indexEmailReasonCode, 0] = EMAIL;
emailCX[indexEmailReasonCode, 1] = CC_EMAIL;
}
// in emailCX[x, y] x = emailReasonCode ("41", "42", "43" ... etc.) established by the instruction: for ( int indexEmailReasonCode = 0; indexEmailReasonCode <= (int)emai... etc. as seen above
// and y = emailCondition ("P", "C", "B" ... etc.) established by the instruction: switch (emailConditionSelected[indexEmailReasonCode]) { case "P": EMAIL = "Y"; break; ... etc. as seen above
// because Oracle Array Binded parameters are implemented, the matrix emailCX is transposed (interchanging rows for columns, and columns for rows) with respect of the matrix (table) of the UI
string[] email_Array = new string[] { emailCX[0, 0], emailCX[1, 0], emailCX[2, 0], emailCX[3, 0], emailCX[4, 0], emailCX[5, 0], emailCX[6, 0] }; // EMAIL's yes or not for each condition (Database Error or Inspector Determ... etc.)
string[] cc_email_Array = new string[] { emailCX[0, 1], emailCX[1, 1], emailCX[2, 1], emailCX[3, 1], emailCX[4, 1], emailCX[5, 1], emailCX[6, 1] }; //CC_EMAIL's yes or not for each condition (Database Error or Inspector Determ... etc.)
string connectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (OracleConnection con = new OracleConnection(connectionString))
{
con.Open();
OracleCommand cmd = new OracleCommand("sp_email_dest", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ArrayBindCount = emailReasonCode_Array.Length;
OracleTransaction oracle_Transaction;
cmd.Connection = con;
oracle_Transaction = con.BeginTransaction(); //(IsolationLevel.ReadCommitted); //starts local transaction
cmd.Transaction = oracle_Transaction; //assign transaction object for a pending local transaction
try
{
cmd.Parameters.Add("user_id", OracleDbType.Varchar2).Value = emailUserID_Array;
cmd.Parameters.Add("email_reason_code", OracleDbType.Varchar2).Value = emailReasonCode_Array;
cmd.Parameters.Add("email", OracleDbType.Varchar2).Value = email_Array;
cmd.Parameters.Add("V_OUTPUT", OracleDbType.RefCursor, ParameterDirection.Output);
cmd.ExecuteNonQuery();
oracle_Transaction.Commit();
}
catch (Exception err)
{
oracle_Transaction.Rollback();
string errMssg = "Error inserting emails in table: " + err.Message;
mssgBack = "Error saving emails' data, database was reset, check if connection is up and try again";
//throw;
}
finally
{
con.Close();
}
}
return(mssgBack);
}
}
