Ejemplo n.º 1
0
        public bool updateToDatabase(SalesLead existingSalesLead)
        {
            string sqlUpdateCustomer = "UPDATE `salesleads`.`customerproduct` SET `CustomerID` = '" + existingSalesLead.Customer.CustomerID + "',`ProductID` = '" + existingSalesLead.Product.ProductID + "', `IssueDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.SalesIssue).ActivityDate) + ", `RevenueType` = '" + existingSalesLead.RevenueType + "', `MonthlyRevenue` = '" + existingSalesLead.MonthlyRevenue + "', `HadTest` = '" + Rules.boolToYesNo(existingSalesLead.HadTest) + "', `ProjectRevenue` = '" + existingSalesLead.ProjectRevenue + "', `ProjectPaid` = '" + existingSalesLead.ProjectPaid + "', `CustomerConfirmDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.CustomerConfirm).ActivityDate) + ",`PurchaseOrderLocation`=?FileData, `AgreementSignDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.AgreementSign).ActivityDate) + ", `DSP` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.DSP).ActivityDate) + ", `FirstBillIssued` = '" + existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDetails + "', `BillIssueDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDate) + ", `SuccessfullClose` = '" + existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDetails + "', `ClosedDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDate) + ", `DisconnectedDate` = " + Rules.toSQLDate(existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDate) + ", `DisconnectReason` = '" + existingSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDetails + "', `CoustomerFeedBack` = '" + existingSalesLead.CustomerFeedBack + "', `Discount` = '" + existingSalesLead.Discount + "', `Notes` = '" + existingSalesLead.Notes + "' WHERE `customerproduct`.`SalesLeadsID` = " + existingSalesLead.SalesID + ";";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateCustomer, "?FileData", existingSalesLead.PurchaseOrderData);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 2
0
        public bool addToDatabase(Comment newComment)
        {
            string sqlAddComment = "INSERT INTO `salesleads`.`comment` (`Content`, `UserName`, `SalesLeadsID`, `PostDate`, `RealName`) VALUES ('" + newComment.Content + "', '" + newComment.UserName + "', " + newComment.SalesleadsID + ", " + Rules.toSQLDate(newComment.PostDate) + ", '" + newComment.RealName + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddComment);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 3
0
        public bool addToDatabase(SalesLead newSalesLead)
        {
            string sqlAddCustomer = "INSERT INTO `salesleads`.`customerproduct` (`SalesLeadsID`,`CustomerID`, `ProductID`, `IssueDate`, `RevenueType`, `MonthlyRevenue`, `HadTest`, `ProjectRevenue`,`ProjectPaid`, `CustomerConfirmDate`, `PurchaseOrderLocation`, `AgreementSignDate`,`DSP`,`FirstBillIssued`,`BillIssueDate`,`SuccessfullClose`,`ClosedDate`,`DisconnectedDate`,`DisconnectReason`,`CoustomerFeedBack`,`Discount`,`Notes`) VALUES (NULL, '" + newSalesLead.Customer.CustomerID + "', '" + newSalesLead.Product.ProductID + "', " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.SalesIssue).ActivityDate) + ", '" + newSalesLead.RevenueType + "', '" + newSalesLead.MonthlyRevenue + "', '" + Rules.boolToYesNo(newSalesLead.HadTest) + "', '" + newSalesLead.ProjectRevenue + "', '" + newSalesLead.ProjectPaid + "', " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.CustomerConfirm).ActivityDate) + ", ?FileData, " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.AgreementSign).ActivityDate) + ", " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.DSP).ActivityDate) + ", '" + newSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDetails + "', " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.BillIssue).ActivityDate) + ", '" + newSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDetails + "', " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.SalesClose).ActivityDate) + ", " + Rules.toSQLDate(newSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDate) + ", '" + newSalesLead.getSalesActivity(ActivityType.Disconect).ActivityDetails + "', '" + newSalesLead.CustomerFeedBack + "', '" + newSalesLead.Discount + "', '" + newSalesLead.Notes + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddCustomer, "?FileData", newSalesLead.PurchaseOrderData);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 4
0
        public bool addToDatabase(Product newProduct)
        {
            string sqlAddCustomer = "INSERT INTO `salesleads`.`product` (`ProductID`, `ProductName`, `Category`, `InitialPrice`, `ProductDetails`) VALUES (NULL, '" + newProduct.ProductName + "', '" + newProduct.ProductCategory + "', '" + newProduct.InitialPrice + "', '" + newProduct.ProductDetails + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddCustomer);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 5
0
        public bool updateToDatabase(Product existingProduct)
        {
            string sqlUpdateCustomer = "UPDATE `salesleads`.`product` SET `ProductName` = '" + existingProduct.ProductName + "', `Category` = '" + existingProduct.ProductCategory + "', `InitialPrice` = '" + existingProduct.InitialPrice + "', `ProductDetails` = '" + existingProduct.ProductDetails + "' WHERE `product`.`ProductID` = " + existingProduct.ProductID + ";";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateCustomer);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 6
