public SalesLead readFromDatabase(int salesLeadsID) { DBLink.openConnection(); string sqlUser = "******" + salesLeadsID + ";"; MySqlDataReader salesleadData = DBLink.executeReadQuarry(sqlUser); if (salesleadData.Read()) { int customerID = salesleadData.GetInt32(1); int productID = salesleadData.GetInt32(2); SalesLead existingSalesLead = new SalesLead(null, null, null); existingSalesLead.SalesID = salesleadData.GetInt32(0); existingSalesLead.getSalesActivity(ActivityType.SalesIssue).ActivityDate = Rules.dbNullDateField(salesleadData, 3); existingSalesLead.RevenueType = salesleadData.GetString(4); existingSalesLead.MonthlyRevenue = salesleadData.GetDecimal(5); existingSalesLead.HadTest = Rules.yesnoToBoolean(salesleadData.GetString(6)); existingSalesLead.ProjectRevenue = salesleadData.GetDecimal(7); existingSalesLead.ProjectPaid = salesleadData.GetDecimal(8); existingSalesLead.getSalesActivity(ActivityType.CustomerConfirm).ActivityDate = Rules.dbNullDateField(salesleadData, 9); existingSalesLead.getSalesActivity(ActivityType.AgreementSign).ActivityDate = Rules.dbNullDateField(salesleadData, 11); existingSalesLead.getSalesActivity(ActivityType.DSP).ActivityDate = Rules.dbNullDateField(salesleadData, 12); existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDetails = salesleadData.GetString(13); existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDate = Rules.dbNullDateField(salesleadData, 14); existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDetails = salesleadData.GetString(15); existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDate = Rules.dbNullDateField(salesleadData, 16); existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDate = Rules.dbNullDateField(salesleadData, 17); existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDetails = salesleadData.GetString(18); existingSalesLead.CustomerFeedBack = salesleadData.GetString(19); existingSalesLead.Discount = salesleadData.GetDecimal(20); existingSalesLead.Notes = salesleadData.GetString(21); int purchaseOrderFileSize = salesleadData.GetInt32(22); byte[] binaryData = new byte[purchaseOrderFileSize]; if (purchaseOrderFileSize > 0) { salesleadData.GetBytes(10, 0, binaryData, 0, purchaseOrderFileSize); } existingSalesLead.PurchaseOrderData = binaryData; Administration.Customer.Customer customer = Administration.Customer.CustomerDA.getInstance().readFromDatabase(customerID); Administration.Product.Product product = Administration.Product.ProductDA.getInstance().readFromDatabase(productID); Administration.User.User accManager = Administration.User.UserDA.getInstance().readFromDatabase(customer.AccountManager); existingSalesLead.Customer = customer; existingSalesLead.Product = product; existingSalesLead.AccountManager = accManager; return(existingSalesLead); } return(null); }
private void btnLogin_Click(object sender, EventArgs e) { #if DevoloperMode MessageBox.Show("Elaz..(y)"); General.frmMain mainForm = new General.frmMain(); Administration.User.User devUser = new Administration.User.User(); devUser.Permissions = 3; devUser.Name = "Developer"; devUser.UserName = "******"; General.frmMain.AppUser = devUser; mainForm.Show(); this.Hide(); #else UserLogin user = new UserLogin(txtUsername.Text.Trim(), txtPassword.Text.Trim()); if (user.Login()) { MessageBox.Show("Login Success.", "Welcome", MessageBoxButtons.OK, MessageBoxIcon.Information); General.frmMain mainForm = new General.frmMain(); General.frmMain.AppUser = Administration.User.UserDA.getInstance().readFromDatabase(txtUsername.Text.Trim()); mainForm.Show(); this.Hide(); } else { if (user.hasLoginError()) { if (MessageBox.Show(this, user.ErrorDetails(), "Login Failed", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.Yes) { user.resetPassword(); } } else { MessageBox.Show(this, user.ErrorDetails(), "Login Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } #endif }