public ActionResult MachinesInsertOrEdit(int machineID)
{
using (DBEPREntities db = new DBEPREntities())
{
MachinesViewModel mvm = new MachinesViewModel();
//for Modals:
List <MANUFACTURER> manList = db.MANUFACTURERS.Where(s => s.IsDeleted == false).ToList();
ViewBag.ManufacturerList = new SelectList(manList, "ID", "Name");
List <MACHINETYPE> tList = db.MACHINETYPES.Where(s => s.IsDeleted == false).ToList();
ViewBag.typeList = new SelectList(tList, "ID", "Name");
List <UZAUTOSUPPLIER> uList = db.UZAUTOSUPPLIERS.Where(s => s.IsDeleted == false).ToList();
ViewBag.UzAutoSupplierList = new SelectList(uList, "ID", "Name");
if (machineID > 0)
{
MACHINE machine = db.MACHINES.SingleOrDefault(m => m.IsDeleted == false && m.ID == machineID);
if (machine != null)
{
mvm.ID = machine.ID;
mvm.Name = machine.Name;
mvm.Description = machine.Description;
mvm.PartNumber = machine.PartNumber;
mvm.Lifespan = machine.Lifespan;
mvm.InstalledDate = machine.InstalledDate;
mvm.Status = machine.IsActive;
mvm.ManufacturerID = machine.ManufacturerID;
mvm.UzAutoSupplierID = machine.UzAutoSupplierID;
mvm.TypeID = machine.TypeID;
}
}
return(PartialView("MachinesInsertOrEdit", mvm));
}
}
public ActionResult Index()
{
var model = new MachinesViewModel
{
FilterText = ""
};
return(View(model));
}
public ActionResult MachinesSave(MachinesViewModel model)
{
using (DBEPREntities db = new DBEPREntities())
{
if (model.ID > 0)
{
MACHINE machine = db.MACHINES.SingleOrDefault(m => m.IsDeleted == false && m.ID == model.ID);
if (machine != null)
{
machine.Name = model.Name;
machine.Description = model.Description;
machine.Lifespan = model.Lifespan;
machine.InstalledDate = model.InstalledDate;
machine.PartNumber = model.PartNumber;
if (model.Status)
{
machine.IsActive = true;
}
else
{
machine.IsActive = false;
}
machine.ManufacturerID = model.ManufacturerID;
machine.UzAutoSupplierID = model.UzAutoSupplierID;
machine.TypeID = model.TypeID;
db.SaveChanges();
}
}
else
{
MACHINE machine = new MACHINE();
machine.Name = model.Name;
machine.Description = model.Description;
machine.Lifespan = model.Lifespan;
machine.InstalledDate = model.InstalledDate;
machine.PartNumber = model.PartNumber;
if (model.Status)
{
machine.IsActive = true;
}
else
{
machine.IsActive = false;
}
machine.ManufacturerID = model.ManufacturerID;
machine.UzAutoSupplierID = model.UzAutoSupplierID;
machine.TypeID = model.TypeID;
machine.IsDeleted = false;
db.MACHINES.Add(machine);
db.SaveChanges();
}
return(RedirectToAction("Machines"));
}
}
public ActionResult Machines()
{
using (DBEPREntities db = new DBEPREntities())
{
MachinesViewModel mvm = new MachinesViewModel();
mvm.machineList = db.MACHINES.Include("MACHINETYPE").Include("UZAUTOSUPPLIER").Include("MANUFACTURER").Where(m => m.IsDeleted == false).ToList();
return(View(mvm));
}
}
public async Task <IActionResult> Create(MachinesViewModel model)
{
if (ModelState.IsValid)
{
var newmachine = Mapper.Map <Machine>(model);
_context.Add(newmachine);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(model));
}
public async Task <IActionResult> Edit(string id, MachinesViewModel model)
{
if (ModelState.IsValid)
{
var machine = await _context.Machines.SingleAsync(x => x.Name == id);
Mapper.Map(model, machine);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(model));
}
/// <summary>
/// Initializes a new instance of the ViewModelLocator class.
/// </summary>
public ViewModelLocator()
{
////if (ViewModelBase.IsInDesignModeStatic)
////{
//// // Create design time services and viewmodels
////}
////else
////{
//// // Create run time services and view models
////}
main = new MainViewModel();
machinesViewModel = new MachinesViewModel();
}
private void CMMachineStart1_Click(object sender, RoutedEventArgs e)
{
try
{
SelectedMachineName = Common.MachineList[0].MachineName;
MachinesViewModel FirstMachine = Common.MachineList[0];
_continueth1 = true;
Thread readThread = new Thread(ReadFromth1);
readThread.Start(FirstMachine);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Initializes a new instance of the ViewModelLocator class.
/// </summary>
public ViewModelLocator()
{
////if (ViewModelBase.IsInDesignModeStatic)
////{
//// // Create design time services and viewmodels
////}
////else
////{
//// // Create run time services and view models
////}
main = new MainViewModel();
machinesViewModel = new MachinesViewModel();
}
internal static int SendEmail(MachinesViewModel selectedMachine)
{
int result = -1;
try
{
List <EMailViewModel> emailConfigList = Dalc.Dalc.LoadEmailConfiguration();
if (emailConfigList.Count > 0)
{
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress(emailConfigList[0].EmailFrom);
if (selectedMachine.EmailTo != "")
{
mail.To.Add(selectedMachine.EmailTo);
}
else
{
mail.To.Add(emailConfigList[0].EmailTo1);
}
mail.Subject = emailConfigList[0].EmailSubject;
mail.Body = emailConfigList[0].EmailBody;
mail.IsBodyHtml = true;
// Can set to false, if you are sending pure text.
//mail.Attachments.Add(new Attachment(@"D:\Projects\WPFProject\IDFI_IVMS\IVMSLatest_1_oct\IVMS\IVMS\Images\information.png"));
//mail.Attachments.Add(new Attachment("C:\\SomeZip.zip"));
using (SmtpClient smtp = new SmtpClient(emailConfigList[0].SMTPAddress, emailConfigList[0].SMTPPort))
{
smtp.Credentials = new NetworkCredential(emailConfigList[0].EmailFrom, emailConfigList[0].EmailPassword);
smtp.EnableSsl = emailConfigList[0].EnableSSL;
//smtp.Send(mail);
result = Dalc.Dalc.AddEmailToDatabase(0, selectedMachine, emailConfigList[0]);
if (result != -1)
{
logger.LogInfo("Email added successfuly in database.");
}
}
}
}
}
catch (Exception ex)
{
result = -1;
logger.LogError("Exception in method SendEmail, for server : " + selectedMachine.MachineName + " Message : " + ex.Message);
}
return(result);
}
/// <summary>
/// Method is used to add machine
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddMachine_Click(object sender, RoutedEventArgs e)
{
MachinesViewModel machine = new MachinesViewModel();
machine.MachineName = lblMachineName.Content.ToString();
machine.MachineLocation = lblMachineLocation.Content.ToString();
machine.ProductName = lblProductName.Content.ToString();
machine.SupervisorName = lblSupervisorName.Content.ToString();
machine.ConnectionType = (Common.ConnectionType)lblMachineConType.Content;
machine.EmailTo = lblEmailTo.Content.ToString();
if (machine.ConnectionType == Common.ConnectionType.Telnet)
{
machine.MachineIP = lblMachineIP.Content.ToString();
machine.MachinePort = Convert.ToUInt16(lblMachinePort.Content.ToString());
machine.COMPortName = "";
machine.COMPortBoadRate = "";
machine.COMPortParity = "";
}
else
{
machine.COMPortParity = "";
machine.MachineIP = "";
machine.MachinePort = 0;
machine.COMPortName = lblMachineIP.Content.ToString();
machine.COMPortBoadRate = lblMachinePort.Content.ToString();
machine.COMPortParity = "";
}
imgServerConfiguredDark.Visibility = Visibility.Hidden;
ErrorMessage errmsg = Common.ManageMachine(0, machine, CommandTypeEnum.Insert);
if (errmsg.ErrorId == 1)
{
MessageBox.Show("Machine : " + machine.MachineName + " Added successfuly");
imgServerConfiguredOK.Visibility = Visibility.Visible;
FinalImage.Visibility = Visibility.Hidden;
btnAddMachinePre.Visibility = Visibility.Hidden;
btnAddMachine.Visibility = Visibility.Hidden;
ClearAddMachineControls();
TabDashboard.IsSelected = true;
}
else if (errmsg.ErrorId == 100)
{
MessageBox.Show(errmsg.ErrorDescription);
imgServerConfiguredOK.Visibility = Visibility.Hidden;
}
}
// GET: Machines/Edit/5
public async Task <IActionResult> Edit(string id)
{
if (string.IsNullOrEmpty(id))
{
return(NotFound());
}
var machine = await _context.Machines.SingleOrDefaultAsync(m => m.Name == id);
MachinesViewModel model = Mapper.Map <MachinesViewModel>(machine);
if (machine == null)
{
return(NotFound());
}
return(View(model));
}
// GET: Machines
public async Task <IActionResult> Index(int skip = 0, int take = 10)
{
PaginationViewModel <MachinesViewModel> result = new PaginationViewModel <MachinesViewModel>();
int quantita = await _context.Machines.CountAsync();
List <Machine> person = await _context.Machines.Skip(skip).Take(take).ToListAsync();
result.Count = quantita;
result.Skip = skip;
foreach (var p in person)
{
MachinesViewModel pv = new MachinesViewModel()
{
IpMachine = p.IpMachine,
Nome = p.Name,
MacAddress = p.MacAddress
};
result.Data.Add(pv);
}
return(View(result));
}
/// <summary>
///
/// </summary>
/// <param name="ServerName"></param>
/// <param name="EmailVM"></param>
public static int AddEmailToDatabase(int Id, MachinesViewModel SelectedMachine, EMailViewModel EmailVM)
{
int result = -1;
try
{
using (MySqlConnection con = new MySqlConnection(connectionString))
{
con.Open();
MySqlCommand cmd = new MySqlCommand("spAddEmailLog", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
MySqlParameter pId = new MySqlParameter();
pId.ParameterName = "in_Id";
pId.Value = Id;
cmd.Parameters.Add(pId);
MySqlParameter pEmailFrom = new MySqlParameter();
pEmailFrom.ParameterName = "in_EmailFrom";
pEmailFrom.Value = EmailVM.EmailFrom;
cmd.Parameters.Add(pEmailFrom);
MySqlParameter pServerName = new MySqlParameter();
pServerName.ParameterName = "in_ServerName";
pServerName.Value = SelectedMachine.MachineName;
cmd.Parameters.Add(pServerName);
MySqlParameter pEmailTo = new MySqlParameter();
pEmailTo.ParameterName = "in_EmailTo";
pEmailTo.Value = SelectedMachine.EmailTo;
cmd.Parameters.Add(pEmailTo);
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 pEmailSubject = new MySqlParameter();
pEmailSubject.ParameterName = "in_EmailSubject";
pEmailSubject.Value = EmailVM.EmailSubject;
cmd.Parameters.Add(pEmailSubject);
MySqlParameter pEmailBody = new MySqlParameter();
pEmailBody.ParameterName = "in_EmailBody";
pEmailBody.Value = EmailVM.EmailBody;
cmd.Parameters.Add(pEmailBody);
MySqlParameter pEntryDate = new MySqlParameter();
pEntryDate.ParameterName = "in_EntryDate";
pEntryDate.Value = DateTime.Now;
cmd.Parameters.Add(pEntryDate);
result = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
result = -1;
logger.LogError("Exception in AddEmailToDatabase method,Message : " + ex.Message);
}
return(result);
}
/// <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);
}
public void ReadFromth1(object firstmachine)
{
MachinesViewModel FirstMachine = (MachinesViewModel)firstmachine;
while (_continueth1)
{
try
{
if (FirstMachine.ConnectionType == Common.ConnectionType.Telnet)
{
if (!client1Socket.Connected)
{
client1Socket.Connect(FirstMachine.MachineIP, Convert.ToInt32(FirstMachine.MachinePort));
}
NetworkStream serverStream = client1Socket.GetStream();
byte[] inStream = new byte[10025];
serverStream.Read(inStream, 0, (int)client1Socket.ReceiveBufferSize);
string replacement = Regex.Replace(System.Text.Encoding.ASCII.GetString(inStream), @"\t|\0", "");
logger.LogInfo("Received message from server : " + replacement);
//if (replacement == "1")
// {
Common.AddDataInDatabase(SelectedMachineName, replacement);
int result = Common.SendEmail(FirstMachine);
// }
}
else
{
if (_serialPort != null && _serialPort.IsOpen)
{
_serialPort.Close();
}
if (_serialPort == null)
{
_serialPort = new SerialPort(FirstMachine.COMPortName);
//_serialPort.DataReceived += new SerialDataReceivedEventHandler(DataReceivedHandlerForFirstMachine);
_serialPort.DtrEnable = true;
_serialPort.Handshake = Handshake.None;
_serialPort.BaudRate = Convert.ToInt32(FirstMachine.COMPortBoadRate);
_serialPort.Open();
string indata = _serialPort.ReadLine();
string message = Regex.Replace(indata, @"\t|\0", "");
Common.AddDataInDatabase(SelectedMachineName, message);
//Common.SendEmail(Common.MachineList[0]);
}
else
{
if (!_serialPort.IsOpen)
{
_serialPort.Open();
}
string indata = _serialPort.ReadLine();
string message = Regex.Replace(indata, @"\t|\0", "");
Common.AddDataInDatabase(SelectedMachineName, message);
//Common.SendEmail(Common.MachineList[0]);
}
}
}
catch (TimeoutException tex) { }
catch (Exception ex)
{
logger.LogError("" + ex.Message);
}
}
}
/// <summary>
/// Method is used to add server in database
/// </summary>
/// <param name="ServerName">Server Name</param>
/// <param name="ConnectionType">Telnet or COM Port</param>
/// <param name="ServerIP">Server IP</param>
/// <param name="ServerPort">Server Port Number</param>
/// <param name="COMPortName">COM Port Name</param>
/// <param name="COMPortParity"></param>
/// <param name="COMPortBoadRate"></param>
/// <returns></returns>
public static ErrorMessage ManageMachine(int MachineId, MachinesViewModel MachineVM, CommandTypeEnum CommandType)
{
return(Dalc.Dalc.ManageMachine(MachineId, MachineVM, CommandType));
}