0
        public bool updateToDatabase(User existingUser)
        {
            string sqlUpdateUser = "******" + existingUser.Name + "', `Permissions` = '" + existingUser.Permissions + "', `UserRating` = '" + existingUser.UserRating + "', `SalingsPerMonth` = '" + existingUser.MonthlyRevnue + "', `Predecessor` = '" + existingUser.Predecessor + "', `Notes` = '" + existingUser.Notes + "' WHERE `user`.`UserName` = '" + existingUser.UserName + "';";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateUser);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 7
0
        public bool updateToDatabaseQuotationData(Quotation existingQuotation)
        {
            string sqlUpdateQuotation = "UPDATE `salesleads`.`quatation` SET `QuotationLocation` = ?FileData  WHERE `quatation`.`QuatationID` = " + existingQuotation.QuotationID + ";";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateQuotation, "?FileData", existingQuotation.QuotationData);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 8
0
        public bool addToDatabase(User newUser)
        {
            string sqlAddUser = "******" + newUser.UserName + "', '" + newUser.Name + "', '" + newUser.Permissions + "', '" + newUser.UserRating + "', '" + newUser.MonthlyRevnue + "','" + newUser.Predecessor + "', '" + newUser.Notes + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddUser);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 9
0
        public bool addToDatabase(Quotation newQuotation)
        {
            string sqlAddQuotation = "INSERT INTO `salesleads`.`quatation` (`SalesLeadsID`, `QuatationDate`, `QuotationStatus`, `QuotationLocation`) VALUES ('" + newQuotation.SalesleadID + "', " + Rules.toSQLDate(newQuotation.QuotationDate) + ", '" + newQuotation.QuotationStatus + "', ?FileData);";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddQuotation, "?FileData", newQuotation.QuotationData);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 10
0
        public bool updateToDatabase(Quotation existingQuotation)
        {
            string sqlUpdateQuotation = "UPDATE `salesleads`.`quatation` SET `SalesLeadsID` = '" + existingQuotation.SalesleadID + "', `QuatationDate` = '" + existingQuotation.QuotationDate + "', `QuotationStatus` = '" + existingQuotation.QuotationStatus + "' WHERE `quatation`.`QuatationID` = " + existingQuotation.QuotationID + ";";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateQuotation);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 11
0
        public bool updateToDatabase(Customer existingCustomer)
        {
            string sqlUpdateCustomer = "UPDATE `salesleads`.`customer` SET `Name` = '" + existingCustomer.Name + "', `ShortName` = '" + existingCustomer.ShortName + "', `Address` = '" + existingCustomer.Address + "', `Email` = '" + existingCustomer.Email + "', `PhoneNo` = '" + existingCustomer.PhoneNo + "', `AccManager` = '" + existingCustomer.AccountManager + "' WHERE `customer`.`CustomerID` = " + existingCustomer.CustomerID + ";";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateCustomer);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 12
0
        public bool addToDatabase(Customer newCustomer)
        {
            string sqlAddCustomer = "INSERT INTO `salesleads`.`customer` (`CustomerID`, `Name`, `ShortName`, `Address`, `Email`, `PhoneNo`, `AccManager`) VALUES (NULL, '" + newCustomer.Name + "', '" + newCustomer.ShortName + "', '" + newCustomer.Address + "', '" + newCustomer.Email + "', '" + newCustomer.PhoneNo + "', '" + newCustomer.AccountManager + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddCustomer);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 13
0
        public System.Data.DataView readFromDatabase(int salesleadsID)
        {
            DBLink.openConnection();

            string sqlcomments = "SELECT * FROM `salesleads`.`comment` WHERE `SalesLeadsID`='" + salesleadsID + "';";

            DBLink.closeConnection();

            return(DBLink.executeTableQuarry(sqlcomments));
        }
Ejemplo n.º 14
0
        public bool updateToDatabase(Secure existingSecureData) // Update to database existingSecureData
        {
            string sqlUpdateSecureUser = "******" + existingSecureData.Password + "', `SecurityQuestion` = '" + existingSecureData.Question + "', `Answer` = '" + existingSecureData.Answer + "' WHERE `secure`.`UserName` = '" + existingSecureData.Username + "';";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlUpdateSecureUser);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 15
0
        public bool addToDatabase(Secure newSecureData)  // Add to database newSecureDAta
        {
            string sqlAddSecureUser = "******" + newSecureData.Username + "', '" + newSecureData.Password + "', '" + newSecureData.Question + "', '" + newSecureData.Answer + "');";

            DBLink.openConnection();
            bool result = DBLink.executeWriteQuarry(sqlAddSecureUser);

            DBLink.closeConnection();
            return(result);
        }
Ejemplo n.º 16
0
        //Chamil
        public List <String> getPredecessorList(int permission)
        {
            DBLink.openConnection();
            string query = "SELECT * FROM `salesleads`.`user` WHERE `Permissions`>'" + permission + "';";

            System.Data.DataTable predecessorTable = DBLink.executeTableQuarry(query).Table;
            List <String>         predecessorList  = new List <String>();


            for (int i = 0; i < predecessorTable.Rows.Count; i++)
            {
                predecessorList.Add((String)predecessorTable.Rows[i].ItemArray[0]);
            }

            DBLink.closeConnection();
            return(predecessorList);
        }