C# (CSharp) DBPROC.Get_ScalerInt Examples

Example #1

File: TaskRepository.cs Project: KHANFAIZAN05/Task_To_Do_List

        public bool DeleteTask(int Id)
        {
            int ret = -9;

            try
            {
                ret = DBPROC.Get_ScalerInt("Delete from Task Where TaskId =" + Id + ";");
                if (ret > -9)
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception)
            {
                throw;
            }
        }

Example #2

File: TaskRepository.cs Project: KHANFAIZAN05/Task_To_Do_List

        public bool UpdateTask(TaskList _task)
        {
            int ret = -9;

            try
            {
                string SqlQuery = "Update Task Set TaskName = '" + _task.TaskName + "', TskStatus ='" + _task.TaskStatus + "' where TaskId ='" + _task.TaskId + "'; ";

                ret = DBPROC.Get_ScalerInt(SqlQuery);
                if (ret > -9)
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception)
            {
                throw;
            }
        }