/// <summary> /// /// </summary> /// <param name="Id"></param> /// <param name="serverVM"></param> /// <param name="CommandType"></param> /// <returns></returns> public static ErrorMessage ManageMachine(int MachineId, MachinesViewModel machineVM, CommandTypeEnum CommandType) { ErrorMessage errmsg = new ErrorMessage(); try { using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); MySqlCommand cmd = new MySqlCommand("spManageMachine", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; MySqlParameter pId = new MySqlParameter(); pId.ParameterName = "in_Id"; pId.Value = MachineId; cmd.Parameters.Add(pId); MySqlParameter pMachineName = new MySqlParameter(); pMachineName.ParameterName = "in_MachineName"; pMachineName.Value = machineVM.MachineName; cmd.Parameters.Add(pMachineName); MySqlParameter pMachineLocation = new MySqlParameter(); pMachineLocation.ParameterName = "in_MachineLocation"; pMachineLocation.Value = machineVM.MachineLocation; cmd.Parameters.Add(pMachineLocation); MySqlParameter pProductName = new MySqlParameter(); pProductName.ParameterName = "in_ProductName"; pProductName.Value = machineVM.ProductName; cmd.Parameters.Add(pProductName); MySqlParameter pSupervisorName = new MySqlParameter(); pSupervisorName.ParameterName = "in_SupervisorName"; pSupervisorName.Value = machineVM.SupervisorName; cmd.Parameters.Add(pSupervisorName); MySqlParameter pEmailTo = new MySqlParameter(); pEmailTo.ParameterName = "in_EmailTo"; pEmailTo.Value = machineVM.EmailTo; cmd.Parameters.Add(pEmailTo); MySqlParameter pConnectionType = new MySqlParameter(); pConnectionType.ParameterName = "in_ConnectionType"; pConnectionType.Value = machineVM.ConnectionType; cmd.Parameters.Add(pConnectionType); MySqlParameter pServerIP = new MySqlParameter(); pServerIP.ParameterName = "in_MachineIP"; pServerIP.Value = machineVM.MachineIP; cmd.Parameters.Add(pServerIP); MySqlParameter pServerPort = new MySqlParameter(); pServerPort.ParameterName = "in_MachinePort"; pServerPort.Value = machineVM.MachinePort; cmd.Parameters.Add(pServerPort); MySqlParameter pComportName = new MySqlParameter(); pComportName.ParameterName = "in_ComportName"; pComportName.Value = machineVM.COMPortName; cmd.Parameters.Add(pComportName); MySqlParameter pComportParity = new MySqlParameter(); pComportParity.ParameterName = "in_ComportParity"; pComportParity.Value = machineVM.COMPortParity; cmd.Parameters.Add(pComportParity); MySqlParameter pin_ComPortBaudRate = new MySqlParameter(); pin_ComPortBaudRate.ParameterName = "in_ComPortBaudRate"; pin_ComPortBaudRate.Value = machineVM.COMPortBoadRate; cmd.Parameters.Add(pin_ComPortBaudRate); MySqlParameter pCommandType = new MySqlParameter(); pCommandType.ParameterName = "in_CommandType"; pCommandType.Value = CommandType.ToString(); cmd.Parameters.Add(pCommandType); MySqlParameter outPutErrorId = new MySqlParameter(); outPutErrorId.ParameterName = "out_ErrorId"; outPutErrorId.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorId); MySqlParameter outPutErrorMessage = new MySqlParameter(); outPutErrorMessage.ParameterName = "out_ErrorMessage"; outPutErrorMessage.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorMessage); cmd.ExecuteNonQuery(); errmsg.ErrorId = (int)outPutErrorId.Value; errmsg.ErrorDescription = outPutErrorMessage.Value.ToString(); } } catch (Exception ex) { logger.LogError("Exception in DALC CLASS, Method Name AddMachine, Message : " + ex.Message); errmsg.ErrorId = 0; errmsg.ErrorDescription = ex.Message; } return(errmsg); }
internal static ErrorMessage ManageUser(UserViewModel userviewmodel, CommandTypeEnum commandtype) { ErrorMessage errmsg = new ErrorMessage(); string connectionString = ConfigurationManager.ConnectionStrings["myCon"].ConnectionString; try { using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); MySqlCommand cmd = new MySqlCommand("sp_ManageUser", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; MySqlParameter pin_UserId = new MySqlParameter(); pin_UserId.ParameterName = "in_UserId"; pin_UserId.Value = userviewmodel.UserId; cmd.Parameters.Add(pin_UserId); MySqlParameter pin_FullName = new MySqlParameter(); pin_FullName.ParameterName = "in_FullName"; pin_FullName.Value = userviewmodel.FullName; cmd.Parameters.Add(pin_FullName); MySqlParameter pin_Designation = new MySqlParameter(); pin_Designation.ParameterName = "in_Designation"; pin_Designation.Value = userviewmodel.Designation; cmd.Parameters.Add(pin_Designation); MySqlParameter pin_Email = new MySqlParameter(); pin_Email.ParameterName = "in_Email"; pin_Email.Value = userviewmodel.Email; cmd.Parameters.Add(pin_Email); MySqlParameter pin_Mobile = new MySqlParameter(); pin_Mobile.ParameterName = "in_Mobile"; pin_Mobile.Value = userviewmodel.Mobile; cmd.Parameters.Add(pin_Mobile); MySqlParameter pin_UserName = new MySqlParameter(); pin_UserName.ParameterName = "in_UserName"; pin_UserName.Value = userviewmodel.UserName; cmd.Parameters.Add(pin_UserName); MySqlParameter pin_Password = new MySqlParameter(); pin_Password.ParameterName = "in_Password"; pin_Password.Value = userviewmodel.Password; cmd.Parameters.Add(pin_Password); MySqlParameter pCommandType = new MySqlParameter(); pCommandType.ParameterName = "in_CommandType"; pCommandType.Value = commandtype.ToString(); cmd.Parameters.Add(pCommandType); MySqlParameter outPutErrorId = new MySqlParameter(); outPutErrorId.ParameterName = "out_ErrorId"; outPutErrorId.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorId); MySqlParameter outPutErrorMessage = new MySqlParameter(); outPutErrorMessage.ParameterName = "out_ErrorMessage"; outPutErrorMessage.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorMessage); cmd.ExecuteNonQuery(); errmsg.ErrorId = (int)outPutErrorId.Value; errmsg.ErrorDescription = outPutErrorMessage.Value.ToString(); } } catch (Exception ex) { errmsg.ErrorId = 0; errmsg.ErrorDescription = "Exception in ManageUser method, Message" + ex.Message; } return(errmsg); }
internal static ErrorMessage ManageEmailConfig(EMailViewModel EmailVM, CommandTypeEnum commandtype) { ErrorMessage errmsg = new ErrorMessage(); string connectionString = ConfigurationManager.ConnectionStrings["myCon"].ConnectionString; try { using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); MySqlCommand cmd = new MySqlCommand("spEmailConfig", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; MySqlParameter pId = new MySqlParameter(); pId.ParameterName = "in_Id"; pId.Value = EmailVM.Id; cmd.Parameters.Add(pId); MySqlParameter pEmailName = new MySqlParameter(); pEmailName.ParameterName = "in_EmailName"; pEmailName.Value = EmailVM.EmailName; cmd.Parameters.Add(pEmailName); MySqlParameter pEmailFrom = new MySqlParameter(); pEmailFrom.ParameterName = "in_EmailFrom"; pEmailFrom.Value = EmailVM.EmailFrom; cmd.Parameters.Add(pEmailFrom); MySqlParameter pEmailPassword = new MySqlParameter(); pEmailPassword.ParameterName = "in_EmailPassword"; pEmailPassword.Value = EmailVM.EmailPassword; cmd.Parameters.Add(pEmailPassword); MySqlParameter pSMTPAddress = new MySqlParameter(); pSMTPAddress.ParameterName = "in_SMTPAddress"; pSMTPAddress.Value = EmailVM.SMTPAddress; cmd.Parameters.Add(pSMTPAddress); MySqlParameter pSMTPPort = new MySqlParameter(); pSMTPPort.ParameterName = "in_SMTPPort"; pSMTPPort.Value = EmailVM.SMTPPort; cmd.Parameters.Add(pSMTPPort); MySqlParameter pEnableSSL = new MySqlParameter(); pEnableSSL.ParameterName = "in_EnableSSL"; pEnableSSL.Value = EmailVM.EnableSSL; cmd.Parameters.Add(pEnableSSL); MySqlParameter pEmailTo1 = new MySqlParameter(); pEmailTo1.ParameterName = "in_EmailTo1"; pEmailTo1.Value = EmailVM.EmailTo1; cmd.Parameters.Add(pEmailTo1); MySqlParameter pEmailTo2 = new MySqlParameter(); pEmailTo2.ParameterName = "in_EmailTo2"; pEmailTo2.Value = EmailVM.EmailTo2; cmd.Parameters.Add(pEmailTo2); MySqlParameter pEmailTo3 = new MySqlParameter(); pEmailTo3.ParameterName = "in_EmailTo3"; pEmailTo3.Value = EmailVM.EmailTo3; cmd.Parameters.Add(pEmailTo3); MySqlParameter pEmailTo4 = new MySqlParameter(); pEmailTo4.ParameterName = "in_EmailTo4"; pEmailTo4.Value = EmailVM.EmailTo4; cmd.Parameters.Add(pEmailTo4); MySqlParameter pEmailTo5 = new MySqlParameter(); pEmailTo5.ParameterName = "in_EmailTo5"; pEmailTo5.Value = EmailVM.EmailTo5; cmd.Parameters.Add(pEmailTo5); MySqlParameter pEntryDate = new MySqlParameter(); pEntryDate.ParameterName = "in_EntryDate"; pEntryDate.Value = EmailVM.EntryDate; cmd.Parameters.Add(pEntryDate); MySqlParameter pCommandType = new MySqlParameter(); pCommandType.ParameterName = "in_CommandType"; pCommandType.Value = commandtype.ToString(); cmd.Parameters.Add(pCommandType); MySqlParameter outPutErrorId = new MySqlParameter(); outPutErrorId.ParameterName = "out_ErrorId"; outPutErrorId.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorId); MySqlParameter outPutErrorMessage = new MySqlParameter(); outPutErrorMessage.ParameterName = "out_ErrorMessage"; outPutErrorMessage.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(outPutErrorMessage); cmd.ExecuteNonQuery(); errmsg.ErrorId = (int)outPutErrorId.Value; errmsg.ErrorDescription = outPutErrorMessage.Value.ToString(); } } catch (Exception ex) { errmsg.ErrorId = 0; errmsg.ErrorDescription = ex.Message; } return(errmsg); }