C# (CSharp) Data_Base_MNG SQL.Execute_Command_Open_Connection Examples

Example #1

File: bomCRUD.cs Project: Capsonic/APQM

    public bool delete(long id, ref Data_Base_MNG.SQL DM)
    {
        ErrorOccur = false;
        string query = "DELETE FROM BOMDetail WHERE BOMDetailKey=" + id;

        if (DM.Execute_Command_Open_Connection(query))
        {
            ErrorOccur   = DM.ErrorOccur;
            ErrorMessage = DM.Error_Mjs;
            return(true);
        }
        ErrorOccur   = DM.ErrorOccur;
        ErrorMessage = DM.Error_Mjs;
        return(false);
    }

Example #2

    public bool setActiveBySurveyID(long id, byte bActive, ref Data_Base_MNG.SQL DM)
    {
        ErrorOccur = false;
        string query = "UPDATE TokenMaster SET sys_active=" + bActive + " WHERE [Subject] = 'SURVEY' AND SubjectKey=" + id;

        if (DM.Execute_Command_Open_Connection(query))
        {
            ErrorOccur   = DM.ErrorOccur;
            ErrorMessage = DM.Error_Mjs;
            return(true);
        }
        ErrorOccur   = DM.ErrorOccur;
        ErrorMessage = DM.Error_Mjs;
        return(false);
    }

Example #3

File: bomCRUD.cs Project: Capsonic/APQM

    public bool setActive(long id, byte bActive, ref Data_Base_MNG.SQL DM)
    {
        ErrorOccur = false;
        string query = "UPDATE BOMDetail SET sys_active=" + bActive + " WHERE BOMDetailKey=" + id;

        if (DM.Execute_Command_Open_Connection(query))
        {
            ErrorOccur   = DM.ErrorOccur;
            ErrorMessage = DM.Error_Mjs;
            return(true);
        }
        ErrorOccur   = DM.ErrorOccur;
        ErrorMessage = DM.Error_Mjs;
        return(false);
    }

Example #4

    public bool deleteBySurveyID(long id, ref Data_Base_MNG.SQL DM)
    {
        ErrorOccur = false;
        string query = "DELETE FROM TokenMaster WHERE [Subject] = 'SURVEY' AND SubjectKey=" + id;

        if (DM.Execute_Command_Open_Connection(query))
        {
            ErrorOccur   = DM.ErrorOccur;
            ErrorMessage = DM.Error_Mjs;
            return(true);
        }
        ErrorOccur   = DM.ErrorOccur;
        ErrorMessage = DM.Error_Mjs;
        return(false);
    }